Assistance with Combined Filters in Databricks Vector Store Index
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā10-17-2024 12:40 AM
Hi,
Iām working with the Databricks vector store index and need to apply combined filters to retrieve chunks that meet specific criteria.
My index contains the following columns: product_category, product_date, and description.
Question 1: How can I retrieve all chunks that meet this filter criteria:
- Product category is either:
- Category 1 with dates from 2015-2016, or
- All products from Category 2?
Question 2: How can I filter to get only those chunks where the description contains both term1 and term2?
I would appreciate a prompt response.
Helpful links: Databricks API Documentation
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā10-23-2024 10:53 PM
You can achieve that by using metadata filtering when querying the VS index. Check this section in our VS Index documentation: https://docs.databricks.com/en/generative-ai/create-query-vector-search.html#query-a-vector-search-e...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā12-12-2024 04:33 AM
How do we do multiple filters? for example I want to filter a vector store by two columns with an AND logic.
![](/skins/images/8C2A30E5B696B676846234E4B14F2C7B/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/8C2A30E5B696B676846234E4B14F2C7B/responsive_peak/images/icon_anonymous_message.png)