Skip to main content Link Menu Expand (external link) Document Search Copy Copied


COSINE_DISTANCE() is a mathematical function used with vector calculations.


COSINE_DISTANCE ({compare-vector, vector-column})


Argument Description Additional information
compare-vector A comma separated list of floating point numbers to be compared which can be derived using a nested SELECT statement SELECT statement
vector-column Column with vector() datatype in target table to compare against VECTOR() data type


Table CREATE with vector data type

CREATE TABLE products (_id id, description string, dabed vector(768));

INSERT INTO vector data type

INSERT INTO products VALUES({_id}, '{tools_array[i]}', {dabed});

SELECT with COSINE_DISTANCE from vector column

SELECT id, description, cosine_distance([-0.027067707851529, 0.009963636286557, 0.034747183322906], dabed) AS rank FROM products;