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)