有没有大佬，提供个demo
【详述】starrocks 在创建oss 映射外部分区表时报错，创建表sql
CREATE EXTERNAL TABLE partition_test
(
vin STRING NULL ,
report_time STRING NULL ,
col_1 BIGINT NULL
)
ENGINE=FILE
PARTITION BY RANGE(report_time) (
PARTITION p1 VALUES LESS THAN (20241001),
PARTITION p2 VALUES LESS THAN (20241002)
)
– COMMENT “数据验证”
– LOCATION ‘oss://geea-sig-collect-prod/new_test/’ – 指定 OSS 中 Parquet 文件的路径
– FORMAT ‘parquet’ – 指定文件格式为 Parquet
PROPERTIES
(
“format” = “parquet”,
“compression” = “zstd”,
“aws.s3.enable_ssl” = “false”,
“aws.s3.access_key” = “xxxxx”,
“path” = “oss://a/partition_test/”,
“aws.s3.secret_key” = “exxxx”,
“aws.s3.endpoint” = “xxxx”,
“aws.s3.region” = “xxx”
);
报错信息：
SQL Error [1064] [42000]: Getting syntax error at line 15,007, column 35. Detail message: No viable statement for input ‘PARTITION BY RANGE(report_time) (
PARTITION p1 VALUES LESS THAN (20241001’.
Error position: line: 14