环境:doris 版本为2.0.7
iceberg 表结构如下:
MySQL [(none)]> desc iceberg.sdm.s_bwt_ttsp_tdtp_j_trip_order;
+----------------------+----------------+------+------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+----------------+------+------+---------+-------+
| ttsp_order_no | TEXT | Yes | true | NULL | |
| biz_id | TEXT | Yes | true | NULL | |
| order_no | TEXT | Yes | true | NULL | |
| trip_no | TEXT | Yes | true | NULL | |
| fellow_no | TEXT | Yes | true | NULL | |
| fee_mode | TEXT | Yes | true | NULL | |
| trans_time | DATETIME(6) | Yes | true | NULL | |
| trans_amount | DECIMAL(16, 2) | Yes | true | NULL | |
| base_amount | DECIMAL(16, 2) | Yes | true | NULL | |
| discount_amount | DECIMAL(16, 2) | Yes | true | NULL | |
| discount_desc | TEXT | Yes | true | NULL | |
| fine_amount | DECIMAL(16, 2) | Yes | true | NULL | |
| fine_desc | TEXT | Yes | true | NULL | |
| settlement_mode | TEXT | Yes | true | NULL | |
| settlement_amount | DECIMAL(16, 2) | Yes | true | NULL | |
| app_id | TEXT | Yes | true | NULL | |
| trace_no | TEXT | Yes | true | NULL | |
| recv_time | DATETIME(6) | Yes | true | NULL | |
| sync_time | DATETIME(6) | Yes | true | NULL | |
| sync_status | TEXT | Yes | true | NULL | |
| sync_remark | TEXT | Yes | true | NULL | |
| settle_rec_id | TEXT | Yes | true | NULL | |
| settle_status | TEXT | Yes | true | NULL | |
| settle_type | TEXT | Yes | true | NULL | |
| terminal_no | TEXT | Yes | true | NULL | |
| settle_date | TEXT | Yes | true | NULL | |
| settle_time | DATETIME(6) | Yes | true | NULL | |
| settle_err_code | TEXT | Yes | true | NULL | |
| settle_err_msg | TEXT | Yes | true | NULL | |
| settle_err_detail | TEXT | Yes | true | NULL | |
| trip_sts_seq | INT | Yes | true | NULL | |
| voucher_data_carrier | TEXT | Yes | true | NULL | |
| extra | TEXT | Yes | true | NULL | |
| payment_time | DATETIME(6) | Yes | true | NULL | |
| channel_serial_no | TEXT | Yes | true | NULL | |
| sys_tra_no | TEXT | Yes | true | NULL | |
| order_tra_time | DATETIME(6) | Yes | true | NULL | |
| clearing_date | TEXT | Yes | true | NULL | |
| trans_curr_cd | TEXT | Yes | true | NULL | |
| trans_at | DECIMAL(16, 2) | Yes | true | NULL | |
| batch_no | TEXT | Yes | true | NULL | |
| order_source | TEXT | Yes | true | NULL | |
| table_update | DATETIME(6) | Yes | true | NULL | |
+----------------------+----------------+------+------+---------+-------+
查询语句:
select ttsp_order_no,recv_time from iceberg.sdm.s_bwt_ttsp_tdtp_j_trip_order where recv_time='2024-01-01 00:00:01';
报错信息:
Unexpected exception: Text '2024-01-01 00:00:01' could not be parsed at index 10
fe.log :
2024-04-12 10:02:21,465 WARN (mysql-nio-pool-174|16349) [StmtExecutor.analyze():1037] Analyze failed. stmt[6115, 60dabb267bdf4f79-9c2fe976f74cb31a]
java.lang.RuntimeException: Text '2024-01-01 00:00:01' could not be parsed at index 10
at org.apache.doris.catalog.HiveMetaStoreClientHelper.ugiDoAs(HiveMetaStoreClientHelper.java:945) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.external.iceberg.IcebergScanNode.getSplits(IcebergScanNode.java:181) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.external.FileQueryScanNode.createScanRangeLocations(FileQueryScanNode.java:265) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.external.FileQueryScanNode.doFinalize(FileQueryScanNode.java:220) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.external.FileQueryScanNode.finalize(FileQueryScanNode.java:207) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OriginalPlanner.createPlanFragments(OriginalPlanner.java:207) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OriginalPlanner.plan(OriginalPlanner.java:101) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1186) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1020) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:711) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:483) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:451) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:435) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:584) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:849) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_144]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_144]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_144]
2024-04-12 10:02:21,466 WARN (mysql-nio-pool-174|16349) [StmtExecutor.executeByLegacy():818] execute Exception. stmt[6115, 60dabb267bdf4f79-9c2fe976f74cb31a]
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Unexpected exception: Text '2024-01-01 00:00:01' could not be parsed at index 10
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1038) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:711) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:483) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:451) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:435) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:584) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:849) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_144]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_144]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_144]