[DRILL-441] Failure in SqlTypeTransforms when using ANY type in TPCH Query 22

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Jacques Nadeau
• Created: 24/Mar/14 15:57
• Updated: 01/Oct/15 16:37

Description

java.lang.AssertionError: Was not expecting value 'ANY' for enumeration 'org.eigenbase.sql.type.SqlTypeName' in this context
at org.eigenbase.util.Util.unexpected(Util.java:1837)
at org.eigenbase.sql.type.SqlTypeTransforms$4.toVar(SqlTypeTransforms.java:131)
at org.eigenbase.sql.type.SqlTypeTransforms$4.transformType(SqlTypeTransforms.java:104)
at org.eigenbase.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:62)
at org.eigenbase.sql.SqlOperator.inferReturnType(SqlOperator.java:453)
at org.eigenbase.sql.SqlOperator.validateOperands(SqlOperator.java:420)
at org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:291)
at org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:207)
at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4033)
at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4020)
at org.eigenbase.sql.SqlCall.accept(SqlCall.java:166)
at org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1441)
at org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1424)
at org.eigenbase.sql.type.InferTypes$1.inferOperandTypes(InferTypes.java:49)
at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1627)
at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1633)
at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1633)
at org.eigenbase.sql.validate.SqlValidatorImpl.validateWhereOrOn(SqlValidatorImpl.java:3068)
at org.eigenbase.sql.validate.SqlValidatorImpl.validateWhereClause(SqlValidatorImpl.java:3060)
at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2900)
at org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:753)
at org.eigenbase.sql.validate.AbstractNamespace.getRowType(AbstractNamespace.java:118)
at org.eigenbase.sql.validate.SelectNamespace.getRowType(SelectNamespace.java:30)
at org.eigenbase.sql.validate.ListScope.findQualifyingTableName(ListScope.java:99)
at org.eigenbase.sql.validate.DelegatingScope.fullyQualify(DelegatingScope.java:139)
at org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:370)
at org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:343)
at org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222)
at org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:351)
at org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:343)
at org.eigenbase.sql.SqlNodeList.accept(SqlNodeList.java:151)
at org.eigenbase.sql.validate.AggregatingSelectScope.<init>(AggregatingSelectScope.java:65)
at org.eigenbase.sql.validate.SqlValidatorImpl.registerQuery(SqlValidatorImpl.java:2128)
at org.eigenbase.sql.validate.SqlValidatorImpl.registerQuery(SqlValidatorImpl.java:2048)
at org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:705)
at org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:423)
at net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:153)
at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:73)
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)