写的不到位的地方,欢迎评论指出不足之处
本人虚拟机环境部署
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
效果
简单操作
效果