[ https://issues.apache.org/jira/browse/DRILL-6770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gautam Parai updated DRILL-6770: -------------------------------- Labels: ready-to-commit (was: ) > Queries on MapR-DB JSON tables fail with UnsupportedOperationException: > Getting number of rows for tablet not supported > ----------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-6770 > URL: https://issues.apache.org/jira/browse/DRILL-6770 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization, Storage - MapRDB > Affects Versions: 1.15.0 > Environment: MapR 6.1.0 > Drill 1.15.0 > Reporter: Abhishek Girish > Assignee: Gautam Parai > Priority: Critical > Labels: ready-to-commit > Fix For: 1.15.0 > > > Create a simple MapR-DB JSON table > {code} > $ 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. > {code} > Querying this from Drill fails: > {code} > > select * from mfs.`/tmp/t1`; > Error: SYSTEM ERROR: UnsupportedOperationException: Getting number of rows > for tablet not supported > {code} > Stack Trace: > {code} > (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) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)