[DRILL-7076] NPE is logged when querying postgres tables

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Assignee: Gautam Parai
• Reporter: Vova Vysotskyi
• Created: 05/Mar/19 11:54
• Updated: 02/Oct/19 18:38
• Resolved: 05/Apr/19 02:08

Description

NPE is seen in logs when querying Postgres table:

select 1 from postgres.public.tdt

Stack trace from sqlline.log:

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]

But query runs and returns the correct result.

Issue Links

• is caused by: DRILL-1328 Support table statistics
• links to: GitHub Pull Request #1722