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$