Apache Drill
  1. Apache Drill
  2. DRILL-444

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

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      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.

        Activity

          People

          • Assignee:
            Venki Korukanti
            Reporter:
            Venki Korukanti
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development