AnsweredAssumed Answered

Issue integrating hive-hbase when specifying the location for hive table

Question asked by saisha1992 on Mar 28, 2017
Latest reply on Mar 30, 2017 by maprcommunity

I am trying to integrate Hive and Hbase and followed the following documentaion Hive and HBase Integration - MapR 5.0 Documentation - doc.mapr.com .
By default, the tables are created in /user/hive/warehouse but in our cluster we have restricted the access for this folder, not all users can write to it. 
So i tried to create the hive-hbase table like this 

CREATE TABLE mapr_table_test(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") LOCATION '/user/<username>/table1' TBLPROPERTIES ("hbase.table.name" = "/user/<username>/hivemaprdbtable1");

But i ended up with an error saying 

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:LOCATION may not be specified for HBase.)

Is thereca way i can create a hive-hbase table and have the hive table in another directory where the user has the required permission?

 

Outcomes