Muzi999 commented on issue #30037: URL: https://github.com/apache/doris/issues/30037#issuecomment-2066071904
> ### Search before asking > * [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.我在问题中搜索过，没有发现类似的问题。 > > ### Version > 2.0.3 > > ### What's Wrong? > 1. 挂载paimon catalog > > CREATE CATALOG `paimon_s3` PROPERTIES (创建目录 `paimon_s3` 属性 ( "type" = "paimon", “类型”=“派蒙”， "warehouse" = "s3://paimon-1308700295.cos.ap-beijing.myqcloud.com/paimoncos","仓库" = "s3://paimon-1308700295.cos.ap-beijing.myqcloud.com/paimoncos", "s3.endpoint" = "cos.ap-beijing.myqcloud.com", "s3.access_key" = "ak", “s3.access_key”=“ak”， "s3.secret_key" = "sk" “s3.secret_key”=“sk” ); > > 2. 执行sql > switch paimon_s3; > use `default`; > select * from order where orderId is null; > > 3.报错信息 > > 2024-01-17 09:39:48,842 WARN (mysql-nio-pool-132|105023) [StmtExecutor.analyze():1009] Analyze failed. stmt[2804, f7527339f184618-8e4cea723f63acea]2024-01-17 09:39:48,842 警告 (mysql-nio-pool-132|105023) [StmtExecutor.analyze():1009] 分析失败。 stmt[2804, f7527339f184618-8e4cea723f63acea] java.lang.ClassCastException: org.apache.doris.analysis.IsNullPredicate cannot be cast to org.apache.doris.analysis.BinaryPredicatejava.lang.ClassCastException：org.apache.doris.analysis.IsNullPredicate 无法转换为 org.apache.doris.analysis.BinaryPredicate at org.apache.doris.planner.external.paimon.PaimonPredicateConverter.binaryExprDesc(PaimonPredicateConverter.java:87) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.external.paimon.PaimonPredicateConverter.binaryExprDesc(PaimonPredicateConverter.java:87) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.external.paimon.PaimonPredicateConverter.convertToPaimonExpr(PaimonPredicateConverter.java:81) ~[doris-fe.jar:1. 2-SNAPSHOT]在 org.apache.doris.planner.external.paimon.PaimonPredicateConverter.convertToPaimonExpr(PaimonPredicateConverter.java:81) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.external.paimon.PaimonPredicateConverter.convertToPaimonExpr(PaimonPredicateConverter.java:53) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.external.paimon.PaimonPredicateConverter.convertToPaimonExpr(PaimonPredicateConverter.java:53) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.external.paimon.PaimonScanNode.doInitialize(PaimonScanNode.java:79) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.external.paimon.PaimonScanNode.doInitialize(PaimonScanNode.java:79) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.external.FileQueryScanNode.init(FileQueryScanNode.java:119) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.external.FileQueryScanNode.init(FileQueryScanNode.java:119) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner .createScanNode(SingleNodePlanner.java:2057) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createScanNode(SingleNodePlanner.java:2057) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:2206) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:2206) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:1242) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:1242) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:264) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:264) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createInlineViewPlan(SingleNodeP lanner.java:1663) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createInlineViewPlan(SingleNodePlanner.java:1663) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:2210) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:2210) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:1242) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:1242) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:264) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:264) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:187) ~[do ris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:187) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.OriginalPlanner.createPlanFragments(OriginalPlanner.java:160) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.planner.OriginalPlanner.createPlanFragments(OriginalPlanner.java:160) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.OriginalPlanner.plan(OriginalPlanner.java:101) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.planner.OriginalPlanner.plan(OriginalPlanner.java:101) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1158) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1158) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:992) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:992) ~[do ris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:684) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:684) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:456) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:456) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:429) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:429) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:435) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:435) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:583) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.ConnectProcessor.dispatch(Conne ctProcessor.java:583) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:834) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:834) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] 在 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_392] 在 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392] 在 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392] at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392] 在 java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392] 2024-01-17 09:39:48,843 WARN (mysql-nio-pool-132|105023) [StmtExecutor.executeByLegacy():790] execute Exception. stmt[2804, f7527339f184618-8e4cea723f63acea]2024-01-17 09:39:48,843 警告 (mysql-nio-pool-132|105023) [StmtExecutor.executeByLegacy():790] 执行异常。 stmt[2804, f7527339f184618-8e4cea723f63acea] org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Unexpected exception: org.apache.doris.analysis.IsNullPredicate cannot be cast to org.apache.doris.analysis.BinaryPredicateorg.apache.doris.common.AnalysisException：errCode = 2，detailMessage =意外异常：org.apache.doris.analysis.IsNullPredicate 无法转换为 org.apache.doris.analysis.BinaryPredicate at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1010) ~[doris-fe.jar:1.2-SNAPSHOT]在 org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1010) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:684) ~[doris-fe.jar:1.2-SNAPSHOT] � �� org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:684) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:456) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:456) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:429) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:429) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:435) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:435) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:583) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:583) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:834) ~[doris-fe.jar:1.2-SNAPSHOT] 在 org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:834) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] 在 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_392] 在 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392] 在 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392] at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392] 在 java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392] > > ### What You Expected? > select * from order where orderId is null; is null 能正确执行select * from orderId 为 null 的订单；为 null 能正确执行 > > ### How to Reproduce? > _No response_ > > ### Anything Else? > _No response_ > > ### Are you willing to submit PR? > 你愿意提交PR吗？ > * [ ] Yes I am willing to submit a PR!是的，我愿意提交 PR！ > > ### Code of Conduct > * [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)我同意遵守该项目的行为准则 I'm also experiencing this problem, what can I do to solve it? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
