StarRocks使用过程中遇到的一些问题记录

1，{"status":"FAILED","msg":"There is no 100-continue header"}

增加 Expect:100-continue 参数

curl --location-trusted -u dxt:'******'  -T /app/bigdata_app/data/20220517.txt   -H "column_separator:^" -H "Expect:100-continue" http://127.0.0.1:8030/api/ods/ods_xxx/_stream_load

2,Error: The row is out of partition ranges. Please add a new partition.

分区表缺少对应的分区，需要手动添加分区

ALTER TABLE ods_xxx  SET("dynamic_partition.enable"="false");

先设置动态分区为false 再手动添加分区,start 包含日期 end 不包含

ALTER TABLE ods_xxx    ADD
PARTITIONS START ("2022-05-17") END ("2022-05-18") EVERY (interval 1 day);

配置后打开动态分区配置

ALTER TABLE ods_xxx SET("dynamic_partition.enable"="true");

 查看分区信息

show partitions from ods_xxx

3，Impli