版本：3.2.1
sql：
CREATE TABLE st_sensors_events_glacier_inc1 (
event varchar(65533) NULL COMMENT “事件名”,
user_id varchar(65533) NULL COMMENT “神策用户id”,
time bigint(20) NULL COMMENT “事件时间”,
row_json varchar(65533) NULL COMMENT “埋点日志”,
properties varchar(65533) NULL COMMENT “业务数据”,
dayno varchar(65533) NULL COMMENT “dayno”,
hour varchar(65533) NULL COMMENT “hour”
) ENGINE=OLAP
DUPLICATE KEY(event)
COMMENT “OLAP”
PARTITION BY date_trunc(‘day’, str2date(dayno,’%Y-%m-%d’))
DISTRIBUTED BY HASH(dayno, event)
PROPERTIES (
“replication_num” = “1”,
“datacache.enable” = “true”,
“storage_volume” = “builtin_storage_volume”,
“enable_async_write_back” = “false”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
);
报错：
ERROR 1064 (HY000): Getting syntax error from line 12, column 13 to line 12, column 57. Detail message: Unsupported expr ‘date_trunc(‘day’, str2date(dayno, ‘%Y-%m-%d’))’ in PARTITION BY clause.
