表相关操作

# 查看表当前的分区情况
SHOW PARTITIONS FROM site_access;

mysql> SHOW PARTITIONS FROM detailDemo;
+-------------+---------------+----------------+---------------------+--------------------+--------+--------------+----------------------------------------------------------------------------+--------------------------+---------+----------------+---------------+---------------------+--------------------------+----------+------------+----------+
| PartitionId | PartitionName | VisibleVersion | VisibleVersionTime  | VisibleVersionHash | State  | PartitionKey | Range                                                                      | DistributionKey          | Buckets | ReplicationNum | StorageMedium | CooldownTime        | LastConsistencyCheckTime | DataSize | IsInMemory | RowCount |
+-------------+---------------+----------------+---------------------+--------------------+--------+--------------+----------------------------------------------------------------------------+--------------------------+---------+----------------+---------------+---------------------+--------------------------+----------+------------+----------+
| 70013       | p20220311     | 1              | 2023-10-30 17:17:36 | 0                  | NORMAL | recruit_date | [types: [DATE]; keys: [2022-03-11]; ..types: [DATE]; keys: [2022-03-12]; ) | recruit_date, region_num | 6       | 1              | HDD           | 9999-12-31 23:59:59 | NULL                     | 0B       | false      | 0        |
| 70014       | p20220312     | 1              | 2023-10-30 17:17:36 | 0                  | NORMAL | recruit_date | [types: [DATE]; keys: [2022-03-12]; ..types: [DATE]; keys: [2022-03-13]; ) | recruit_date, region_num | 6       | 1              | HDD           | 9999-12-31 23:59:59 | NULL                     | 0B       | false      | 0        |
| 70015       | p20220313     | 1              | 2023-10-30 17:17:36 | 0                  | NORMAL | recruit_date | [types: [DATE]; keys: [2022-03-13]; ..types: [DATE]; keys: [2022-03-14]; ) | recruit_date, region_num | 6       | 1              | HDD           | 9999-12-31 23:59:59 | NULL                     | 0B       | false      | 0        |
| 70016       | p20220314     | 1              | 2023-10-30 17:17:36 | 0                  | NORMAL | recruit_date | [types: [DATE]; keys: [2022-03-14]; ..types: [DATE]; keys: [2022-03-15]; ) | recruit_date, region_num | 6       | 1              | HDD           | 9999-12-31 23:59:59 | NULL                     | 0B       | false      | 0        |
| 70017       | p20220315     | 1              | 2023-10-30 17:17:36 | 0                  | NORMAL | recruit_date | [types: [DATE]; keys: [2022-03-15]; ..types: [DATE]; keys: [2022-03-16]; ) | recruit_date, region_num | 6       | 1              | HDD           | 9999-12-31 23:59:59 | NULL                     | 0B       | false      | 0        |
+-------------+---------------+----------------+---------------------+--------------------+--------+--------------+----------------------------------------------------------------------------+--------------------------+---------+----------------+---------------+---------------------+--------------------------+----------+------------+----------+
5 rows in set (0.00 sec)


# 修改表的动态分区属性-暂停或者开启动态分区特性（使用SHOW CREATE TABLE 命令，查看表的动态分区属性）
ALTER TABLE site_access SET("dynamic_partition.enable"="false");
ALTER TABLE site_access SET("dynamic_partition.enable"="true");