Hello Ranjit, The query is missing, can you please share the query here ? Also what version of Drill are you on ?
Thanks, Khurram On Tue, Jul 3, 2018 at 4:42 PM, Ranjit Reddy <[email protected]> wrote: > > I have a query that we are using it to create a table. Select query runs > fine, when a table is created from the query, it is failing with NPE. > > I’ve included the query below, drill bit log and the exception thrown in > the web ui. > > Web UI error: > > Query Failed: An Error Occurred > > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > NullPointerException Fragment 1:9 [Error Id: > 5870f766-7e4a-44e3-9295-1162e5468db8 > on azure04.domain.com:31010] > > > > > > Drill bit log: > > > > Fragment 1:3 > > > > [Error Id: 831dd923-13c4-4b10-9333-f02a95d0a9b6 on azure05.domain.com] > > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > > > > Fragment 1:3 > > > > [Error Id: 831dd923-13c4-4b10-9333-f02a95d0a9b6 on > azure05.domain.com:31010] > > at org.apache.drill.common.exceptions.UserException$ > Builder.build(UserException.java:586) ~[drill-common-1.11.0-mapr. > jar:1.11.0-mapr] > > at org.apache.drill.exec.work.fragment.FragmentExecutor. > sendFinalState(FragmentExecutor.java:301) [drill-java-exec-1.11.0-mapr. > jar:1.11.0-mapr] > > at org.apache.drill.exec.work.fragment.FragmentExecutor. > cleanup(FragmentExecutor.java:160) [drill-java-exec-1.11.0-mapr. > jar:1.11.0-mapr] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:267) > [drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.11.0-mapr.jar:1.11.0-mapr] > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_131] > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_131] > > at java.lang.Thread.run(Thread.java:748) [na:1.8.0_131] > > Caused by: java.lang.NullPointerException: null > > at org.apache.drill.exec.physical.impl.WriterRecordBatch. > addOutputContainerData(WriterRecordBatch.java:136) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at org.apache.drill.exec.physical.impl. > WriterRecordBatch.innerNext(WriterRecordBatch.java:125) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:164) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:105) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at org.apache.drill.exec.physical.impl.SingleSenderCreator$ > SingleSenderRootExec.innerNext(SingleSenderCreator.java:92) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:95) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:234) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:227) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at java.security.AccessController.doPrivileged(Native Method) > ~[na:1.8.0_131] > > at javax.security.auth.Subject.doAs(Subject.java:422) > ~[na:1.8.0_131] > > at org.apache.hadoop.security.UserGroupInformation.doAs( > UserGroupInformation.java:1595) ~[hadoop-common-2.7.0-mapr-1607.jar:na] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:227) > [drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > ... 4 common frames omitted > > 2018-07-03 22:51:57,823 [24c401f2-c092-f031-7c86-c1514b25f4a3:frag:1:11] > INFO o.a.d.e.w.fragment.FragmentExecutor - > 24c401f2-c092-f031-7c86-c1514b25f4a3:1:11: > State change requested CANCELLATION_REQUESTED --> FAILED > > 2018-07-03 22:51:57,823 [24c401f2-c092-f031-7c86-c1514b25f4a3:frag:1:11] > INFO o.a.d.e.w.fragment.FragmentExecutor - > 24c401f2-c092-f031-7c86-c1514b25f4a3:1:11: > State change requested FAILED --> FINISHED > > 2018-07-03 22:51:57,824 [24c401f2-c092-f031-7c86-c1514b25f4a3:frag:1:11] > ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: > NullPointerException > > > > Fragment 1:11 > > > > [Error Id: 6332941b-84b7-425a-875e-b288070420b5 on > azure05.domain.com:31010] > > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > NullPointerException > > > > Fragment 1:11 > > > > [Error Id: 6332941b-84b7-425a-875e-b288070420b5 on > azure05.domain.com:31010] > > at org.apache.drill.common.exceptions.UserException$ > Builder.build(UserException.java:586) ~[drill-common-1.11.0-mapr. > jar:1.11.0-mapr] > > at org.apache.drill.exec.work.fragment.FragmentExecutor. > sendFinalState(FragmentExecutor.java:301) [drill-java-exec-1.11.0-mapr. > jar:1.11.0-mapr] > > at org.apache.drill.exec.work.fragment.FragmentExecutor. > cleanup(FragmentExecutor.java:160) [drill-java-exec-1.11.0-mapr. > jar:1.11.0-mapr] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:267) > [drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.11.0-mapr.jar:1.11.0-mapr] > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_131] > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_131] > > at java.lang.Thread.run(Thread.java:748) [na:1.8.0_131] > > Caused by: java.lang.NullPointerException: null > > at org.apache.drill.exec.physical.impl.WriterRecordBatch. > addOutputContainerData(WriterRecordBatch.java:136) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at org.apache.drill.exec.physical.impl. > WriterRecordBatch.innerNext(WriterRecordBatch.java:125) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:164) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:105) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at org.apache.drill.exec.physical.impl.SingleSenderCreator$ > SingleSenderRootExec.innerNext(SingleSenderCreator.java:92) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:95) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:234) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:227) > ~[drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > at java.security.AccessController.doPrivileged(Native Method) > ~[na:1.8.0_131] > > at javax.security.auth.Subject.doAs(Subject.java:422) > ~[na:1.8.0_131] > > at org.apache.hadoop.security.UserGroupInformation.doAs( > UserGroupInformation.java:1595) ~[hadoop-common-2.7.0-mapr-1607.jar:na] > > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:227) > [drill-java-exec-1.11.0-mapr.jar:1.11.0-mapr] > > ... 4 common frames omitted > > -bash-4.2$ > > > > >
