✳flâneur — a map of the web's best reading

hackmit-2024/demo/SQLSyntax.md at main · intersystems-community/hackmit-2024

github.com · 482 words · saved by 1 readers

:alert: Please refer to the full product documentation for the full syntax and instructions. This page is for offline reference only. Optional parameters: This query will succeed following any of the above three table creations. It will default to the table's vector type. Parameters: Returns: the corresponding vector to be added to tables or used in other vector operations. Example: Parameters: Returns: a double value of the cosine distance between the two vectors, taking value from -1 to 1. Example: Parameters: Returns: a double value of the dot product of two vectors. Example: Getting the top 3 most similar vectors (to an input vector) from a table Using Cosine Similarity: Using Dot Product: Note that we use 'DESC', since a higher magnitude for dot product/cosine similarity means the vector is more similar. This can be combined with 'WHERE' clauses to add filters on other columns.

Using Vectors in IRIS SQL :alert: Please refer to the full product documentation for the full syntax and instructions. This page is for offline reference only. VECTOR (type, length) Optional parameters: type - Optional, defaults to DOUBLE. The datatype of elements allowed to be stored in the vector. Can be DECIMAL, DOUBLE, INTEGER, TIMESTAMP, or STRING. length - Optional, can be specified only if type is also specified. An integer for the number of elements allowed to be stored in the vector. If specified, length restriction for INSERT INTO the vector column will be imposed. Creating a table w

Explore this link on the map →

related reading