Hive | HBase Integration

2012-02-28 Thread Savant, Keshav
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 flexibilit

Re: Hive | HBase Integration

2012-02-28 Thread Bejoy Ks
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" To: "user@hive

RE: Hive | HBase Integration

2012-02-28 Thread Garg, Rinku
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.hb

Re: Hive | HBase Integration

2012-02-28 Thread bejoy_ks
Hi Rinku Were you able to create a normal table within your hive without any issues? By Normal table I mean the one that has data dir in hdfs not in HBase. Regards Bejoy K S From handheld, Please excuse typos. -Original Message- From: "Garg, Rinku" Date: Wed, 29 Feb 2012 05:29:

RE: Hive | HBase Integration

2012-02-28 Thread Garg, Rinku
Hi Bejoy, Thanks for the quick reply. Yes, we can create normal table in Hive, but here we are trying to create table in hbase to integrate it with HIVE. Here is the scenario. We want to use hadoop's hdfs with hbase cluster. Earlier we have successful setup of hadoop-0.20.203.0 and hive-0.7.1