Venki Korukanti created DRILL-444:
-------------------------------------
Summary: Using [NOT] LIKE, [NOT] SIMILAR in a query throws errors
Key: DRILL-444
URL: https://issues.apache.org/jira/browse/DRILL-444
Project: Apache Drill
Issue Type: Bug
Reporter: Venki Korukanti
Assignee: Venki Korukanti
{code}
select * from INFORMATION_SCHEMA.`TABLES` WHERE TABLE_NAME LIKE '%IE%';
{code}
throws exception:
{code}
Exception in thread "WorkManager-4" java.lang.AssertionError: todo: implement
syntax SPECIAL(LIKE($2, '%IE%'))
at
org.apache.drill.exec.planner.logialc.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:126)
at
org.apache.drill.exec.planner.logical.DrillOptiq$RexToDrill.visitCall(DrillOptiq.java:67)
at org.eigenbase.rex.RexCall.accept(RexCall.java:106)
at
org.apache.drill.exec.planner.logical.DrillOptiq.toDrill(DrillOptiq.java:64)
at
org.apache.drill.exec.planner.logical.DrillFilterRel.implement(DrillFilterRel.java:56)
at
org.apache.drill.exec.planner.logical.DrillImplementor.visitChild(DrillImplementor.java:75)
at
org.apache.drill.exec.planner.logical.DrillProjectRel.implement(DrillProjectRel.java:77)
at
org.apache.drill.exec.planner.logical.DrillImplementor.visitChild(DrillImplementor.java:75)
at
org.apache.drill.exec.planner.logical.DrillScreenRel.implement(DrillScreenRel.java:72)
at
org.apache.drill.exec.planner.logical.DrillImplementor.go(DrillImplementor.java:62)
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:81)
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:350)
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:175)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
{code}
When converting RexCall to Logical plan (RexToDrill.visitCall()), Drill doesn't
handle NOT, LIKE and SIMILAR function calls.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
