hive problem

[柳国春 <lo...@163.com>]

dear，dev
   When I use hive to develop,I find exception ,I don't know how to solve ,please help me.
   1、I create a table user fallow script :
    CREATE TABLE testhivetable(key string,callnumber string,callednumber string,calltime string,time string)   
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'  
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,data:callnumber,data:callednumber,data:calltime,data:time")  
TBLPROPERTIES ("hbase.table.name" = "callList3"); 
  2、I start up hive with :
     ./hive --auxpath /root/opt/hadoop/hive/lib/hive-hbase-handler-0.7.1.jar,/root/opt/hadoop/hive/lib/hbase-0.90.4.jar,/root/opt/hadoop/hive/lib/zookeeper-3.3.1.jar  -hiveconf hbase.zookeeper.quorum=server18,server19 
The hive running well and I queryed with "select min(time) from testhivetable" runing well
  3、I start up hive with :
     nohup ./hive   --service hiveserver & 
     When I user jdbc connection queryed with "select min(time) from testhivetable" ,some exception find in client(eclipse) blow:
    
java.sql.SQLException: Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:192)
at test.Test2.main(Test2.java:39)
    And in nohup.out I find such exception:
    Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapred.reduce.tasks=<number>
Starting Job = job_201112080949_0018, Tracking URL = http://server18:50030/jobdetails.jsp?jobid=job_201112080949_0018
Kill Command = /root/opt/hadoop/bin/../bin/hadoop job  -Dmapred.job.tracker=172.31.21.18:9001 -kill job_201112080949_0018
2011-12-08 12:43:56,034 Stage-1 map = 0%,  reduce = 0%
2011-12-08 12:44:27,219 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201112080949_0018 with errors
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask

Please tell me how can I solve  this porblem
Thanks
2011-12-08 



柳国春
中国电信上海理想信息产业（集团）有限公司
  增值应用业务部
  Tel: （021) 20305588-3151
  FAX: （021）32095051
  Mob: 18917897176