You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Volodymyr Vysotskyi (JIRA)" <ji...@apache.org> on 2019/03/05 11:55:00 UTC

[jira] [Created] (DRILL-7076) NPE is logged when querying postgres tables

Volodymyr Vysotskyi created DRILL-7076:
------------------------------------------

             Summary: NPE is logged when querying postgres tables
                 Key: DRILL-7076
                 URL: https://issues.apache.org/jira/browse/DRILL-7076
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.15.0
            Reporter: Volodymyr Vysotskyi
            Assignee: Gautam Parai


NPE is seen in logs when querying PostgresĀ table:
{code:sql}
select 1 from postgres.public.tdt
{code}
Stack trace from {{sqlline.log}}:
{noformat}
2019-03-05 13:49:19,395 [23819dc0-abf8-24f3-ea81-6ced1b6e11af:foreman] WARN  o.a.d.e.p.common.DrillStatsTable - Failed to materialize the stats. Continuing without stats.
java.lang.NullPointerException: null
	at org.apache.drill.exec.planner.common.DrillStatsTable$StatsMaterializationVisitor.visit(DrillStatsTable.java:189) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.calcite.rel.SingleRel.childrenAccept(SingleRel.java:72) [calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
	at org.apache.calcite.rel.RelVisitor.visit(RelVisitor.java:44) [calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
	at org.apache.drill.exec.planner.common.DrillStatsTable$StatsMaterializationVisitor.visit(DrillStatsTable.java:202) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.calcite.rel.RelVisitor.go(RelVisitor.java:61) [calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
	at org.apache.drill.exec.planner.common.DrillStatsTable$StatsMaterializationVisitor.materialize(DrillStatsTable.java:177) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel(DefaultSqlHandler.java:235) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel(DefaultSqlHandler.java:331) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:178) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:204) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:114) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:80) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:584) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:272) [drill-java-exec-1.16.0-SNAPSHOT.jar:1.16.0-SNAPSHOT]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_191]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_191]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_191]
{noformat}
But query runs and returns the correct result.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)