Page History

...

CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};

CREATE TABLE test.foo(
   i INT PRIMARY KEY, 
   j VECTOR<float, 3>
); 

CREATE CUSTOM INDEX ann_index ON foo(j) USING 'StorageAttachedIndexVectorMemtableIndex';

INSERT INTO test.foo (i, j) VALUES (1, [8, 2.3, 58]); 
INSERT INTO test.foo (i, j) VALUES (2, [1.2, 3.4, 5.6]);
INSERT INTO test.foo (i, j) VALUES (5, [23, 18, 3.9]); 

SELECT * FROM test.foo WHERE j ANN OF [3.4, 7.8, 9.1] limit 1;

i  |j 
---+---------------------------------------------------------
5  |[23, 18, 3.9] 

...