hive> select * from user_config;
OK
100636  Divid
100011  tom
111000  Lily
Time taken: 0.951 seconds, Fetched: 3 row(s)
hive> select * from user_config order by uid,uname limit 2;
Total 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=
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=
In order to set a constant number of reducers:
  set mapreduce.job.reduces=
15/08/11 20:01:24 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
15/08/11 20:01:25 WARN conf.Configuration: file:/tmp/hive-local-hadoop/hive_2015-08-11_20-01-13_743_5955681711277079721-1/-local-10003/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval;  Ignoring.
15/08/11 20:01:25 WARN conf.Configuration: file:/tmp/hive-local-hadoop/hive_2015-08-11_20-01-13_743_5955681711277079721-1/-local-10003/jobconf.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts;  Ignoring.
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.reduce.tasks is deprecated. Instead, use mapreduce.job.reduces
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.min.split.size is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.reduce.tasks.speculative.execution is deprecated. Instead, use mapreduce.reduce.speculative
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.min.split.size.per.node is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize.per.node
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.input.dir.recursive is deprecated. Instead, use mapreduce.input.fileinputformat.input.dir.recursive
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.min.split.size.per.rack is deprecated. Instead, use mapreduce.input.fileinputformat.split.minsize.per.rack
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.max.split.size is deprecated. Instead, use mapreduce.input.fileinputformat.split.maxsize
15/08/11 20:01:26 INFO Configuration.deprecation: mapred.committer.job.setup.cleanup.needed is deprecated. Instead, use mapreduce.job.committer.setup.cleanup.needed
15/08/11 20:01:26 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect.  Use hive.hmshandler.retry.* instead
Execution log at: /tmp/hadoop/hadoop_20150811200101_d09e2e8b-cd45-4bbb-8d92-c7becb887b67.log
Job running in-process (local Hadoop)
Hadoop job information for null: number of mappers: 0; number of reducers: 0
2015-08-11 20:01:48,821 null map = 0%,  reduce = 0%
2015-08-11 20:01:51,354 null map = 100%,  reduce = 0%
2015-08-11 20:01:52,409 null map = 100%,  reduce = 100%
Ended Job = job_local976434766_0001
Execution completed successfully
MapredLocal task succeeded
OK
100011  tom
100636  Divid
Time taken: 43.622 seconds, Fetched: 2 row(s)