java.lang.AssertionError: typeName.allowsPrecScale(true, false)

drill-dev | Jacques Nadeau (JIRA) | 2 years ago
  1. 0

    [jira] [Resolved] (DRILL-518) AssertionError in Optiq in allowPrecScale with ANY type

    drill-dev | 2 years ago | Jacques Nadeau (JIRA)
    java.lang.AssertionError: typeName.allowsPrecScale(true, false)
  2. 0

    The below SQL reported an assertion error on an earlier source level, however now it is not reported as an AssertionError on the sqlline prompt. {code} this is the output from an earlier level 0: jdbc:drill:> select max(columns[0]) from (select * from `countries.csv` offset 1) tmp order by tmp.columns[1]; Query failed: AssertionError: star should have been expanded Error: exception while executing query: Failure while executing query. (state=,code=0) here is the output from current level, as mention in the Environment field of this JIRI 0: jdbc:drill:> select max(tmp.columns[0]) from (select * from `countries.csv` offset 1) tmp order by tmp.columns[1]; Query failed: SYSTEM ERROR: Unexpected exception during fragment initialization: star should have been expanded [3bfba8e5-5449-4d15-a663-0677e9ae65da on centos-04.qa.lab:31010] Error: exception while executing query: Failure while executing query. (state=,code=0) 2015-04-17 23:24:56,720 [2ace69b7-760a-4977-6eb9-1a39e4c1bb07:foreman] INFO o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING --> FAILED org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception during fragment initialization: star should have been expanded at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:211) [drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_75] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_75] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75] Caused by: java.lang.AssertionError: star should have been expanded at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:81) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:31) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.util.SqlBasicVisitor$ArgHandlerImpl.visitChild(SqlBasicVisitor.java:107) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.SqlOperator.acceptCall(SqlOperator.java:688) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:139) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:31) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.SqlCall.accept(SqlCall.java:125) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.util.SqlBasicVisitor$ArgHandlerImpl.visitChild(SqlBasicVisitor.java:107) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.SqlOperator.acceptCall(SqlOperator.java:688) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:139) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:31) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.SqlCall.accept(SqlCall.java:125) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggregatingSelectScope.checkAggregateExpr(AggregatingSelectScope.java:155) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AggregatingSelectScope.validateExpr(AggregatingSelectScope.java:164) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.OrderByScope.validateExpr(OrderByScope.java:100) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateExpr(SqlValidatorImpl.java:3150) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateOrderItem(SqlValidatorImpl.java:2965) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateOrderList(SqlValidatorImpl.java:2949) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2829) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:785) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:774) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:211) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:748) ~[optiq-core-0.9-drill-r21.jar:na] at org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:464) ~[optiq-core-0.9-drill-r21.jar:na] at net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:177) ~[optiq-core-0.9-drill-r21.jar:na] at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:148) ~[drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT] at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:132) ~[drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT] at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:155) ~[drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT] at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:770) [drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT] at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:202) [drill-java-exec-0.9.0-SNAPSHOT-rebuffed.jar:0.9.0-SNAPSHOT] ... 3 common frames omitted {code}

    Apache's JIRA Issue Tracker | 2 years ago | Khurram Faraaz
    org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception during fragment initialization: star should have been expanded
  3. 0

    TestNG - Exception only when 6 or more tests are defined

    Stack Overflow | 5 years ago | Soroush Hakami
    java.lang.AssertionError: Expected :true Actual :false
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    AutoItX functions not working properly with Selenium WebDriver in java in eclipse

    Stack Overflow | 2 years ago | Deepak Dave
    java.lang.AssertionError: expected [true] but found [false]
  6. 0

    Build fails under Windows

    GitHub | 2 years ago | gary-rowe
    java.lang.AssertionError: expected:<true> but was:<false>

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.AssertionError

      typeName.allowsPrecScale(true, false)

      at org.eigenbase.sql.type.BasicSqlType.<init>()
    2. Calcite Core
      PlannerImpl.validate
      1. org.eigenbase.sql.type.BasicSqlType.<init>(BasicSqlType.java:66)
      2. org.eigenbase.sql.type.SqlTypeFactoryImpl.createSqlType(SqlTypeFactoryImpl.java:59)
      3. org.eigenbase.sql.type.SqlTypeTransforms$4.transformType(SqlTypeTransforms.java:106)
      4. org.eigenbase.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:62)
      5. org.eigenbase.sql.SqlOperator.inferReturnType(SqlOperator.java:451)
      6. org.eigenbase.sql.SqlOperator.validateOperands(SqlOperator.java:418)
      7. org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:290)
      8. org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:206)
      9. org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3870)
      10. org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3857)
      11. org.eigenbase.sql.SqlCall.accept(SqlCall.java:133)
      12. org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1322)
      13. org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1305)
      14. org.eigenbase.sql.type.InferTypes$1.inferOperandTypes(InferTypes.java:52)
      15. org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1497)
      16. org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1503)
      17. org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1503)
      18. org.eigenbase.sql.validate.SqlValidatorImpl.validateWhereOrOn(SqlValidatorImpl.java:2961)
      19. org.eigenbase.sql.validate.SqlValidatorImpl.validateWhereClause(SqlValidatorImpl.java:2953)
      20. org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2764)
      21. org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
      22. org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
      23. org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747)
      24. org.eigenbase.sql.validate.AbstractNamespace.getRowType(AbstractNamespace.java:117)
      25. org.eigenbase.sql.validate.SelectNamespace.getRowType(SelectNamespace.java:30)
      26. org.eigenbase.sql.validate.ListScope.findQualifyingTableName(ListScope.java:99)
      27. org.eigenbase.sql.validate.DelegatingScope.fullyQualify(DelegatingScope.java:144)
      28. org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:367)
      29. org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:340)
      30. org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222)
      31. org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:348)
      32. org.eigenbase.sql.validate.SqlValidatorUtil$DeepCopier.visit(SqlValidatorUtil.java:340)
      33. org.eigenbase.sql.SqlNodeList.accept(SqlNodeList.java:149)
      34. org.eigenbase.sql.validate.AggregatingSelectScope.<init>(AggregatingSelectScope.java:65)
      35. org.eigenbase.sql.validate.SqlValidatorImpl.registerQuery(SqlValidatorImpl.java:1998)
      36. org.eigenbase.sql.validate.SqlValidatorImpl.registerQuery(SqlValidatorImpl.java:1921)
      37. org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:708)
      38. org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:426)
      39. net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:170)
      39 frames
    3. org.apache.drill
      TestTpchPlanning.tpch22
      1. org.apache.drill.exec.planner.sql.DrillSqlWorker.getLogicalRel(DrillSqlWorker.java:126)
      2. org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:216)
      3. org.apache.drill.BaseTestQuery.testSqlPlan(BaseTestQuery.java:148)
      4. org.apache.drill.BaseTestQuery.testSqlPlanFromFile(BaseTestQuery.java:107)
      5. org.apache.drill.TestTpchPlanning.tpch22(TestTpchPlanning.java:138)
      5 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. java.lang.reflect.Method.invoke(Method.java:606)
      3. java.lang.reflect.Method.invoke(Method.java:606)
      3 frames