hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anand Murali <anand_vi...@yahoo.com>
Subject Output of Hive
Date Sat, 16 May 2015 11:40:32 GMT
Dear All:
I am new to hive so pardon my ignorance. I have the following query but do not see any output.
I wondered it maybe in HDFS and checked there and do not find it there. Can somebody advise
hive> select year, MAX(Temperature) from records where temperature <> 9999 and (quality
= 0 or quality = 1 or quality = 4 or quality = 5 or quality = 9)
    > group by year
    > ;
Query ID = anand_vihar_20150516170505_9b23d8ba-19d7-4fa7-b972-4f199e3bf56a
Total 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 mapreduce.job.reduces=<number>
Job running in-process (local Hadoop)
2015-05-16 17:05:11,504 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_local927727978_0003
MapReduce Jobs Launched: 
Stage-Stage-1:  HDFS Read: 5329140 HDFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
Time taken: 1.258 seconds

Thanks
 Anand Murali  

Mime
View raw message