一、上传

• 获得apache-hive-0.13.0-bin.tar.gz

• 上传

二、安装Hive

• 解压apache-hive-0.13.0-bin.tar.gz

  tar -zxvf apache-hive-0.13.0-bin.tar.gz -C /softWare/

三、使用Hive

• 启动Hive

  cd /softWare/apache-hive-0.13.0-bin/bin
  [root@hadoop03 bin]# ./hive

• show tables

  hive> show tables;
  OK
  Time taken: 0.061 seconds

• show databases

  hive> show databases;
  OK
  default
  Time taken: 0.042 seconds, Fetched: 1 row(s)

• use default(数据库名)

  hive> use default;
  OK
  Time taken: 0.027 seconds

• create table students (s_id int,s_name string)

  hive> create table students (s_id int,s_name string);
  OK
  Time taken: 0.536 seconds
  hive> show tables;
  OK
  students
  Time taken: 0.082 seconds, Fetched: 1 row(s)

• describe students

  hive> describe students;
  OK
  s_id                	int                 	                    
  s_name              	string              	                    
  Time taken: 0.306 seconds, Fetched: 2 row(s)

• select * from students

  hive> select * from students;
  OK
  Time taken: 0.32 seconds

• select count(*) from students

  hive> select count(*) from students;
  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>
  Starting Job = job_1532882569615_0001, Tracking URL = http://hadoop03:8088/proxy/application_1532882569615_0001/
  Kill Command = /softWare/hadoop-2.2.0/bin/hadoop job  -kill job_1532882569615_0001
  Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
  2018-07-29 15:36:29,344 Stage-1 map = 0%,  reduce = 0%
  2018-07-29 15:36:52,819 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 5.01 sec
  2018-07-29 15:37:11,736 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 6.99 sec
  MapReduce Total cumulative CPU time: 6 seconds 990 msec
  Ended Job = job_1532882569615_0001
  MapReduce Jobs Launched: 
  Job 0: Map: 1  Reduce: 1   Cumulative CPU: 6.99 sec   HDFS Read: 251 HDFS Write: 2 SUCCESS
  Total MapReduce CPU Time Spent: 6 seconds 990 msec
  OK
  0
  Time taken: 70.546 seconds, Fetched: 1 row(s)

• 加载本地数据到Hive（load data local inpath '/s.txt' into table students）

  [root@hadoop03 /]# vim s.txt
  xiaoming        12
  xiaoliang       13
  xiaohong        11
  
  hive> load data local inpath '/s.txt' into table students;
  Copying data from file:/s.txt
  Copying file: file:/s.txt
  Loading data to table default.students
  Table default.students stats: [numFiles=1, numRows=0, totalSize=38, rawDataSize=0]
  OK
  Time taken: 1.066 seconds
  hive> select * from students;
  OK
  NULL	NULL
  NULL	NULL
  NULL	NULL
  NULL	NULL
  Time taken: 0.111 seconds, Fetched: 4 row(s)
  [root@hadoop03 /]# vim s.txt
  xiaoming|12
  xiaoliang|13
  xiaohong|11
  hive> load data local inpath '/s.txt' into table students;
  Copying data from file:/s.txt
  Copying file: file:/s.txt
  Loading data to table default.students
  Table default.students stats: [numFiles=2, numRows=0, totalSize=76, rawDataSize=0]
  OK
  Time taken: 0.51 seconds
  hive> select * from students;                             
  OK
  NULL	NULL
  NULL	NULL
  NULL	NULL
  NULL	NULL
  NULL	NULL
  NULL	NULL
  NULL	NULL
  NULL	NULL
  Time taken: 0.041 seconds, Fetched: 8 row(s)

• 加载本地数据到Hive（load data local inpath '/t.txt' into table teacher;）

  hive> create table teacher (t_id int,t_name string) row format delimited fields terminated by '\t'; 
  OK
  Time taken: 0.094 seconds
  hive> show tables;
  OK
  students
  teacher
  Time taken: 0.025 seconds, Fetched: 2 row(s)
  hive> load data local inpath '/t.txt' into table teacher;                                          
  Copying data from file:/t.txt
  Copying file: file:/t.txt
  Loading data to table default.teacher
  Table default.teacher stats: [numFiles=1, numRows=0, totalSize=31, rawDataSize=0]
  OK
  Time taken: 0.334 seconds
  hive> select * from teacher;                                                                       
  OK
  NULL	45
  NULL	35
  NULL	56
  NULL	NULL
  Time taken: 0.083 seconds, Fetched: 4 row(s)
  
  hive> load data local inpath '/t.txt' into table teacher;
  Copying data from file:/t.txt
  Copying file: file:/t.txt
  Loading data to table default.teacher
  Table default.teacher stats: [numFiles=2, numRows=0, totalSize=62, rawDataSize=0]
  OK
  Time taken: 0.896 seconds
  hive> select * from teacher;                             
  OK
  NULL	45
  NULL	35
  NULL	56
  NULL	NULL
  45	zhangsan
  35	lisi
  65	wangwu
  NULL	NULL
  Time taken: 0.038 seconds, Fetched: 8 row(s)