AnsweredAssumed Answered

NPE on Apache Drill (MapR 1.8) Querying MapR-DB Table

Question asked by mandoskippy on Apr 6, 2017
Latest reply on Apr 12, 2017 by mandoskippy

Hello all, I am using Drill 1.8 and MapR 5.2. I just finished a large load of data into a mapr table. I was able to confirm that the table returns data from the c api for hbase, so no issue there, however, when I select from the table in Drill, either from the table directly, or from a view I created, then I get the NPE as listed below. Any advice on how to troubleshoot further would be appreciated!


0: jdbc:drill:zk:zeta2.brewingintel.com:5181,> select * from maprpcaps limit 1;
Error: SYSTEM ERROR: NullPointerException


[Error Id: 6abaeadb-6e1b-4dce-9d1f-54b99a40becb on zeta4.brewingintel.com:20005]

(org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception during fragment initialization: null
org.apache.drill.exec.work.foreman.Foreman.run():281
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745
Caused By (java.lang.NullPointerException) null
org.apache.drill.exec.store.mapr.db.MapRDBGroupScan.applyAssignments():205
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitGroupScan():116
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitGroupScan():103
org.apache.drill.exec.physical.base.AbstractGroupScan.accept():63
org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitChildren():138
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitOp():134
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitOp():103
org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitLimit():92
org.apache.drill.exec.physical.config.Limit.accept():57
org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitChildren():138
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitOp():134
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitOp():103
org.apache.drill.exec.physical.config.SelectionVectorRemover.accept():42
org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitChildren():138
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitOp():134
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitExchange():108
org.apache.drill.exec.planner.fragment.Wrapper$AssignEndpointsToScanAndStore.visitExchange():103
org.apache.drill.exec.physical.base.AbstractExchange.accept():123
org.apache.drill.exec.planner.fragment.Wrapper.assignEndpoints():148
org.apache.drill.exec.planner.fragment.SoftAffinityFragmentParallelizer.parallelizeFragment():86
org.apache.drill.exec.planner.fragment.SimpleParallelizer.parallelizeFragment():251
org.apache.drill.exec.planner.fragment.SimpleParallelizer.parallelizeFragment():243
org.apache.drill.exec.planner.fragment.SimpleParallelizer.getFragmentsHelper():167
org.apache.drill.exec.planner.fragment.SimpleParallelizer.getFragments():126
org.apache.drill.exec.work.foreman.Foreman.getQueryWorkUnit():596
org.apache.drill.exec.work.foreman.Foreman.runPhysicalPlan():426
org.apache.drill.exec.work.foreman.Foreman.runSQL():1010
org.apache.drill.exec.work.foreman.Foreman.run():264
java.util.concurrent.ThreadPoolExecutor.runWorker():1142
java.util.concurrent.ThreadPoolExecutor$Worker.run():617
java.lang.Thread.run():745 (state=,code=0)

Outcomes