VECTOR

The VECTOR data type, for storing fixed-length numeric arrays used in vector search.

Vectors are available from MariaDB Community Server 11.7 and from MariaDB Enterprise Server 11.4.5-3.

Syntax

VECTOR(N)

Description

The VECTOR data type was added as part of the vectors feature, which permits MariaDB Server to perform as a relational vector database. N represents the fixed number of dimensions of the vector up to a maximum of 16383. The N dimension will be determined by the embedding algorithm.

Example

CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY, v VECTOR(5) NOT NULL,
 VECTOR INDEX (v));

See Also

• CREATE TABLE with Vectors

_{This page is licensed: CC BY-SA / Gnu FDL}