Results of 1 - 1 of about 1 for prefilter (0.000 sec.)
- Lance Extension 9414
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...CT id, label, _distance FROM lance_vector_search( '⟨path/to/dataset.lance⟩', 'vec', [0.1, 0.2, 0.3, 0.4]::FLOAT[4], k = 5, prefilter = true ) ORDER BY _distance ASC; See the SQL reference for full parameter documentation . Full-Text Search (FTS) -- Search...g BM25-like scores in `_score` SELECT id, text, _score FROM lance_fts( '⟨path/to/dataset.lance⟩', 'text', 'puppy', k = 10, prefilter = true ) ORDER BY _score DESC; See the SQL reference for full parameter documentation . Hybrid Search (Vector + FTS) -- Co..._score FROM lance_hybrid_search('⟨path/to/dataset.lance⟩', 'vec', [0.1, 0.2, 0.3, 0.4]::FLOAT[4], 'text', 'puppy', k = 10, prefilter = false, alpha = 0.5, oversample_factor = 4) ORDER BY _hybrid_score DESC; Limitations The lance extension is currently ava... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work