ALTER TABLE chnl_income ADD PARTITION (PARTITION plat_income_202104 VALUES IN (202104))
SELECT
PARTITION_NAME,
TABLE_ROWS,
PARTITION_EXPRESSION,
PARTITION_DESCRIPTION
FROM
INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_NAME = 'chnl_income' ;
ALTER TABLE chnl_income ADD PARTITION (PARTITION plat_income_202104 VALUES IN (202104))
SELECT
PARTITION_NAME,
TABLE_ROWS,
PARTITION_EXPRESSION,
PARTITION_DESCRIPTION
FROM
INFORMATION_SCHEMA.PARTITIONS
WHERE TABLE_NAME = 'chnl_income' ;