Description
I am getting an error with the below query:
Without metadata cache:
0: jdbc:drill:zk=local> select count(*) from orders where dir0 = 1995; +---------+ | EXPR$0 | +---------+ | 40 | +---------+ 1 row selected (0.205 seconds)
Create metadata cache and run query:
0: jdbc:drill:zk=local> refresh table metadata `orders`; +-------+--------------------------------------------------+ | ok | summary | +-------+--------------------------------------------------+ | true | Successfully updated metadata for table orders. | +-------+--------------------------------------------------+ 1 row selected (1.112 seconds) 0: jdbc:drill:zk=local> select count(*) from orders where dir0 = 1995; Error: SYSTEM ERROR: IllegalArgumentException: MinorFragmentId 0 has no read entries assigned [Error Id: c1cd004c-8850-47fb-8cd8-6da85dd4fc50 on 172.16.0.160:31010] (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception during fragment initialization: MinorFragmentId 0 has no read entries assigned org.apache.drill.exec.work.foreman.Foreman.run():255 java.util.concurrent.ThreadPoolExecutor.runWorker():1145 java.util.concurrent.ThreadPoolExecutor$Worker.run():615 java.lang.Thread.run():744 Caused By (java.lang.IllegalArgumentException) MinorFragmentId 0 has no read entries assigned com.google.common.base.Preconditions.checkArgument():92 org.apache.drill.exec.store.parquet.ParquetGroupScan.getSpecificScan():679 org.apache.drill.exec.store.parquet.ParquetGroupScan.getSpecificScan():103 org.apache.drill.exec.planner.fragment.Materializer.visitGroupScan():68 org.apache.drill.exec.planner.fragment.Materializer.visitGroupScan():35 org.apache.drill.exec.physical.base.AbstractGroupScan.accept():60 org.apache.drill.exec.planner.fragment.Materializer.visitOp():102 org.apache.drill.exec.planner.fragment.Materializer.visitOp():35 org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject():77 org.apache.drill.exec.physical.config.Project.accept():51 org.apache.drill.exec.planner.fragment.Materializer.visitOp():102 org.apache.drill.exec.planner.fragment.Materializer.visitOp():35 org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitStreamingAggregate():97 org.apache.drill.exec.physical.config.StreamingAggregate.accept():58 org.apache.drill.exec.planner.fragment.Materializer.visitOp():102 org.apache.drill.exec.planner.fragment.Materializer.visitOp():35 org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject():77 org.apache.drill.exec.physical.config.Project.accept():51 org.apache.drill.exec.planner.fragment.Materializer.visitStore():82 org.apache.drill.exec.planner.fragment.Materializer.visitStore():35 org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitScreen():195 org.apache.drill.exec.physical.config.Screen.accept():97 org.apache.drill.exec.planner.fragment.SimpleParallelizer.generateWorkUnit():355 org.apache.drill.exec.planner.fragment.SimpleParallelizer.getFragments():134