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 <donta...@gmail.com>
To: user <user@hive.apache.org>
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
