[DRILL-444] Using [NOT] LIKE, [NOT] SIMILAR in a query throws errors

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Venki Korukanti
• Reporter: Venki Korukanti
• Created: 25/Mar/14 00:14
• Updated: 31/Jul/14 06:31
• Resolved: 27/Mar/14 06:57

Description

select * from INFORMATION_SCHEMA.`TABLES` WHERE TABLE_NAME LIKE '%IE%';

throws exception:

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)

When converting RexCall to Logical plan (RexToDrill.visitCall()), Drill doesn't handle NOT, LIKE and SIMILAR function calls.