[jira] [Created] (DRILL-393) EXISTS and NOT EXISTS queries throw AssertionError: todo

[Aman Sinha (JIRA)]

Aman Sinha created DRILL-393:
--------------------------------

             Summary: EXISTS and NOT EXISTS queries throw AssertionError: todo
                 Key: DRILL-393
                 URL: https://issues.apache.org/jira/browse/DRILL-393
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Aman Sinha


select N_NATIONKEY from dfs.`/tmp/parquet/nation.parquet` where exists (select 
1 from dfs.`/tmp/parquet/region.parquet` where R_REGIONKEY = 3);
Exception in thread "WorkManager-1" java.lang.AssertionError: todo: implement 
syntax POSTFIX(IS TRUE($0))
        at 
org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:113)
        at 
org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:63)
        at org.eigenbase.rex.RexCall.accept(RexCall.java:106)
        at 
org.apache.drill.exec.planner.logical.DrillOptiq.toDrill(DrillOptiq.java:60)
        at 
org.apache.drill.exec.planner.logical.DrillFilterRel.implement(DrillFilterRel.java:56)


select N_NATIONKEY from dfs.`/tmp/parquet/nation.parquet` where not exists 
(select 1 from dfs.`/tmp/parquet/region.parquet` where R_REGIONKEY = 3);
Exception in thread "WorkManager-1" java.lang.AssertionError: todo: implement 
syntax PREFIX(NOT(IS TRUE($0)))
        at 
org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:113)



--
This message was sent by Atlassian JIRA
(v6.2#6252)