Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> HBASE-HIVE Question


Copy link to this message
-
Re: HBASE-HIVE Question
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:

>  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: *[EMAIL PROTECTED]* <[EMAIL PROTECTED]>
> *http://www.microstrategy.com* <http://www.microstrategy.com>
>
>
>
>

--
Nitin Pawar