RE: Error in inserting data into HBase table from Hive

[as...@wipro.com]

Please check into your conf folder of hive.
If you are working on cloudera vm(v-4), below things you have to add in hive-site.xml.

<name>hive.aux.jars.path</name>
<value>path/to/hive-hbase-handler-0.9.0-cdh4.jar,path/to/hive/lib/hbase-0.92.jar,payh/to/hive/lib/zookeeper-VERSION.jar</value>

Regards
Ashok S.
________________________________________
From: Ejaz Rasool [rasool_ejaz@hotmail.com]
Sent: Monday, September 17, 2012 3:43 AM
To: user@hive.apache.org
Cc: Ashok Kumar Samal (WT01 - CITI); Azaz Rasool (WT01 - Banking & Financial Services)
Subject: Error in inserting data into HBase table from Hive

Hi,

I am getting error while inserting data into HBase table from Hive (see Step#5 below)...any help is much appreciated.

I am following the HBase-Hive integration article : https://cwiki.apache.org/Hive/hbaseintegration.html

Step#1

hive> CREATE TABLE tblHbase(key int, a int, b int,c bigint)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,f:a,f:b,f:c")
TBLPROPERTIES("hbase.table.name"="tblHbase");



Step#2

hbase(main):001:0> describe "tblHbase"
DESCRIPTION                                        ENABLED
 {NAME => 'tblHbase', FAMILIES => [{NAME => 'f', B true
 LOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', V
 ERSIONS => '3', COMPRESSION => 'NONE', MIN_VERSIO
 NS => '0', TTL => '2147483647', BLOCKSIZE => '655
 36', IN_MEMORY => 'false', BLOCKCACHE => 'true'}]
 }



Step#3

hive> describe tblhive;


OK id int a int b int c bigint

Step#4

hive> select * from tblhive;


OK 1 101 102 103 2 201 202 203

Step#5 -- Error in inserting data into HBase table from Hive

hive> insert overwrite table tblHbase select id,a,b,c from tblhive;

Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks is set to 0
since there's no reduce operator Starting Job = job_1347311485447_0005,
Tracking URL = <url_deleted> Kill Command = /usr/lib/hadoop/bin/hadoop job  -Dmapred.job.tracker=0.0.0.0:8021
-kill job_1347311485447_0005 Hadoop job information for Stage-0:
number of mappers: 1;
number of reducers: 0
2012-09-10 18:19:35,844 Stage-0 map = 0%,  reduce = 0% Ended Job = job_1347311485447_0005 with errors Error during job, obtaining debugging information...
Examining task ID: task_1347311485447_0005_m_000000 (and more) from job job_1347311485447_0005

Task with the most failures(4):
----- Task ID:   task_1347311485447_0005_m_000000

URL:   http://x.x.x.x:50030/taskdetails.jsp?jobid=job_1347311485447_0005&tipid=task_1347311485447_0005_m_000000
-----

**FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask**
MapReduce Jobs Launched:  Job 0: Map: 1   HDFS Read: 0 HDFS Write: 0
FAIL Total MapReduce CPU Time Spent: 0 msec



Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 

www.wipro.com