Core features of OBKV-Table|V4.3.5|OceanBase Database|docs|OceanBase Documentations

Client	Description
Java	Supports Java clients.

Feature	Description
Single operations	Supports individual operations such as insert, put, update, delete, get, insertOrUpdate, increment, append, and checkAndInsertup.
Query	Supports queries with conditions or ranges. Supports ordered scans. Supports paginated queries.
Batch operations	Supports batch processing of single operations. Supports batch queries. Supports batch processing of mixed operations.
Aggregation	Supports basic aggregation functions, including min, max, sum, average, and count. Supports aggregation with conditions or range queries.
TTL	Supports table-level TTL (where the TTL policy is set at the table level, and all rows expire according to the table’s policy). Automatically deletes expired data. Note The expired data deletion (TTL) feature is available only in OceanBase KV scenarios. It is disabled in SQL scenarios to prevent unexpected data loss.
Indexes	Supports local indexes. Supports global indexes. Supports full-text indexes.

Feature	Description
Transactions	Supports row-level transactions for single operations. Supports single-machine transactions for batch operations. Does not support distributed transactions across nodes.
Disaster recovery	Reuses all disaster recovery capabilities of OceanBase Database, such as multi-replica architecture, primary-standby databases, and deployments of three IDCs in two regions or five IDCs in three regions.
Multi-tenancy	Reuses the multi-tenancy capabilities of OceanBase Database.
Scalability	Reuses the data partitioning and elastic scaling capabilities of OceanBase Database.
Backup and restore	Reuses the backup and restore capabilities of OceanBase Database.
Data compression	Supports storage data compression.
Data encryption	Supports transparent data encryption (TDE).

Core features of OBKV-Table