Hive：远程访问（元数据）数据库

写的不到位的地方，欢迎评论指出不足之处

本人虚拟机环境部署

	one	two	three	four
NameNode	yes	yes
DataNode		yes	yes	yes
ZookepperFailoverController	yes	yes
Zookepper		yes	yes	yes
NodeManage		yes	yes	yes
JournalNode	yes	yes	yes
ResourceManager			yes	yes
Mysql	yes
Hive		yes

---

Remote Metastore Database

Server Configuration

Config Param	Config Value	Comment
javax.jdo.option.ConnectionURL	jdbc:mysql://<host name>/<database name>?createDatabaseIfNotExist=true	mysql 连接
javax.jdo.option.ConnectionDriverName	com.mysql.jdbc.Driver	mysql 驱动
javax.jdo.option.ConnectionUserName	<username>	mysql 用户
javax.jdo.option.ConnectionPassword	<password>	mysql 密码

MySql 安装配置

安装

yum install mysql-server
service mysqld start

配置

show databases;
use mysql;
select host,user,password from user;
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;

# 在mysql里 flush privileges 刷新权限
# 或
# 退出，重启mysql
service mysqld restart
# 自动启动
chkconfig mysqld on

Hive 安装配置

解压 hive 后配置环境变量

export HIVE_HOME=/opt/apache-hive-2.3.4-bin
export PATH=$PATH:${JAVA_HOME}/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$ZOOKEEPER_HOME/bin:$HIVE_HOME/bin

将 hive/conf/hive-default.xml.template  改名为 hive-site.xml

<property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/var/hive/warehouse</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://one:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>123456</value>
</property>

初始化

[root@two conf]# schematool -dbType mysql -initSchema

效果

启用

[root@two conf]# hive

效果

 简单操作

效果