Hive HBase integeration use case

["G.S.Vijay raajaa" <gs...@gmail.com>]

Hi,

       I would like to have HBase as a data storage and use Hive for data
warehousing.

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

 and

*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:

customer_id,event_id,time,usage

This will enable me aggregate data by grouping the column ( time or
event_id)??

Any thoughts on the same??

If there isn't a direct handling by hive HBase integration, can you suggest
any other means??

Regards,
Vijay Raajaa G S

RE: Hive HBase integeration use case

[Vivek Mishra <vi...@impetus.co.in>]

You may want to try by creating UDF/UDTF hive function

-Vivek
________________________________
From: G.S.Vijay raajaa [gsvijayraajaa@gmail.com]
Sent: 01 February 2013 18:55
To: user@hive.apache.org
Subject: Hive HBase integeration use case

Hi,

       I would like to have HBase as a data storage and use Hive for data warehousing.

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

 and

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:

customer_id,event_id,time,usage

This will enable me aggregate data by grouping the column ( time or event_id)??

Any thoughts on the same??

If there isn't a direct handling by hive HBase integration, can you suggest any other means??

Regards,
Vijay Raajaa G S

________________________________






NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.