You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/06/30 22:18:04 UTC

[jira] [Commented] (DRILL-2708) "Query failed: AssertionError: VARCHAR"

    [ https://issues.apache.org/jira/browse/DRILL-2708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14608990#comment-14608990 ] 

Daniel Barclay (Drill) commented on DRILL-2708:
-----------------------------------------------

Here's the stack trace from the SQLLine log:

{noformat}
org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception during fragment initialization: VARCHAR
	at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:253) [drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_72]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_72]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_72]
Caused by: java.lang.AssertionError: VARCHAR
	at org.apache.calcite.sql.fun.SqlItemOperator.getChecker(SqlItemOperator.java:111) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.fun.SqlItemOperator.checkOperandTypes(SqlItemOperator.java:94) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.SqlOperator.validateOperands(SqlOperator.java:419) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.SqlOperator.deriveType(SqlOperator.java:486) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4086) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:4073) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:130) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1478) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1461) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:441) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3255) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2962) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:552) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:174) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:185) ~[calcite-core-1.1.0-drill-r9.jar:1.1.0-drill-r9]
	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:428) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:188) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.handlers.ExplainHandler.getPlan(ExplainHandler.java:56) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:178) ~[drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:903) [drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:242) [drill-java-exec-1.1.0-SNAPSHOT.jar:1.1.0-SNAPSHOT]
	... 3 common frames omitted
{noformat}


> "Query failed: AssertionError: VARCHAR"
> ---------------------------------------
>
>                 Key: DRILL-2708
>                 URL: https://issues.apache.org/jira/browse/DRILL-2708
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Daniel Barclay (Drill)
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.2.0
>
>
> Here's another case of assertion message that is bad (not quite saying what the problem is) and that shows up at the user interface (SQLLine):
> {noformat}
> 0: jdbc:drill:zk=local> EXPLAIN PLAN FOR  SELECT catalog_name['asd'] FROM INFORMATION_SCHEMA.CATALOGS;
> Query failed: AssertionError: VARCHAR
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> 0: jdbc:drill:zk=local> SELECT catalog_name['asd'] FROM INFORMATION_SCHEMA.CATALOGS;
> Query failed: AssertionError: VARCHAR
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)