1 个回答
fluss创建分区表的示例sql如下:
CREATE TABLE site_access(
event_day STRING,
site_id INT,
city_code STRING,
user_name STRING,
pv BIGINT,
PRIMARY KEY(event_day, site_id)
NOT ENFORCED )
PARTITIONED BY (event_day)
WITH (
'table.auto-partition.enabled' = 'true',
'table.auto-partition.time-unit' = 'YEAR',
'table.auto-partition.num-precreate' = '5',
'table.auto-partition.num-retention' = '2',
'table.auto_partitioning.time-zone' = 'Asia/Shanghai');
发布于:3个月前 (01-17) IP属地:四川省
我来回答
您需要 登录 后回答此问题!