You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Vova Vysotskyi (Jira)" <ji...@apache.org> on 2020/03/17 19:34:00 UTC
[jira] [Commented] (DRILL-7645) Query on tables from postgres
INFORMATION_SCHEMA fails with NPE
[ https://issues.apache.org/jira/browse/DRILL-7645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17061143#comment-17061143 ]
Vova Vysotskyi commented on DRILL-7645:
---------------------------------------
This issue is reproduced with Postgres DB only. Column data types for all tables from INFORMATION_SCHEMA are `DISTINCT` (2001).
> Query on tables from postgres INFORMATION_SCHEMA fails with NPE
> ---------------------------------------------------------------
>
> Key: DRILL-7645
> URL: https://issues.apache.org/jira/browse/DRILL-7645
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.17.0
> Reporter: Vova Vysotskyi
> Priority: Major
> Fix For: Future
>
>
> Steps to reproduce:
> 1. Set up JDBC storage plugin to work with Postgres, as described here: https://drill.apache.org/docs/rdbms-storage-plugin/
> 2. Run the following query:
> {code:sql}
> SELECT * FROM postgres1.`INFORMATION_SCHEMA`.`tables`;
> {code}
> It fails with NPE:
> {noformat}
> Error: SYSTEM ERROR: NullPointerException
> Please, refer to logs for more information.
> [Error Id: 897978fa-fd7d-4337-8a33-b8c18501e9c7 on user515050-pc:31010] (state=,code=0)
> {noformat}
> Stack trace:
> {noformat}
> Caused by: java.lang.NullPointerException:
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.removeDistinct(RelStructuredTypeFlattener.java:858)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.visitInputRef(RelStructuredTypeFlattener.java:850)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRexShuttle.visitInputRef(RelStructuredTypeFlattener.java:829)
> at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:112)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.flattenProjection(RelStructuredTypeFlattener.java:685)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.flattenProjections(RelStructuredTypeFlattener.java:583)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewriteRel(RelStructuredTypeFlattener.java:504)
> at .......(:0)
> at org.apache.calcite.util.ReflectUtil.invokeVisitorInternal(ReflectUtil.java:257)
> at org.apache.calcite.util.ReflectUtil.invokeVisitor(ReflectUtil.java:214)
> at org.apache.calcite.util.ReflectUtil$1.invokeVisitor(ReflectUtil.java:464)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit(RelStructuredTypeFlattener.java:810)
> at org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewrite(RelStructuredTypeFlattener.java:197)
> at org.apache.calcite.sql2rel.SqlToRelConverter.flattenTypes(SqlToRelConverter.java:468)
> at org.apache.drill.exec.planner.sql.conversion.SqlConverter.toRel(SqlConverter.java:223)
> at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRel(DefaultSqlHandler.java:661)
> at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:198)
> at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:169)
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283)
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:128)
> at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93)
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:590)
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:275)
> ... 1 common frames omitted
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)