Can you check whether the query has created the desired directory and the files underneath ?
On Wed, 4 Jul 2018 at 07:42, 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$ > > > > >
