[DRILL-6145] Enable usage of Hive MapR-DB JSON handler

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.14.0
• Component/s: Storage - Hive, Storage - MapRDB
• Labels: doc-complete
• Assignee: Vitalii Diravka
• Reporter: Vitalii Diravka
• Reviewer: Vlad Rozov
• Created: 08/Feb/18 14:24
• Updated: 28/Jun/18 14:47
• Resolved: 12/Jun/18 22:11

Description

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:

1. Create a table MapR-DB JSON table:

   _> mapr dbshell_
   
   _maprdb root:> create /tmp/table/json_  (make sure /tmp/table exists)
   

   • insert data

     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"}'
     
     

      

2. Create a Hive external table:

   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");
   

    

3. Use hive schema to query this table via Drill:

   0: jdbc:drill:> select * from hive.mapr_db_json_hive_tbl;
   

Issue Links

• is related to: DRILL-6454 Native MapR DB plugin support for Hive MapR-DB json table
• is related to: DRILL-6196 Upgrade HiveTestDataGenerator to leverage "schematool"
• relates to: DRILL-6258 Jar files aren't downloaded if dependency is present only in profile section
• links to: GitHub Pull Request #1158