OceanBase Database provides the capabilities for storing, indexing, and searching embedding vector data. Specifically, it includes:
| Core features | Description |
|---|---|
| Vector data type | Supports storing float vectors with a maximum dimension of 16,000. |
| Vector index |
|
| Vector search SQL operators | Supports basic operators for vector addition, subtraction, multiplication, comparison, and aggregation. |
Limitations
By default, OceanBase Database uses the NULL first comparison mode. Therefore, when sorting NULL values, they are placed at the beginning. We recommend that you add a
NOT NULLcondition in your queries.Vector indexes and full-text indexes cannot be defined on the same table.