Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
1.15.0
-
MapR 6.1.0
Drill 1.15.0
Description
Create a simple MapR-DB JSON table
$ mapr dbshell MapR-DB Shell maprdb root:> create /tmp/t1 Table /tmp/t1 created. maprdb root:> insert /tmp/t1 --id '1' --v '{"a":1}' Document with id: "1" inserted. maprdb root:> find /tmp/t1 {"_id":"1","a":1} 1 document(s) found.
Querying this from Drill fails:
> select * from mfs.`/tmp/t1`;
Error: SYSTEM ERROR: UnsupportedOperationException: Getting number of rows for tablet not supported
Stack Trace:
(org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception during fragment initialization: Error while applying rule DrillTableRule, args [rel#1400499:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[mfs, /tmp/t1])] org.apache.drill.exec.work.foreman.Foreman.run():300 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 Caused By (java.lang.RuntimeException) Error while applying rule DrillTableRule, args [rel#1400499:EnumerableTableScan.ENUMERABLE.ANY([]).[](table=[mfs, /tmp/t1])] org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():236 org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():648 org.apache.calcite.tools.Programs$RuleSetProgram.run():339 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():425 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():365 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel():252 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():314 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():179 org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():145 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():83 org.apache.drill.exec.work.foreman.Foreman.runSQL():584 org.apache.drill.exec.work.foreman.Foreman.run():272 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 Caused By (org.apache.drill.common.exceptions.DrillRuntimeException) Error getting region info for table: maprfs:///tmp/t1 org.apache.drill.exec.store.mapr.db.json.JsonTableGroupScan.init():161 org.apache.drill.exec.store.mapr.db.json.JsonTableGroupScan.<init>():83 org.apache.drill.exec.store.mapr.db.MapRDBFormatPlugin.getGroupScan():81 org.apache.drill.exec.store.dfs.FileSystemPlugin.getPhysicalScan():170 org.apache.drill.exec.store.AbstractStoragePlugin.getPhysicalScan():117 org.apache.drill.exec.store.AbstractStoragePlugin.getPhysicalScan():112 org.apache.drill.exec.planner.logical.DrillTable.getGroupScan():99 org.apache.drill.exec.planner.logical.DrillScanRel.<init>():90 org.apache.drill.exec.planner.logical.DrillScanRel.<init>():70 org.apache.drill.exec.planner.logical.DrillScanRel.<init>():63 org.apache.drill.exec.planner.logical.DrillScanRule.onMatch():38 org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():212 org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():648 org.apache.calcite.tools.Programs$RuleSetProgram.run():339 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():425 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():365 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel():252 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():314 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():179 org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():145 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():83 org.apache.drill.exec.work.foreman.Foreman.runSQL():584 org.apache.drill.exec.work.foreman.Foreman.run():272 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 Caused By (java.lang.UnsupportedOperationException) Getting number of rows for tablet not supported com.mapr.db.impl.TabletInfoImpl.getEstimatedNumRows():71 org.apache.drill.exec.store.mapr.db.json.JsonTableGroupScan.init():155 org.apache.drill.exec.store.mapr.db.json.JsonTableGroupScan.<init>():83 org.apache.drill.exec.store.mapr.db.MapRDBFormatPlugin.getGroupScan():81 org.apache.drill.exec.store.dfs.FileSystemPlugin.getPhysicalScan():170 org.apache.drill.exec.store.AbstractStoragePlugin.getPhysicalScan():117 org.apache.drill.exec.store.AbstractStoragePlugin.getPhysicalScan():112 org.apache.drill.exec.planner.logical.DrillTable.getGroupScan():99 org.apache.drill.exec.planner.logical.DrillScanRel.<init>():90 org.apache.drill.exec.planner.logical.DrillScanRel.<init>():70 org.apache.drill.exec.planner.logical.DrillScanRel.<init>():63 org.apache.drill.exec.planner.logical.DrillScanRule.onMatch():38 org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch():212 org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp():648 org.apache.calcite.tools.Programs$RuleSetProgram.run():339 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():425 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.transform():365 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRawDrel():252 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToDrel():314 org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():179 org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():145 org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():83 org.apache.drill.exec.work.foreman.Foreman.runSQL():584 org.apache.drill.exec.work.foreman.Foreman.run():272 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 (state=,code=0)
Attachments
Issue Links
- is depended upon by
-
DRILL-6473 Update MapR Hive
- Resolved
- links to