localhost:~ czh$ hive hive> create table t1 (id int,name string,age int,score int) row format delimited fields terminated by ',' lines terminated by '\n' STORED AS TEXTFILE; OK Time taken: 1.554 seconds hive> load data local inpath '/Users/czh/Desktop/hive.txt' into table t1; Loading data to table default.t1 OK Time taken: 1.819 seconds hive> select * from t1; OK 1 Tommy 21 91 2 Alice 22 92 3 Jim 23 93 4 czh 24 94 5 lxy 25 95 Time taken: 3.242 seconds, Fetched: 5 row(s) hive> select * from t1 order by score desc; Query ID = czh_20181223130201_ae5128c5-e06f-41c2-a8cc-3c2413bbf113 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=<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) 2018-12-23 13:02:04,364 Stage-1 map = 100%, reduce = 100% Ended Job = job_local1021484394_0001 MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 252 HDFS Write: 126 SUCCESS Total MapReduce CPU Time Spent: 0 msec OK 5 lxy 25 95 4 czh 24 94 3 Jim 23 93 2 Alice 22 92 1 Tommy 21 91 Time taken: 2.963 seconds, Fetched: 5 row(s) hive> select avg(score) from t1; Query ID = czh_20181223130352_d81c2094-2554-4975-8940-5bf6e53dea42 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=<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) 2018-12-23 13:03:55,140 Stage-1 map = 100%, reduce = 100% Ended Job = job_local1954106451_0002 MapReduce Jobs Launched: Stage-Stage-1: HDFS Read: 378 HDFS Write: 126 SUCCESS Total MapReduce CPU Time Spent: 0 msec OK 93.0 Time taken: 2.54 seconds, Fetched: 1 row(s) hive>