You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/11/03 08:02:00 UTC
[jira] [Closed] (DRILL-8238) Translation of IS NOT NULL($1) is not supported by MongoProject
[ 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)