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