Hybrid Search Example

Applications can filter users in a geographic area by filtering first on tag information, and then using an ANN query with geospatial vector embeddings

CREATE TABLE users ( 
id UUID PRIMARY KEY, 
state text, 
city int,
tags set<text>,
sem_vec vector<float, 384> 
);

CREATE CUSTOM INDEX ON catalog(tags) USING 'StorageAttachedIndex'
CREATE CUSTOM INDEX ON catalog(sem_vec) USING 'StorageAttachedIndex'

SELECT * FROM users 
WHERE tags CONTAINS 'drink:coffee' 
ORDER BY sem_vec ANN OF [...];