“决赛内容”的版本间的差异
(→修改 hive-site.xml 连接) |
|||
第20行: | 第20行: | ||
== 修改 hive-site.xml 连接 == | == 修改 hive-site.xml 连接 == | ||
+ | |||
+ | 在hive服务器 slave1 中修改 master(hive)-》slave1(hive)-》slave2(mysql) | ||
+ | |||
+ | cd $HIVE_HOME/conf && vim hive-site.xml | ||
+ | |||
+ | <configuration> | ||
+ | |||
+ | <property> | ||
+ | |||
+ | <!--hive产生元数据存放的位置 --> | ||
+ | |||
+ | <name>hive.metastore.warehouse.dir</name> | ||
+ | |||
+ | <value>/user/hive_remote/warehouse</value> | ||
+ | |||
+ | </property> | ||
+ | |||
+ | <property> | ||
+ | |||
+ | <!--连接数据库驱动,既MYSQL驱动 --> | ||
+ | |||
+ | <name>javax.jdo.option.ConnectionDriverName</name> | ||
+ | |||
+ | <value>com.mysql.jdbc.Driver</value> | ||
+ | |||
+ | </property> | ||
+ | |||
+ | <property> | ||
+ | |||
+ | <!--数据库连接JDBC的URL地址--> | ||
+ | |||
+ | <name>javax.jdo.option.ConnectionURL</name> | ||
+ | |||
+ | <value>jdbc:mysql://slave2:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value> | ||
+ | |||
+ | </property> | ||
+ | |||
+ | <!--连接数据库用户名称 --> | ||
+ | |||
+ | <property> | ||
+ | |||
+ | <name>javax.jdo.option.ConnectionUserName</name> | ||
+ | |||
+ | <value>qingjiao</value> | ||
+ | |||
+ | </property> | ||
+ | |||
+ | <!--连接数据库用户密码 --> | ||
+ | |||
+ | <property> | ||
+ | |||
+ | |||
+ | <name>javax.jdo.option.ConnectionPassword</name> | ||
+ | |||
+ | <value>123456</value> | ||
+ | |||
+ | </property> | ||
+ | |||
+ | </configuration> |
2020年11月28日 (六) 13:45的最新版本
mysql 创建用户 访问权限开放
进入MySQL
MySQL -uroot -p
修改密码策略
set global validate_password_policy=0;
set global validate_password_length=4;
创建用户 用户名为 qingjiao 密码设置为123456
create user 'qingjiao'@'%' identified by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
修改 hive-site.xml 连接
在hive服务器 slave1 中修改 master(hive)-》slave1(hive)-》slave2(mysql)
cd $HIVE_HOME/conf && vim hive-site.xml
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive_remote/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://slave2:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>qingjiao</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
</configuration>