安装MySQL
1.上传安装包
2.安装mysql
yum –y mysql57-community-release-el7-9.noarch.rpm
3.安装数据库服务
yum -y install mysql-community-server
4.重新启动mysql服务,输入以下命令:
systemctl restart mysqld
5.查找初始密码
grep “password” /var/log/mysqld.log
如果初始密码不显示,就做免密(vi /etc/my.cnf)
添加
skip-grant-tables
修改密码后将以上的删除,然后重启
6.登录mysql
mysql -uroot -p
7.设置密码强度
set global validate_password_policy=LOW;
8.设置密码长度
set global validate_password_length=4;
9.修改密码
alter user 'root'@'localhost' identified '密码';
10.退出mysql
exit;
安装hive
1.安装hive压缩包
2.解压压缩包
tar -zxvf apache-hive-3.1.2-bin.tar.gz -C /opt/module/
3.修改hive名字
mv apache-hive-3.1.2-bin hive-3.1.2
4.配置环境变量(vi /etc/profile)在profile末尾添加,生效环境变量
export HIVE_HOME=/opt/module/hive-3.1.2
export PATH=$PATH:$HIVE_HOME/bin
source /etc/profile
5.安装MySQL的jar包放到/opt/software/
6.将jar包复制到hive/lib中
cp /opt/software/mysql-connector-java-5.1.37.jar $HIVE_HOME/lib
7.在hive下的conf中配置文件hive-site.sh
<configuration>
<!--hive连接数据库URL-->
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hivedb?useSSL=false</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<!-- JDBC的连接的Driver-->
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<!-- JDBC的连接username-->
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>
<!-- JDBC的连接密码-->
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<!-- mysql的密码-->
<value></value>
<description>password to use against metastore database</description>
</property>
<!-- Hive数据仓库的数据存储在HDFS上的目录-->
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
<description>hive default warehouse, if nessecory, change it</description>
</property>
<!-- Hive Server2 的连接端口-->
<property>
<name>hive.server2.thrift.port</name>
<value>10000</value>
</property>
<!-- Hive Server2 的连接host-->
<property>
<name>hive.server2.thrift.bind.host</name>
<value>10000</value>
</property>
<!--存储元数据要连接的地址-->
<property>
<name>hive.metastore.uris</name>
<value>thrift://localhost:9083</value>
</property>
<!-- 元数据存储授权-->
<property>
<name>hive.metastore.event.db.notification.api.auth</name>
<value>false</value>
</property>
<!-- 元数据储存版权的认证-->
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
</property>
<!-- Server2的高可用参数,开启参数可以提高hiveservers2的1启动速度-->
<property>
<name>hive.server2.active.passive.ha.enable</name>
<value>true</value>
</property>
</configuration>
8.修改hive-env.sh.template为hive-env.sh、
export HADOOP_HOME=/opt/module/hadoop-3.1.4
export HIVE_CONF_DIR=/opt/module/hive-3.1.2/conf
9.进入mysql并建立数据库hivedb
create database hivedb
10.允许所有机器能访问root用户
use mysql;
update user set host='%' where user ='root';
FLUSH PRIVILEGES;
11.初始化元数据
schematool -dbType mysql -initSchema
12.启动元数据服务
cd /opt/module/hive-3.1.2/bin
./hive --service metastore &
13.启动hive
hive