V3.1.5版本是否支持time_slice分区
PARTITION BY time_slice(imgbd_partition, INTERVAL 7 DAY)
创建报错。提示unsupported time_slice,如果我要按照七天分区怎么分呢,目前基表是按照7天分区
V3.1.5版本是否支持time_slice分区
PARTITION BY time_slice(imgbd_partition, INTERVAL 7 DAY)
创建报错。提示unsupported time_slice,如果我要按照七天分区怎么分呢,目前基表是按照7天分区
可以使用语法:
CREATE MATERIALIZED VIEW <name>
PARTITION BY pdt
AS
SELECT time_slice(imgbd_partition, INTERVAL 7 DAY) as pdt, ....