[ https://issues.apache.org/jira/browse/DRILL-6145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pritesh Maker updated DRILL-6145: --------------------------------- Fix Version/s: (was: 1.13.0) 1.14.0 > Implement Hive MapR-DB JSON handler. > ------------------------------------- > > Key: DRILL-6145 > URL: https://issues.apache.org/jira/browse/DRILL-6145 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Hive, Storage - MapRDB > Affects Versions: 1.12.0 > Reporter: Vitalii Diravka > Assignee: Vitalii Diravka > Priority: Critical > 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} > 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: > {code} > select * from hive.mapr_db_json_hive_tbl; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)