hive2.0.0安装(配合hadoop2.6.0)

一、前提条件

安装了Hadoop2.6.0，并且配置了相关环境变量。jdk安装，免密登录设置，环境变量设置。

JAVA_HOME
JRE_HOME
CLASSPATH
PATH

二、安装配置

1、下载hive apache-hive-2.0.0-bin.tar.gz

2、解压缩并修改配置文件

tar -xzvf apache-hive-2.0.0-bin.tar.gz
mv apache-hive-2.0.0-bin hive-2.0.0
cd hive-2.0.0/conf
cp hive-default.xml.template hive-site.xml
vim hive-site.xml

javax.jdo.option.ConnectionURL

jdbc:mysql://192.168.245.4:3306/hive?createDatebaseIfNotExist=true

javax.jdo.option.ConnectionDriver

com.mysql.jdbc.Driver

javax.jdo.option.ConnectionUserName

feiy

javax.jdo.option.ConnectionPassword

123456

3、设置环境变量

vi /etc/profile.d/hadoop.sh

$HIVE_HOME=/to/your/hive/path

$PATH=$HIVE_HOME/bin:$PATH

4、将mysql的jar包放入$HIVE_HOME/lib目录下

---

补充

start from hive 2.1 we neet to run the schematool command below as initialization step ,for example,we can use ‘mysql’ as dbtype

schematool -dbType mysql –initSchema

三、测试

>hive
>create table h_user(id int ,name string)row format delimited fields terminated by '\t';
>show tables
OK
h_user
Time taken: 1.68 seconds, Fetched: 1 row(s)
>describe h_user;
OK
id                      int                                         
name                    string                                      
Time taken: 0.385 seconds, Fetched: 2 row(s)
>load data local inpath './user.txt' into table h_user;
>select * from h_user;
OK
1       yangfei
2       yangyi
3       majing
Time taken: 4.475 seconds, Fetched: 3 row(s)