[ https://issues.apache.org/jira/browse/DRILL-6145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16398709#comment-16398709 ]
ASF GitHub Bot commented on DRILL-6145: --------------------------------------- Github user vdiravka commented on a diff in the pull request: https://github.com/apache/drill/pull/1158#discussion_r174489502 --- Diff: distribution/pom.xml --- @@ -324,6 +324,14 @@ <groupId>org.apache.hbase</groupId> <artifactId>hbase-protocol</artifactId> </dependency> + <dependency> --- End diff -- I have tried maven 3.5.3 version (I used 3.5.0 by default for couple of month), but nothing is changed. I have also tried the newest `maven-assembly-plugin`, but no luck too. So I have added dependencies for `storage-hive/core` module for `mapr` profile without removing them from `distribution` module. I believe that it is better than adding a new module to storage-hive or adding extra assembly plugins. But to create a JIra to investigate it in future can be a good point here. > 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: 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)