| 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.
|
