Search¶

Based on Apache Lucene, CrateDB offers native BM25 term search and vector search, all using SQL. By combining it, also using SQL, you can implement powerful single-query hybrid search.

All search features of CrateDB at a glance.

Full-Text Search

Inverted index and Okapi BM25 search ranking based on Apache Lucene at scale, using SQL as lingua franca.

BM25 term search using SQL: CrateDB is all you need.

Full-Text Search

Geo Search

Supports location data for efficiently storing and querying geographic and spatial/geospatial data.

Geospatial search is based on BKD tree index structures.

Geospatial Search

Vector Search

HNSW data retrieval on ML vector embeddings enables semantic search on your fingertips, using standard SQL.

Vector search on machine learning embeddings: CrateDB is all you need.

Vector Search

Hybrid Search

Combines FTS and HNSW technologies, unlocking the best of both worlds in term-based and semantic search.

Enhance relevancy and accuracy by combining multiple search algorithms.

Hybrid Search