Jacques Nadeau created DRILL-440:
------------------------------------
Summary: Apparent Optiq error when trying to convert sqlnodes to
rel nodes as part of coorelated subquery
Key: DRILL-440
URL: https://issues.apache.org/jira/browse/DRILL-440
Project: Apache Drill
Issue Type: New Feature
Reporter: Jacques Nadeau
Example can be seen with TPCH 17:
Exception in thread "WorkManager-1" java.lang.AssertionError: Internal error:
while converting `l2`.`l_partkey` = `p`.`p_partkey`
at org.eigenbase.util.Util.newInternal(Util.java:768)
at
org.eigenbase.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:96)
at
org.eigenbase.sql2rel.SqlNodeToRexConverterImpl.convertCall(SqlNodeToRexConverterImpl.java:52)
at
org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4176)
at
org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:3574)
at org.eigenbase.sql.SqlCall.accept(SqlCall.java:166)
at
org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:4082)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertWhere(SqlToRelConverter.java:845)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:493)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:470)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2758)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertQueryOrInList(SqlToRelConverter.java:1278)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertExists(SqlToRelConverter.java:1251)
at
org.eigenbase.sql2rel.SqlToRelConverter.substituteSubquery(SqlToRelConverter.java:1017)
at
org.eigenbase.sql2rel.SqlToRelConverter.replaceSubqueries(SqlToRelConverter.java:873)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertWhere(SqlToRelConverter.java:844)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:493)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:470)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2758)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:428)
at
net.hydromatic.optiq.prepare.PlannerImpl.convert(PlannerImpl.java:169)
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:74)
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:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at
org.eigenbase.sql2rel.ReflectiveConvertletTable$1.convertCall(ReflectiveConvertletTable.java:87)
... 25 more
Caused by: java.lang.AssertionError
at org.eigenbase.rex.RexFieldAccess.<init>(RexFieldAccess.java:63)
at
org.eigenbase.rex.RexBuilder.makeFieldAccessInternal(RexBuilder.java:185)
at org.eigenbase.rex.RexBuilder.makeFieldAccess(RexBuilder.java:158)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertIdentifier(SqlToRelConverter.java:3157)
at
org.eigenbase.sql2rel.SqlToRelConverter.access$1400(SqlToRelConverter.java:59)
at
org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:4186)
at
org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.visit(SqlToRelConverter.java:3574)
at org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222)
at
org.eigenbase.sql2rel.SqlToRelConverter$Blackboard.convertExpression(SqlToRelConverter.java:4082)
at
org.eigenbase.sql2rel.StandardConvertletTable.convertExpressionList(StandardConvertletTable.java:689)
at
org.eigenbase.sql2rel.StandardConvertletTable.convertCall(StandardConvertletTable.java:642)
... 30 more
--
This message was sent by Atlassian JIRA
(v6.2#6252)
