*Hi users,* ** * As im selecting the distinct column from the vender Hive table * ** *Im getting the below error plz help me in this* ** *hive> select distinct supplier from vender_sample;*
Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks not specified. Estimated from input data size: 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> Kill Command = /usr/local/hadoop/bin/../bin/hadoop job -Dmapred.job.tracker=md-trngpoc1:54311 -kill job_201207061535_0005 Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1 2012-07-06 17:03:13,978 Stage-1 map = 0%, reduce = 0% 2012-07-06 17:03:20,001 Stage-1 map = 100%, reduce = 0% 2012-07-06 17:04:20,248 Stage-1 map = 100%, reduce = 0% 2012-07-06 17:04:23,262 Stage-1 map = 100%, reduce = 100% Ended Job = job_201207061535_0005 with errors Error during job, obtaining debugging information... Examining task ID: task_201207061535_0005_m_000002 (and more) from job job_201207061535_0005 Task with the most failures(4): ----- Task ID: task_201207061535_0005_r_000000 FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask MapReduce Jobs Launched: Job 0: Map: 1 Reduce: 1 HDFS Read: 99143041 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec Regards shaik.