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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org