-Hive HBase integeration use case
G.S.Vijay raajaa 2013-02-01, 13:25
I would like to have HBase as a data storage and use Hive for data
The issue with the integration is,
The HBase table is composed of composite keys following the below structure:
*HBase ROWKEY:* Hash(customer_id)+customer_id+time+event_id
*column:* usage : value
The structure of Hbase rowkey makes every entry a distinct one.
Is it possible to split the rowkey and map them as columns of the hive
table as explained below:
I am trying to create a hive table with the following column structure:
This will enable me aggregate data by grouping the column ( time or
Any thoughts on the same??
If there isn't a direct handling by hive HBase integration, can you suggest
any other means??
Vijay Raajaa G S
Vivek Mishra 2013-02-01, 16:33