[
https://issues.apache.org/jira/browse/DRILL-6145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16511570#comment-16511570
]
Bridget Bevens commented on DRILL-6145:
---------------------------------------
Hi [~vitalii],
Looking at this JIRA and trying to figure out the doc requirement. Looks like I
need to add a note in both the Apache Drill and MapR Drill release notes. Also,
thinking there is some configuration required that the user must complete.
*Release note summary:*
(DRILL-6145) The hive-maprdb-json-handler enables you to create a Hive external
table from a MapR-DB JSON table and then query the table from the Hive schema.
*Configuration?*
On this page:
https://drill.apache.org/docs/hive-storage-plugin/#hive-remote-metastore-configuration
There is information for configuring the hive storage plugin when using the
HBaseStorageHandler.
Does the user also have to perform the sames steps to configure Drill to use
the hive-maprdb-json-handler?
For example:
"maprdb.zookeeper.quorum": "zkhost1,zkhost2,zkhost3",
"maprdb.zookeeper.property.clientPort:" "5181"
Thanks,
Bridget
> Enable usage of Hive MapR-DB JSON handler
> -----------------------------------------
>
> Key: DRILL-6145
> URL: https://issues.apache.org/jira/browse/DRILL-6145
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Hive, Storage - MapRDB
> Affects Versions: 1.12.0
> Reporter: Vitalii Diravka
> Assignee: Vitalii Diravka
> Priority: Major
> Labels: doc-impacting
> Fix For: 1.14.0
>
>
> Similar to "hive-hbase-storage-handler" to support querying MapR-DB Hive's
> external tables it is necessary to add "hive-maprdb-json-handler".
> Use case:
> # Create a table MapR-DB JSON table:
> {code}
> _> mapr dbshell_
> _maprdb root:> create /tmp/table/json_ (make sure /tmp/table exists)
> {code}
> -- insert data
> {code}
> insert /tmp/table/json --value '\{"_id":"movie0000002" , "title":"Developers
> on the Edge", "studio":"Command Line Studios"}'
> insert /tmp/table/json --id movie0000003 --value '\{"title":"The Golden
> Master", "studio":"All-Nighter"}'
> {code}
> # Create a Hive external table:
> {code}
> hive> CREATE EXTERNAL TABLE mapr_db_json_hive_tbl (
> > movie_id string, title string, studio string)
> > STORED BY 'org.apache.hadoop.hive.maprdb.json.MapRDBJsonStorageHandler'
> > TBLPROPERTIES("maprdb.table.name" =
> "/tmp/table/json","maprdb.column.id" = "movie_id");
> {code}
>
> # Use hive schema to query this table via Drill:
> {code}
> 0: jdbc:drill:> select * from hive.mapr_db_json_hive_tbl;
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
