Re: Hive/Hbase Integration issue

2015-05-14 Thread Ibrar Ahmed
Now my hbase is working fine now, but i am still getting the same error [127.0.0.1:1] hive CREATE TABLE hbase_table_1(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase. HBaseStorageHandler' WITH SERDEPROPERTIES (hbase.columns.mapping

Hive/Hbase Integration issue

2015-05-13 Thread Ibrar Ahmed
Hi, I am creating a table using hive and getting this error. [127.0.0.1:1] hive CREATE TABLE hbase_table_1(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES (hbase.columns.mapping =

Re: Hive/Hbase Integration issue

2015-05-13 Thread Ibrar Ahmed
Seems you are right, Sometime I got this error while running hbase shell command. ibrar@ibrar-virtual-machine:/usr/local/hbase/bin$ ./hbase shell SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in

Re: Hive/Hbase Integration issue

2015-05-13 Thread kulkarni.swar...@gmail.com
Ibrar, This seems to be an issue with the cluster rather than the integration itself. Can you make sure that HBase is happy and healthy and all RS are up and running? On Wed, May 13, 2015 at 1:58 PM, Ibrar Ahmed ibrar.ah...@gmail.com wrote: Hi, I am creating a table using hive and getting

Re: Hive/Hbase Integration issue

2015-05-13 Thread Ibrar Ahmed
Here is my hbase-site.xml configuration property namehbase.rootdir/name valuefile:///usr/local/hbase/value /property property namehbase.zookeeper.property.dataDir/name value/usr/local/hbase/zookeeperdata/value /property /configuration And hive-site.xml configuration

RE: Hive/HBase integration issue.

2010-11-24 Thread Vivek Mishra
Added 1 post at: http://mevivs.wordpress.com/2010/11/24/hivehbase-integration/ Sharing it if is useful. Vivek -Original Message- From: Vivek Mishra Sent: Friday, November 19, 2010 10:36 AM To: user@hive.apache.org Subject: RE: Hive/HBase integration issue. Hi, Just found

Re: Hive/HBase integration issue.

2010-11-18 Thread afancy
Hi, Does the INSERT clause have to include the OVERWRITE, which means that the new data will overwrite the previous data? How to implement the indeed INSERT operation, instead of OVERWRITE? BTW: How to implement the DELETE operator? thanks afancy

Re: Hive/HBase integration issue.

2010-11-18 Thread John Sichi
As noted here, when writing to HBase, existing rows are overwritten, but old rows are not deleted. http://wiki.apache.org/hadoop/Hive/HBaseIntegration#Overwrite There is not yet any deletion support. JVS On Nov 18, 2010, at 1:00 AM, afancy wrote: Hi, Does the INSERT clause have to