Using Vector Functions

Resources

The following resources provide information about SingleStore's vector processing:

• Vector Type: The native vector data type. 

• Working with Vector Data: Vector similarity search.

• How to Bulk Load Vectors: Load larger vector data sets using a binary format.

• Vector Indexing: Indexed Approximate Nearest Neighbor (ANN) vector similarity search.

• Hybrid Search - Re-ranking and Blending Searches: Combine indexed (ANN) vector similarity search and full-text search.

• Tuning Vector Indexes and Queries: Adjust the index building and searching parameters to meet your application's needs for query accuracy and performance.

The following functions are available for the vector type:

• DOT_PRODUCT: Calculate the dot product of two vectors.

• EUCLIDEAN_DISTANCE: Calculate the Euclidean distance between two vectors.

• Cosine Similarity and Cosine Distance: Calculate the cosine similarity and distance metrics.

• SCALAR_VECTOR_MUL: Multiply a vector by a scalar value.

• VECTOR_ADD: Add two vectors.

• VECTOR_ELEMENTS_SUM: Sum all the elements in a vector.

• VECTOR_KTH_ELEMENT: Find the kth element of a vector.

• VECTOR_MUL: Multiply two vectors element-wise.

• VECTOR_NUM_ELEMENTS: Count the number of elements in a vector.

• VECTOR_SORT: Sort a vector.

• VECTOR_SUB: Subtract one vector from a second vector.