hadoop - For some of the hive queries I wasn't able to see the o/p? -
my query
select txnno, product txnrecsbycat tablesample(bucket 2 out of 10) order txnno;
i getting success unable view o/p o/p is:
total jobs = 1 launching job 1 out of 1 number of reduce tasks determined @ compile time: 1 in order change average load reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
in order limit maximum number of reducers:
set hive.exec.reducers.max=<number>
in order set constant number of reducers:
set mapreduce.job.reduces=<number> starting job = job_1500975292039_0005, tracking url = http://localhost:8088/proxy/application_1500975292039_0005/ kill command = /usr/lib/hadoop-2.2.0/bin/hadoop job -kill job_1500975292039_0005 hadoop job information stage-1: number of mappers: 1; number of reducers: 1 2017-07-25 20:26:48,640 stage-1 map = 0%, reduce = 0% 2017-07-25 20:27:05,179 stage-1 map = 100%, reduce = 0%, cumulative cpu 3.61 sec 2017-07-25 20:27:20,461 stage-1 map = 100%, reduce = 100%, cumulative cpu 5.47 sec mapreduce total cumulative cpu time: 5 seconds 470 msec ended job = job_1500975292039_0005 mapreduce jobs launched: job 0: map: 1 reduce: 1 cumulative cpu: 5.47 sec hdfs read: 2498 hdfs write: 0 success total mapreduce cpu time spent: 5 seconds 470 msec ok time taken: 51.819 seconds
as ok there in output ( comes before result), means nothing returned query. check bucket data.
Comments
Post a Comment