There are two places you should check for the error logs
1) your hivelogs directory
2) the hadoop job logs will exactly tell you what went wrong
On Sat, Mar 24, 2012 at 2:02 AM, Omer, Farah <[EMAIL PROTECTED]>wrote:
> 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
> 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;
> 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
> I don’t really understand the error message: FAILED: Execution Error,
> return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
> Any ideas?
> *Farah Omer*
> *Senior DB Engineer, MicroStrategy, Inc.*
> T: 703 2702230
> E: *[EMAIL PROTECTED]* <[EMAIL PROTECTED]>
> *http://www.microstrategy.com* <http://www.microstrategy.com>