Apache Drill
  1. Apache Drill
  2. DRILL-441

Failure in SqlTypeTransforms when using ANY type in TPCH Query 22

    Details

      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)

        Activity

        Jacques Nadeau created issue -
        Jake Farrell made changes -
        Field Original Value New Value
        Workflow no-reopen-closed, patch-avail [ 12850344 ] no-reopen-closed, patch-avail, testing [ 12859944 ]
        Jacques Nadeau made changes -
        Assignee Jinfeng Ni [ jni ]
        Component/s Query Planning & Optimization [ 12322681 ]
        Jacques Nadeau made changes -
        Fix Version/s 1.0.0-BETA1 [ 12324963 ]
        Jacques Nadeau made changes -
        Fix Version/s Future [ 12326743 ]
        Fix Version/s 1.0.0-BETA1 [ 12324963 ]
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12859944 ] Drill workflow [ 12934196 ]

          People

          • Assignee:
            Jinfeng Ni
            Reporter:
            Jacques Nadeau
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development