[
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)
