[jira] [Created] (DRILL-6658) UnrecognizedPropertyException happens when submitting a physical plan for a Mapr-DB table query

["Anton Gozhiy (JIRA)" <ji...@apache.org>]

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)