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

2015-05-13 Thread Talat Uyarer
This issue similar some missing settings. What do you for your Hive Hbase integration ? Can you give some information about your cluster ? BTW In [1], someone had same issue. Maybe help you [1] http://mail-archives.apache.org/mod_mbox/hive-user/201307.mbox/%3cce01cda1.9221%25sanjay.subraman

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 Talat Uyarer
Your Zookeeper managed by Hbase. Could you check your hbase.zookeeper.quorum settings. It should be same with Hbase Zookeeper. Talat 2015-05-13 23:03 GMT+03:00 Ibrar Ahmed ibrar.ah...@gmail.com: Here is my hbase-site.xml configuration property namehbase.rootdir/name

hive hbase integration

2014-04-17 Thread Shushant Arora
Wanna know why hive hbase integration is required. Is it because hbase cannot provide all functionalities of sql like and if yes then why? What is storage handler and best practices for hive hbase integration?

Re: hive hbase integration

2014-04-17 Thread Ted Yu
Arora shushantaror...@gmail.comwrote: Wanna know why hive hbase integration is required. Is it because hbase cannot provide all functionalities of sql like and if yes then why? What is storage handler and best practices for hive hbase integration?

Re: Hbase connection closed when query multiple complicated hql with hive+hbase integration

2012-11-06 Thread Cheng Su
...@gmail.com wrote: Hi, all. I have a hive + hbase integration cluster. I met a performance issue. I executed some complicated hql, but only the first one is actually running. The rests are showed running on the job track web ui, but task attempt failed with exceptions below: java.io.IOException

Re: Performance: hive+hbase integration query against the row_key

2012-09-12 Thread Jean-Daniel Cryans
On Tue, Sep 11, 2012 at 6:56 AM, Shengjie Min shengjie@gmail.com wrote: 1. if you do a hive query against the row key like select * from hive_hbase_test where key='blabla', this would utilize the hbase row_key index which give you very quick nearly real-time response just like hbase does.

Performance: hive+hbase integration query against the row_key

2012-09-11 Thread Shengjie Min
Hi, I am trying to get hive working on top of my hbase table following the guide below: https://cwiki.apache.org/Hive/hbaseintegration.html CREATE EXTERNAL TABLE hive_hbase_test (key string, a string, b string, c string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH

RE: Hive HBase integration scan failing

2010-12-10 Thread Jonathan Gray
tasks you have per node. JG -Original Message- From: vlisovsky [mailto:vlisov...@gmail.com] Sent: Thursday, December 09, 2010 10:49 PM To: user@hbase.apache.org Subject: Hive HBase integration scan failing Hi Guys, Wonder if anybody could shed some light on how to reduce

Hive HBase integration scan failing

2010-12-09 Thread vlisovsky
Hi Guys, Wonder if anybody could shed some light on how to reduce the load on HBase cluster when running a full scan. The need is to dump everything I have in HBase and into a Hive table. The HBase data size is around 500g. The job creates 9000 mappers, after about 1000 maps things go south