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

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

javascript - Replicate keyboard event with html button -

javascript - Web audio api 5.1 surround example not working in firefox -