[ https://issues.apache.org/jira/browse/DRILL-8238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Turton closed DRILL-8238. ------------------------------- > Translation of IS NOT NULL($1) is not supported by MongoProject > --------------------------------------------------------------- > > Key: DRILL-8238 > URL: https://issues.apache.org/jira/browse/DRILL-8238 > Project: Apache Drill > Issue Type: Bug > Components: Storage - MongoDB > Affects Versions: 1.20.1 > Environment: Affects Drill 1.20 and not Drill 1.19. Projection push > down is probably enabled when it breaks in 1.20. > Reporter: James Turton > Assignee: James Turton > Priority: Major > Fix For: 1.20.3 > > > Running > {{}} > {code:java} > SELECT COALESCE(`Filename`,'sdfsafdsd') > FROM dd7819ee-438e-429b-9a3a-a68c7f1cc123 > LIMIT 500 > {code} > > produces > {code:java} > Caused by: > org.apache.drill.exec.work.foreman.ForemanException: Unexpected > exception during fragment initialization: Translation of IS NOT NULL($2) > is not supported by MongoProject at > org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:301) at > .......(:0) Caused by: java.lang.IllegalArgumentException: Translation > of IS NOT NULL($1) is not supported by MongoProject at > org.apache.drill.exec.store.mongo.plan.RexToMongoTranslator.visitCall(RexToMongoTranslator.java:183) > at > org.apache.drill.exec.store.mongo.plan.RexToMongoTranslator.visitCall(RexToMongoTranslator.java:49) > at org.apache.calcite.rex.RexCall.accept(RexCall.java:191) at > org.apache.drill.exec.store.mongo.plan.RexToMongoTranslator.lambda$visitCall$0(RexToMongoTranslator.java:136) > at .......(:0) at > org.apache.drill.exec.store.mongo.plan.RexToMongoTranslator.visitCall(RexToMongoTranslator.java:137) > at > org.apache.drill.exec.store.mongo.plan.RexToMongoTranslator.visitCall(RexToMongoTranslator.java:49) > at org.apache.calcite.rex.RexCall.accept(RexCall.java:191) at > org.apache.drill.exec.store.mongo.plan.MongoPluginImplementor.implement(MongoPluginImplementor.java:150) > at > org.apache.drill.exec.store.plan.rel.PluginProjectRel.implement(PluginProjectRel.java:59) > at > org.apache.drill.exec.store.plan.PluginImplementor.visitChild(PluginImplementor.java:84) > at > org.apache.drill.exec.store.mongo.plan.MongoPluginImplementor.implement(MongoPluginImplementor.java:93) > at > org.apache.drill.exec.store.plan.rel.PluginAggregateRel.implement(PluginAggregateRel.java:59) > at > org.apache.drill.exec.store.plan.PluginImplementor.visitChild(PluginImplementor.java:84) > at > org.apache.drill.exec.store.mongo.plan.MongoPluginImplementor.implement(MongoPluginImplementor.java:173) > at > org.apache.drill.exec.store.plan.rel.PluginSortRel.implement(PluginSortRel.java:57) > at > org.apache.drill.exec.store.plan.rel.PluginPrel.<init>(PluginPrel.java:52) > at > org.apache.drill.exec.store.plan.rel.PluginIntermediatePrel.finalizeRel(PluginIntermediatePrel.java:71) > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:322) > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272) > at > org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55) > at > org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69) > at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131) > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324) > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272) > at > org.apache.calcite.rel.RelShuttleImpl.visitChild(RelShuttleImpl.java:55) > at > org.apache.calcite.rel.RelShuttleImpl.visitChildren(RelShuttleImpl.java:69) > at org.apache.calcite.rel.RelShuttleImpl.visit(RelShuttleImpl.java:131) > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler$PrelFinalizer.visit(DefaultSqlHandler.java:324) > at > org.apache.calcite.rel.AbstractRelNode.accept(AbstractRelNode.java:272) > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToPrel(DefaultSqlHandler.java:437) > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174) > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283) > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163) > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:128) > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93) > at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:593) > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:274) ... 1 > common frames omitted{code} -- This message was sent by Atlassian Jira (v8.20.10#820010)