hive mysql 远程_使用远程mysql作为元数据库安装Hive

环境：

CentOS6.6  hadoop1.2.1  mysql5.1.73

1、下载

[grid@hadoop1 ~]$ wget 外链网址已屏蔽

2、解压

[grid@hadoop1 ~]$ tar -zxf apache-hive-1.0.0-bin.tar.gz

3、设置环境变量

[grid@hadoop1 ~]$ vim .bash_profile

HIVE_HOME=/home/grid/apache-hive-1.0.0-bin

PATH=$PATH:$HIVE_HOME/bin

CLASSPATH=$CLASSPATH:$HIVE_HOME/lib

export HIVE_HOME PATH CLASSPATH

[grid@hadoop1 ~]$ source .bash_profile

4、编辑Hive配置文件

a、编辑 hive-env.sh ，指定 HADOOP_HOME 、HIVE_CONF_DIR

[grid@hadoop1 conf]$ pwd

/home/grid/apache-hive-1.0.0-bin/conf

[grid@hadoop1 conf]$ cp hive-env.sh.template hive-env.sh

[grid@hadoop1 conf]$ vim hive-env.sh

# Set HADOOP_HOME to point to a specific hadoop install directory

HADOOP_HOME=/home/grid/hadoop-1.2.1

# Hive Configuration Directory can be controlled by:

export HIVE_CONF_DIR=/home/grid/apache-hive-1.0.0-bin/conf

b、编辑 hive-site.xml ，修改数据库连接属性(javax.jdo.option.ConnectionURL/ConnectionDriverName/ConnectionUserName/ConnectionPassword)

[grid@hadoop1 conf]$ cp hive-default.xml.template hive-site.xml

[grid@hadoop1 conf]$ vi hive-site.xml

javax.jdo.option.ConnectionURL

jdbc:mysql://192.168.0.103:3306/hivedb

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

javax.jdo.option.ConnectionUserName

hive

javax.jdo.option.ConnectionPassword

123456

hive.metastore.uris

thrift://192.168.0.104:9083

Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.

hive.metastore.warehouse.dir

/user/hive/warehouse

location of default database for the warehouse

5、复制MySQL的JDBC驱动包到Hive的lib目录下

6、启动Hive(hadoop已启动)

启动服务端

[grid@hadoop1 ~]$ hive --service metastore

Starting Hive Metastore Server

启动客户端

[grid@hadoop1 ~]$ hive

Logging initialized using configuration in jar:file:/home/grid/apache-hive-1.0.0-bin/lib/hive-common-1.0.0.jar!/hive-log4j.properties

hive>