[ https://issues.apache.org/jira/browse/DRILL-4148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu resolved DRILL-4148. -------------------------------------- Resolution: Cannot Reproduce > NullPointerException in planning when running window function query > ------------------------------------------------------------------- > > Key: DRILL-4148 > URL: https://issues.apache.org/jira/browse/DRILL-4148 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 1.4.0 > Environment: 4 node cluster CentOS > Reporter: Khurram Faraaz > Assignee: Sean Hsuan-Yi Chu > > Failing test case : Functional/window_functions/lag_func/lag_Fn_4.q > Tests were run on JDK8 with assertions enabled. > {noformat} > [root@centos-01 lag_func]# java -version > openjdk version "1.8.0_65" > OpenJDK Runtime Environment (build 1.8.0_65-b17) > OpenJDK 64-Bit Server VM (build 25.65-b01, mixed mode) > [root@centos-01 lag_func]# uname -a > Linux centos-01 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 > x86_64 x86_64 x86_64 GNU/Linux > {noformat} > Stack trace from drillbit.log > {noformat} > 2015-12-01 03:31:50,133 [29a2eb59-d5a3-f0f2-d2df-9ad4e5d17109:foreman] ERROR > o.a.drill.exec.work.foreman.Foreman - SYSTEM ERROR: NullPointerException > [Error Id: ab046c45-4a2d-428d-8c72-592a02ea53e5 on centos-02.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > [Error Id: ab046c45-4a2d-428d-8c72-592a02ea53e5 on centos-02.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534) > ~[drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:742) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:841) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:786) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.common.EventProcessor.sendEvent(EventProcessor.java:73) > [drill-common-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.foreman.Foreman$StateSwitch.moveToState(Foreman.java:788) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:894) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:255) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected > exception during fragment initialization: null > ... 4 common frames omitted > Caused by: java.lang.NullPointerException: null > at > com.google.common.base.Preconditions.checkNotNull(Preconditions.java:191) > ~[guava-14.0.1.jar:na] > at > org.apache.calcite.rel.metadata.CachingRelMetadataProvider$CachingInvocationHandler.<init>(CachingRelMetadataProvider.java:104) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.CachingRelMetadataProvider$2.apply(CachingRelMetadataProvider.java:78) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.CachingRelMetadataProvider$2.apply(CachingRelMetadataProvider.java:75) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepRelMetadataProvider$1.apply(HepRelMetadataProvider.java:45) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepRelMetadataProvider$1.apply(HepRelMetadataProvider.java:34) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.CachingRelMetadataProvider$2.apply(CachingRelMetadataProvider.java:77) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.CachingRelMetadataProvider$2.apply(CachingRelMetadataProvider.java:75) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.MetadataFactoryImpl.query(MetadataFactoryImpl.java:69) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.AbstractRelNode.metadata(AbstractRelNode.java:271) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.RelMetadataQuery.collations(RelMetadataQuery.java:293) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.metadata.RelMdCollation.calc(RelMdCollation.java:180) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.logical.LogicalCalc$2.get(LogicalCalc.java:97) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.logical.LogicalCalc$2.get(LogicalCalc.java:95) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.RelTraitSet.replaceIfs(RelTraitSet.java:238) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.logical.LogicalCalc.create(LogicalCalc.java:92) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.rel.rules.ProjectToWindowRule$4.onMatch(ProjectToWindowRule.java:135) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:326) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:515) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:392) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepPlanner.executeInstruction(HepPlanner.java:277) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepInstruction$RuleClass.execute(HepInstruction.java:60) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:207) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.calcite.plan.hep.HepPlanner.findBestExp(HepPlanner.java:194) > ~[calcite-core-1.4.0-drill-r9.jar:1.4.0-drill-r9] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRel(DefaultSqlHandler.java:483) > ~[drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:201) > ~[drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:167) > ~[drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:197) > ~[drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:909) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:244) > [drill-java-exec-1.4.0-SNAPSHOT.jar:1.4.0-SNAPSHOT] > ... 3 common frames omitted > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)