Hello all,

     Is there any way to fetch the data from a table which is already
present in Hbase using Hive directly??Or do I need to create the
corresponding table in the Hive first??

Regards,
    Mohammad Tariq

Hi Tariq
     You need to issue a ddl where you specify to hive how the row key and column families in hbase are mapped to various columns in hive. You don't need to do any data transfer from Hbase to hive that time. The DDL makes the hive table point to the corresponding hbase table and when you issue a hive query relative the hbase table, the actual hbase table location is scanned and the data is fetched.

A sample DDL is as follows
CREATE EXTERNAL TABLE hbase_table_2(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = "cf1:val")
TBLPROPERTIES("hbase.table.name" = "some_existing_table");

This url would be good reference for you.
https://cwiki.apache.org/Hive/hbaseintegration.html

Hope it helps!...

Regards
Bejoy.K.S

________________________________
 From: Mohammad Tariq <[EMAIL PROTECTED]>
To: user <[EMAIL PROTECTED]>
Sent: Friday, December 16, 2011 12:44 AM
Subject: Fetching Hbase data through Hive
 
Hello all,

     Is there any way to fetch the data from a table which is already
present in Hbase using Hive directly??Or do I need to create the
corresponding table in the Hive first??

Regards,
    Mohammad Tariq

Hi Bejoy,

   Thanks a lot for the valuable info and the link..I was just going
through the HbaseIntegration document..:)

Regards,
    Mohammad Tariq

On Fri, Dec 16, 2011 at 1:11 AM, Bejoy Ks <[EMAIL PROTECTED]> wrote:
> Hi Tariq
>      You need to issue a ddl where you specify to hive how the row key and
> column families in hbase are mapped to various columns in hive. You don't
> need to do any data transfer from Hbase to hive that time. The DDL makes the
> hive table point to the corresponding hbase table and when you issue a hive
> query relative the hbase table, the actual hbase table location is scanned
> and the data is fetched.
>
> A sample DDL is as follows
>
> CREATE EXTERNAL TABLE hbase_table_2(key int, value string)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" = "cf1:val")
> TBLPROPERTIES("hbase.table.name" = "some_existing_table");
>
> This url would be good reference for you.
> https://cwiki.apache.org/Hive/hbaseintegration.html
>
> Hope it helps!...
>
> Regards
> Bejoy.K.S
>
>
> ________________________________
> From: Mohammad Tariq <[EMAIL PROTECTED]>
> To: user <[EMAIL PROTECTED]>
> Sent: Friday, December 16, 2011 12:44 AM
> Subject: Fetching Hbase data through Hive
>
> Hello all,
>
>     Is there any way to fetch the data from a table which is already
> present in Hbase using Hive directly??Or do I need to create the
> corresponding table in the Hive first??
>
> Regards,
>     Mohammad Tariq
>
>

You need to create external table in Hive.(managed by Hbase)

Versions:
Hive: 0.7.x
Hbase: 0.90.4
Hadoop : 0.20.X

I tried to get this working on version/s > than above mentioned, but no luck.

you can refer blog

http://mevivs.wordpress.com/2010/11/24/hivehbase-integration/

for more in details.
________________________________________
From: Mohammad Tariq [[EMAIL PROTECTED]]
Sent: 16 December 2011 00:44
To: user
Subject: Fetching Hbase data through Hive

Hello all,

     Is there any way to fetch the data from a table which is already
present in Hbase using Hive directly??Or do I need to create the
corresponding table in the Hive first??

Regards,
    Mohammad Tariq

________________________________

New Impetus webcast on-demand ‘Big Data Technologies for Social Media Analytics’ available at http://bit.ly/nFdet0.

Visit http://www.impetus.com to know more. Follow us on www.twitter.com/impetuscalling
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.