hive mysql集群安装_hive集群模式安装

hadoop3.2.0 完全分布式安装 hive-3.1.1

#解压缩

tar -zxvf /usr/local/soft/apache-hive-3.1.1-bin.tar.gz -C /usr/local/

#修改目录名称

mv /usr/local/apache-hive-3.1.1-bin/ /usr/local/apache-hive-3.1.1

vim /etc/profile

#增加HIVE环境变量内容

export HIVE_HOME=/usr/local/apache-hive-3.1.1export PATH=$PATH:$HIVE_HOME/bin

export CLASSPATH=$CLASSPATH:$HIVE_HOME/bin

使环境变量生效：source /etc/profile

vim /usr/local/apache-hive-3.1.1/conf/hive-env.sh

#增加内容

export HADOOP_HOME=/usr/local/hadoop-3.1.1export HIVE_CONF_DIR=/usr/local/apache-hive-3.1.1/conf

vim /usr/local/apache-hive-3.1.1/conf/hive-site.xml

javax.jdo.option.ConnectionURL

jdbc:mysql://192.168.67.1:3306/hadoop_hive_meta?allowMultiQueries=true&useSSL=false&verifyServerCertificate=false

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

javax.jdo.option.ConnectionUserName

数据库用户名

javax.jdo.option.ConnectionPassword

数据库密码

datanucleus.readOnlyDatastore

false

datanucleus.fixedDatastore

false

datanucleus.autoCreateSchema

true

datanucleus.autoCreateTables

true

datanucleus.autoCreateColumns

true

#将下载好的 mysql 驱动拷贝到hive的lib目录中

cp /usr/local/soft/mysql-connector-java-8.0.12.jar /usr/local/apache-hive-3.1.1/lib/

#在 mysql 服务器中新建空数据库 hadoop_hive_meta，跟 hive-site.xml 中配置的数据库名称一致

#首次启动初始化schema

schematool -dbType mysql -initSchema