PRIMARY KEY (id, resource),
) PARTITION BY LIST (resource) (
PARTITION alarm_p1 VALUES IN (1),
PARTITION alarm_p2 VALUES IN (2),
PARTITION alarm_p3 VALUES IN (3),
PARTITION alarm_p4 VALUES IN (4),
PARTITION alarm_p5 VALUES IN (5)
);
resource 的值为 ,1,2,3,4, 四个类型
上面是建表语句, 但是下面的查询并没有查到建的分区表的数据库,