You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2014/04/21 20:51:21 UTC
[jira] [Commented] (DRILL-444) Using [NOT] LIKE, [NOT] SIMILAR in a
query throws errors
[ https://issues.apache.org/jira/browse/DRILL-444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13975891#comment-13975891 ]
ASF GitHub Bot commented on DRILL-444:
--------------------------------------
Github user vkorukanti commented on the pull request:
https://github.com/apache/incubator-drill/pull/34#issuecomment-40963795
merged as 7dc3f724000947abf0618c8e13e8903fef3ac967
> 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)