[
https://issues.apache.org/jira/browse/DRILL-6770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16641746#comment-16641746
]
ASF GitHub Bot commented on DRILL-6770:
---------------------------------------
vvysotskyi commented on issue #1489: DRILL-6770: JsonTableGroupScan should use
new MapRDB 6.1.0 APIs
URL: https://github.com/apache/drill/pull/1489#issuecomment-427811290
@gparai, this PR causes the next functional tests failures:
```
Execution Failures:
/root/drillAutomation/drill-test-framework/framework/resources/Functional/hive/hive_storage/hive_maprdb_json/less_than.sql.explain
Plan Verification Failures:
/root/drillAutomation/drill-test-framework/framework/resources/Functional/hive/hive_storage/hive_maprdb_json/between.sql.explain
Random Failures:
/root/drillAutomation/drill-test-framework/framework/resources/External/mapr-drill-tests/Testcases/maprdb/limit0/plan/pushdown_q20.q
/root/drillAutomation/drill-test-framework/framework/resources/External/mapr-drill-tests/Testcases/maprdb/pushdown/query/pushdown_q8.q
/root/drillAutomation/drill-test-framework/framework/resources/External/mapr-drill-tests/Testcases/maprdb/limit0/data/pushdown_q18.q
/root/drillAutomation/drill-test-framework/framework/resources/External/mapr-drill-tests/Testcases/maprdb/limit0/plan/rowkey-range.q
/root/drillAutomation/drill-test-framework/framework/resources/External/mapr-drill-tests/Testcases/maprdb/limit0/plan/avg.q
/root/drillAutomation/drill-test-framework/framework/resources/Functional/schema_change_empty_batch/maprdb/binary_maprdb/emptyMaprDBUnion.sql
/root/drillAutomation/drill-test-framework/framework/resources/External/mapr-drill-tests/Testcases/maprdb/sanity/date_add.q
/root/drillAutomation/drill-test-framework/framework/resources/Functional/schema_change_empty_batch/maprdb/json/emptyMaprDBJsonLeftJoin.sql
/root/drillAutomation/drill-test-framework/framework/resources/Functional/schema_change_empty_batch/maprdb/binary_hbase/emptyMaprDBScan1.sql
/root/drillAutomation/drill-test-framework/framework/resources/Functional/hive/hive_storage/hive_maprdb_json/project.sql
/root/drillAutomation/drill-test-framework/framework/resources/Functional/hive/hive_storage/hive_maprdb_json/like.sql.explain
/root/drillAutomation/drill-test-framework/framework/resources/Functional/hive/hive_storage/hive_maprdb_json/filter_id.sql.explain
/root/drillAutomation/drill-test-framework/framework/resources/Functional/hive/hive_storage/hive_maprdb_json/filter_id.sql
```
and advanced tests failures:
```
Execution Failures:
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/sanity/maprdb/json/query23_max.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/smoke/maprdb/json/join03-merge.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/smoke/maprdb/json/group-by01.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/smoke/maprdb/json/group-by02.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/smoke/maprdb/json/failed04.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query10.sql
Data Verification Failures:
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/sanity/maprdb/json/query30_distinct.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query13.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query18.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query4.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query8.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/smoke/maprdb/json/failed02.sql
Timeouts:
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/original/maprdb/json/query1.sql
/root/drillAutomation/drill-test-framework/framework/resources/Advanced/tpch/tpch_sf1/sql_functions/strings/maprdb/json/query10.sql
```
Could you please take a look?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> 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 Kumar 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)
