You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Andrew (JIRA)" <ji...@apache.org> on 2015/10/20 05:11:27 UTC
[jira] [Commented] (DRILL-3956) TEXT MySQL type unsupported
[ https://issues.apache.org/jira/browse/DRILL-3956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14964434#comment-14964434 ]
Andrew commented on DRILL-3956:
-------------------------------
An example stack trace:
2015-10-19 20:09:25,383 [29da4f9a-dbbd-4bf4-1a7e-3f568e8da173:foreman] INFO o.a.d.e.planner.sql.DrillSqlWorker - User Error Occurred
org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: java.lang.NullPointerException
[Error Id: 4acee112-093b-41d3-9af1-57769f8c09ad ]
at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) ~[drill-common-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:181) [drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:905) [drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:244) [drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
Caused by: org.apache.calcite.tools.ValidationException: java.lang.NullPointerException
at org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:179) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:188) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:447) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:190) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:159) ~[drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:178) [drill-java-exec-1.2.0-SNAPSHOT.jar:1.2.0-SNAPSHOT]
... 5 common frames omitted
Caused by: java.lang.NullPointerException: null
at org.apache.calcite.adapter.jdbc.JdbcSchema.sqlType(JdbcSchema.java:291) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema.java:279) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema.java:245) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.adapter.jdbc.JdbcTable.getRowType(JdbcTable.java:97) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.prepare.CalciteCatalogReader.getTableFrom(CalciteCatalogReader.java:123) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:99) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:70) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.EmptyScope.getTableNamespace(EmptyScope.java:75) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.DelegatingScope.getTableNamespace(DelegatingScope.java:124) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:104) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:877) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2777) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2762) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2985) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:877) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:551) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
at org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:177) ~[calcite-core-1.4.0-drill-r6.jar:1.4.0-drill-r6]
... 10 common frames omitted
2015-10-19 20:09:25,385 [29da4f9a-dbbd-4bf4-1a7e-3f568e8da173:foreman] DEBUG o.a.drill.exec.work.foreman.Foreman - 29da4f9a-dbbd-4bf4-1a7e-3f
> TEXT MySQL type unsupported
> ---------------------------
>
> Key: DRILL-3956
> URL: https://issues.apache.org/jira/browse/DRILL-3956
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Other
> Affects Versions: 1.2.0
> Reporter: Andrew
> Assignee: Andrew
>
> The JDBC storage plugin will fail with an NPE when querying a MySQL table that has a 'TEXT' column. The underlying problem appears to be that Calcite has no notion of this type.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)