1、多列分区
CREATE TABLE test.pt (
start_time int,
end_time int,
c INT
)
PARTITION BY RANGE COLUMNS (end_time, start_time)
(
PARTITION p201305 VALUES LESS THAN (1370016000,1370016000),
PARTITION p201306 VALUES LESS THAN (1372608000,1372608000),
PARTITION p201307 VALUES LESS THAN (1375286400,1375286400)
);
数字型字段,分区不支持float、double、decimal等。
2、添加分区
ALTER TABLE test.pt ADD PARTITION (PARTITION p201308 VALUES LESS THAN (1378000800,1378000800));
3、查看分区情况
SELECT
partition_name,
partition_expression,
partition_description,
table_rows
FROM
INFORMATION_SCHEMA.partitions
WHERE
TABLE_SCHEMA = 'test'
AND TABLE_NAME='pt';