ambari hive mysql_基于Ambari的WebUI部署Hive服务

基于Ambari的WebUI部署Hive服务

作者：尹正杰

版权声明：原创作品，谢绝转载！否则将追究法律责任。

一.部署Ambari服务

博主推荐阅读:

https://www.cnblogs.com/yinzhengjie2020/p/12227503.html

二.创建Hive的元数据信息

1>.MySQL 8.x以上版本需要确认的配置文件密码策略

[[email protected] ~]# egrep -v "^#|^$" /etc/my.cnf

[mysqld]

validate_password.policy=LOW

innodb_file_format=BARRACUDA

innodb_large_prefix=trueinnodb_default_row_format=DYNAMIC

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

[[email protected]~]#

[[email protected]~]# grep validate_password.policy /etc/my.cnf

validate_password.policy=LOW

[[email protected]~]#

2>.MySQL授权用户

[[email protected] ~]# mysql -uroot -pyinzhengjie

mysql:[Warning] Using a password onthe command line interface can be insecure.

Welcometo the MySQL monitor. Commands end with ; or\g.

Your MySQL connection idis 29Server version:8.0.19 MySQL Community Server -GPL

Copyright (c)2000, 2020, Oracle and/or its affiliates. Allrights reserved.

Oracleis a registered trademark of Oracle Corporation and/orits

affiliates. Other names may be trademarksoftheir respective

owners.

Type'help;' or '\h' for help. Type &#