有没有Fluss创建分区表的案例?

提问者:帅平 问题分类:大数据
有没有Fluss创建分区表的案例?
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属地:四川省
我来回答