Hi Keshav
Make your hive table EXTERNAL, it should get things rolling. If you are
mapping hive to a Hbase table, then as a mandatory requirement the hive table
has to be EXTERNAL.
Hope it helps.
Regards
Bejoy.K.S
________________________________
From: "Savant, Keshav" <keshav.c.sav...@fisglobal.com>
To: "user@hive.apache.org" <user@hive.apache.org>
Sent: Tuesday, February 28, 2012 5:58 PM
Subject: Hive | HBase Integration
Hi All,
We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1.
In our next step we are eyeing HBase integration with Hive. As far as we
understand from articles available on internet and apache site, we can use
HBase instead of derby as a metastore of Hive, this gives us more flexibility
while handling very large data.
We are using hbase-0.92.0 to integrate it with Hive, till now HBase has been
setup and we can create sample table on it and insert sample data in it, but we
are not able to integrate it with Hive, because when we issue the command to
create hive specific table on HBase (below in box) the command does not
executes completely and a new command line is shown with an asterisk (*), and
table does not gets created.
CREATE TABLE hive_hbasetable_k(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
TBLPROPERTIES ("hbase.table.name" = "hivehbasek");
Please provide us some pointers (steps to follow) for doing this integration or
what we are not doing correctly. Till now we got these below URLs to do this,
any help is appreciated
http://mevivs.wordpress.com/2010/11/24/hivehbase-integration/
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
Kind regards,
Keshav C Savant
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the intended recipient, please: (i) delete the message and all
copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii) notify the sender immediately. In addition, please be aware that any
message addressed to our domain is subject to archiving and review by persons
other than the intended recipient. Thank you.
