lancedb / lance

Modern columnar data format for ML and LLMs implemented in Rust. Convert from parquet in 2 lines of code for 100x faster random access, vector index, and data versioning. Compatible with Pandas, DuckDB, Polars, Pyarrow, with more integrations coming..
https://lancedb.github.io/lance/
Apache License 2.0
3.46k stars 180 forks source link

Lance does not recognize `is_foo` as an indexable query when `is_foo` is a boolean column #2312

Closed westonpace closed 3 weeks ago

westonpace commented 1 month ago

If we have a boolean column is_foo then we should be able to use the filter 'is_foo'. However, lance does not recognize that this filter is a candidate for scalar indices. It does recognize 'is_foo IS TRUE' but we shouldn't require users to do that.