Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Hive HBase integeration use case

Copy link to this message
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