Hello,
I ran into an HBASE related problem and would appreciate any help on this.
We have a 10-node cluster, hive running on node10; and we recently installed
HBASE on 5 nodes from node6 to node10. Zookeeper is also running on the same
five nodes. I created a new hbase table, to be managed by hive.
hive> CREATE TABLE hbase_table_1(key int,value1 string,value2 int,value3 int)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,a:b,a:c,d:e");
We had a table eatwh2_lu_year hive that we want to extract in to this hbase
table.
Structure of this hive table:
hive> describe eatwh2_lu_year;
OK
year_id int
year_date string
year_duration int
prev_year_id int
Time taken: 0.124 seconds
Now, I am moving this table into HBASE:
hive> INSERT OVERWRITE TABLE hbase_table_1 SELECT * from eatwh2_lu_year;
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_201202131643_0892, Tracking URL =
http://hadoop001:50030/jobdetails.jsp?jobid=job_201202131643_0892
Kill Command = /usr/lib/hadoop/bin/hadoop job
-Dmapred.job.tracker=hadoop001:6932 -kill job_201202131643_0892
2012-03-23 16:15:25,349 Stage-0 map = 0%, reduce = 0%
2012-03-23 16:15:49,447 Stage-0 map = 100%, reduce = 100%
Ended Job = job_201202131643_0892 with errors
FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.MapRedTask
I don't really understand the error message: FAILED: Execution Error, return
code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
Any ideas?
Thanks.
Farah Omer
Senior DB Engineer, MicroStrategy, Inc.
T: 703 2702230
E: fo...@microstrategy.com<mailto:fo...@microstrategy.com>
http://www.microstrategy.com
