Vitalii Diravka created DRILL-6145: -------------------------------------- Summary: 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 Fix For: 1.13.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)