Note
This view is introduced in V4.3.5 BP2.
Purpose
This view displays the information about dynamic partitioned tables for all tenants. This view is accessible only to the system tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID where the dynamic partitioned table is located. |
| DATABASE_NAME | varchar(128) | NO | The name of the database where the dynamic partitioned table resides. |
| TABLE_NAME | varchar(256) | NO | The name of the dynamic partitioned table. |
| TABLE_ID | bigint(20) | NO | The ID of the dynamic partitioned table. |
| MAX_HIGH_BOUND_VAL | varchar(4096) | NO | The maximum range partition upper bound. |
| ENABLE | varchar(4096) | NO | Whether dynamic partition management is enabled. |
| TIME_UNIT | varchar(4096) | NO | The value of time_unit in dynamic partition management. |
| PRECREATE_TIME | varchar(4096) | NO | The value of precreate_time in dynamic partition management. |
| EXPIRE_TIME | varchar(4096) | NO | The value of expire_time in dynamic partition management. |
| TIME_ZONE | varchar(4096) | NO | The value of time_zone in dynamic partition management. |
| BIGINT_PRECISION | varchar(4096) | NO | The value of bigint_precision in dynamic partition management. |