Anton Gozhiy created DRILL-6658:
-----------------------------------
Summary: UnrecognizedPropertyException happens when submitting a
physical plan for a Mapr-DB table query
Key: DRILL-6658
URL: https://issues.apache.org/jira/browse/DRILL-6658
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.13.0, 1.14.0
Reporter: Anton Gozhiy
*Prerequisites:*
Create a MapR-DB table:
{noformat}
hadoop fs -mkdir /tmp/mdb_tabl
mapr dbshell
create /tmp/mdb_table/json
insert /tmp/mdb_table/json --value '{"_id":"movie0000002" , "title":"Developers
on the Edge", "studio":"Command Line Studios"}'
insert /tmp/mdb_table/json --id movie0000003 --value '{"title":"The Golden
Master", "studio":"All-Nighter"}'
{noformat}
*Steps:*
*1.* Execute the following query:
{code:sql}
explain plan for select * from dfs.tmp.`mdb_table`;
{code}
*2.* Copy the json plan from the response
*3.* In Drill Web UI, go to the Query
*4.* Set checkbox to PHYSICAL, then execute the plan you copied
*Expected result:*
Result should be the same as for the query:
{code:sql}
select * from dfs.tmp.`mdb_table`;
{code}
*Actual result:*
Exception happens:
{code}
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnrecognizedPropertyException: Unrecognized field "startRow" (class
org.apache.drill.exec.store.mapr.db.json.JsonScanSpec), not marked as ignorable
(2 known properties: "tableName", "condition"]) at [Source: (String)"{ "head" :
{ "version" : 1, "generator" : { "type" : "ExplainHandler", "info" : "" },
"type" : "APACHE_DRILL_PHYSICAL", "options" : [ ], "queue" : 0,
"hasResourcePlan" : false, "resultMode" : "EXEC" }, "graph" : [ { "pop" :
"maprdb-json-scan", "@id" : 2, "userName" : "mapr", "scanSpec" : { "tableName"
: "maprfs:///tmp/mdb_table/json", "startRow" : "", "stopRow" : "",
"serializedFilter" : null }, "storage" : { "type" : "file", "connection" :
"maprfs:///", "config" : null, "workspaces" : { "root" "[truncated 1652 chars];
line: 1, column: 398] (through reference chain:
org.apache.drill.exec.physical.PhysicalPlan["graph"]->java.util.ArrayList[0]->org.apache.drill.exec.store.mapr.db.json.JsonTableGroupScan["scanSpec"]->org.apache.drill.exec.store.mapr.db.json.JsonScanSpec["startRow"])
[Error Id: 2c0542ab-295a-4b14-abba-d9ee08a9129a on node1.cluster.com:31010]
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
