hive安装（一）

1、解压

[root@cluster3 hadoop]# tar -zxvf apache-hive-0.13.1-bin.tar.gz

 

2、修改环境变量

export HIVE_HOME=/usr/local/hadoop/apache-hive-0.13.1-bin
export PATH=$HIVE_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$PATH

 

2、启动Hive

hive

 

3、Hive后创建表

CREATE TABLE words
(
word STRING,
count INT
) ROW FORMAT DELIMITED 
FIELDS TERMINATED BY '\t' 
LINES TERMINATED BY '\n' 
STORED AS TEXTFILE;

 

导入Map/Reduce运行的数据：

LOAD DATA INPATH '/hadoop/output/part-r-00000' INTO TABLE words; 

 

输入HQL进行查询：

hive> select * from words;
OK
hadoop 1
hello 2
world 1
Time taken: 0.145 seconds, Fetched: 3 row(s)