Should I use PIG to load data into HBase from HIVE or is there a better way?

Question

I have to load data into HBase table from HIVE. I know that there are various ways to do this, for example:

• Generating CSV from HIVE and then converting it to HFile using bulk load to load the data
• Using MapReduce to generate HFile
• Using PIG script to generate and load HFile
• Or is there a direct converter available?

Can you please guide me by recommending the best approach to follow?

We are not using phoenix for this use case.

Answer 1

You can use HBASE integration:

CREATE TABLE hbase_table_1(key int, value string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
TBLPROPERTIES ("hbase.table.name" = "xyz");

then load your data into the Hive table, will also load HBase since is the same table.