[
https://issues.apache.org/jira/browse/DRILL-444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-444.
----------------------------------
Resolution: Fixed
Fixed in 7dc3f72
> 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)
