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

["Vitalii Diravka (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-6658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vitalii Diravka updated DRILL-6658:
-----------------------------------
    Labels: newbie  (was: )

> 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
>            Priority: Major
>              Labels: newbie
>
> *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)