【详述】
datatime_test 表结构如下
CREATE TABLE `datatime_test` (
`tenementId` bigint(20) NULL COMMENT "",
`natureDateTime` datetime NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`tenementId`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`tenementId`) BUCKETS 8
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);
通过 insert into 插入的 datetime 数据中携带了微秒是会被过滤的
insert into datatime_test values(2,"2023-03-03 13:42:06.770000");
但是通过 stream-load 不会被过滤
curl -u root: -H "label:datatime_test_label" -H "db:test" -H "table:datatime_test" \
-H "column_separator:," \
-H "columns: tenementId, natureDateTime" \
-T /root/data.csv \
-XPUT http://{be_ip}:8040/api/test/datatime_test/_stream_load
其中 data.csv 数据如下
1, 2023-03-21 09:36:42.604000
查询
+------------+----------------------------+
| tenementId | natureDateTime |
+------------+----------------------------+
| 2 | 2023-03-03 13:42:06 |
| 1 | 2023-03-21 09:36:42.604000 |
+------------+----------------------------+
【业务影响】
会触发优化器统计错误
ColumnBasicStatsCacheLoader.convert2ColumnStatistics():159] convert TStatisticData to ColumnStatistics failed, db : test, table : datatime_test, column : natureDateTime, errMsg : Text '2023-03-21 09:36:42.604000' could not be parsed, unparsed text found at index 19
【StarRocks版本】例如：任意版本