hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Garg, Rinku" <Rinku.G...@fisglobal.com>
Subject RE: Hive | HBase Integration
Date Wed, 29 Feb 2012 05:29:12 GMT
Hi ,

We tried the same also by issuing the below mentioned command but command does not executes
completely and a new command line is shown with an asterisk (*), and table does not gets created.

CREATE EXTERNAL 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 suggest.

Thanks
Rinku Garg

From: Bejoy Ks [mailto:bejoy_ks@yahoo.com]
Sent: 29 February 2012 10:33
To: user@hive.apache.org
Subject: Re: Hive | HBase Integration

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.Savant@fisglobal.com<mailto:Keshav.C.Savant@fisglobal.com>>
To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto: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.

_____________
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.

Mime
View raw message