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 '	' 
LINES TERMINATED BY '
' 
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)