Note
This view was introduced in OceanBase Database V4.2.5.
Purpose
The oceanbase.CDB_OB_KV_REDIS_TABLE displays the commands specific to various data structures of Redis, and the corresponding table names in all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| COMMAND_NAME | varchar(1024) | NO | The name of the Redis command, for example, get, set, or hgetall. |
| TABLE_NAME | varchar(OB_MAX_TABLE_NAME_LENGTH) | NO | The name of the data table. |
| GMT_CREATE | timestamp(6) | NO | The creation time. |
| GMT_MODIFIED | timestamp(6) | NO | The last modification time, which is changed after a replace operation is performed. |
Sample query
SELECT * FROM oceanbase.CDB_OB_KV_REDIS_TABLE LIMIT 10;
+-----------+------------------+-------------------------+----------------------------+----------------------------+
| TENANT_ID | COMMAND_NAME | TABLE_NAME | GMT_CREATE | GMT_MODIFIED |
+-----------+------------------+-------------------------+----------------------------+----------------------------+
| 1004 | append | obkv_redis_string_table | 2024-10-18 15:37:14.892133 | 2024-10-18 15:37:14.892133 |
| 1004 | bitcount | obkv_redis_string_table | 2024-10-18 15:37:14.892133 | 2024-10-18 15:37:14.892133 |
| 1004 | decr | obkv_redis_string_table | 2024-10-18 15:37:14.891078 | 2024-10-18 15:37:14.891078 |
| 1004 | decrby | obkv_redis_string_table | 2024-10-18 15:37:14.891078 | 2024-10-18 15:37:14.891078 |
| 1004 | del | obkv_redis_string_table | 2024-10-18 15:37:14.905749 | 2024-10-18 15:37:14.905749 |
| 1004 | exists | obkv_redis_string_table | 2024-10-18 15:37:14.903640 | 2024-10-18 15:37:14.903640 |
| 1004 | expire | obkv_redis_string_table | 2024-10-18 15:37:14.901581 | 2024-10-18 15:37:14.901581 |
| 1004 | expireat | obkv_redis_string_table | 2024-10-18 15:37:14.900527 | 2024-10-18 15:37:14.900527 |
| 1004 | get | obkv_redis_string_table | 2024-10-18 15:37:14.893146 | 2024-10-18 15:37:14.893146 |
| 1004 | getbit | obkv_redis_string_table | 2024-10-18 15:37:14.894190 | 2024-10-18 15:37:14.894190 |