Note
This view is introduced in V4.3.5 BP3.
Purpose
The oceanbase.CDB_OB_KV_REDIS_TABLE view stores the specific commands for various data structures in Redis for all tenants, along with the corresponding names of the storage tables.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| COMMAND_NAME | varchar(1024) | NO | The name of the Redis command, such as get, set, and 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 will be updated during a replace operation. |
Examples
Query the specific commands for various data structures in Redis for all tenants, along with the corresponding names of the storage tables.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_KV_REDIS_TABLE LIMIT 10;
The query result is as follows:
+------------------+-------------------------+----------------------------+----------------------------+
| COMMAND_NAME | TABLE_NAME | GMT_CREATE | GMT_MODIFIED |
+------------------+-------------------------+----------------------------+----------------------------+
| append | obkv_redis_string_table | 2024-10-18 15:37:14.892133 | 2024-10-18 15:37:14.892133 |
| bitcount | obkv_redis_string_table | 2024-10-18 15:37:14.892133 | 2024-10-18 15:37:14.892133 |
| decr | obkv_redis_string_table | 2024-10-18 15:37:14.891078 | 2024-10-18 15:37:14.891078 |
| decrby | obkv_redis_string_table | 2024-10-18 15:37:14.891078 | 2024-10-18 15:37:14.891078 |
| del | obkv_redis_string_table | 2024-10-18 15:37:14.905749 | 2024-10-18 15:37:14.905749 |
| exists | obkv_redis_string_table | 2024-10-18 15:37:14.903640 | 2024-10-18 15:37:14.903640 |
| expire | obkv_redis_string_table | 2024-10-18 15:37:14.901581 | 2024-10-18 15:37:14.901581 |
| expireat | obkv_redis_string_table | 2024-10-18 15:37:14.900527 | 2024-10-18 15:37:14.900527 |
| get | obkv_redis_string_table | 2024-10-18 15:37:14.893146 | 2024-10-18 15:37:14.893146 |
| getbit | obkv_redis_string_table | 2024-10-18 15:37:14.894190 | 2024-10-18 15:37:14.894190 |