Vector Search Limitations

This document describes the known limitations of TiDB Vector Search.

Note

TiDB Vector Search is only available for TiDB Cloud Serverless clusters. It is not available for TiDB Cloud Dedicated.

Vector data type limitations

Each vector supports up to 16383 dimensions.
Vector data types cannot store NaN, Infinity, or -Infinity values.
Vector data types cannot store double-precision floating-point numbers. If you insert or store double-precision floating-point numbers in vector columns, TiDB converts them to single-precision floating-point numbers.
Vector columns cannot be used as primary keys or as part of a primary key.
Vector columns cannot be used as unique indexes or as part of a unique index.
Vector columns cannot be used as partition keys or as part of a partition key.
Currently, TiDB does not support modifying a vector column to other data types (such as JSON and VARCHAR).

The Data Migration feature in the TiDB Cloud console does not support migrating or replicating MySQL 9.0 vector data types to TiDB Cloud.

We value your feedback and are always here to help: