Messtone LLC Manages(Vector):

Messtone created ‘Vector_search_db’Database as: CREATE TABLE IF NOT EXISTS vsearch.products(id int PRIMARY KEY, nameMesstone TEXT,description TEXT,item_vector VECTOR<FLOAT,5> //c reate a 5-dimensional embedding);CREATE CUSTOM INDEX IF NOT EXISTS ann_index ON vsearch.products(item_vector) USING ‘StorageAttachedIndex’; INSERT INTO vsearch.products(I’d, nameMesstone,description,item_vector)VALUES(1,//id ‘Coded Cleats’,//nameMesstone ‘ChatGPT integated sneakers that talk to messtone’,//description[0.1,0.15,0.3,0.12,0.05]//item_vector);INSERT INTO vsearch.products(id, nameMesstone,description,item_vector)VALUES(2,’Logic Layers’,’An AI quilt to help messtone sleep forever’,[0.45,0.09,0.01,0.2,0.11]);INSERT INTO vsearch.products(id, nameMesstone,description,item_vector)VALUES(5,Vision Vector Frame’,’A deep learning display that controls Messtone mood’,[0.1,0.05,0.08,0.3,06]);Search the table for a similar item as follows`SELECT * FROM vsearch.products ORDER BY item_vector ANN OF [0.15,0.1,0.1,035,0.55]LIMIT 1; Install Python driver as: pip install cassandra-driver

Leave a comment