hive鐜鎼缓(hive閮ㄧ讲)

查看本地是否安装了mysql

[root@hadoop104 servers]# rpm -qa | grep mysql
mysql57-community-release-el7-10.noarch
mysql-community-libs-5.7.37-1.el7.x86_64
mysql-community-client-5.7.37-1.el7.x86_64
mysql-community-common-5.7.37-1.el7.x86_64
mysql-community-libs-compat-5.7.37-1.el7.x86_64
mysql-community-server-5.7.37-1.el7.x86_64
[root@hadoop104 servers]# 

卸载本地的mysql

[root@hadoop104 servers]# rpm -qa | grep -i mysql | xargs -n1 rpm -e --nodeps
[root@hadoop104 servers]# rpm -qa | grep mysql
[root@hadoop104 servers]# 

下载wget命令

yum -y install wget

创建mysql文件夹

mkdir -p /export/servers/mysql
cd /export/servers/mysql

下载官方mysql-rpm包

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

安装下载好的rpm包

yum -y install mysql57-community-release-el7-10.noarch.rpm

安装mysql-server

yum -y install mysql-community-server

解决mysql-serve应为密钥安装失败

gpg --export -a 3a79bd29 > 3a79bd29.asc
rpm --import 3a79bd29.asc
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

再次安装mysql-server

yum -y install mysql-community-server

启动mysql

systemctl start  mysqld.service

查看MySQL状态

service mysqld status

查看MySQL初始密码

grep 'password' /var/log/mysqld.log

通过初始密码登录mysql

mysql -uroot -p
xxxx

如果能够通过临时密码进入mysql则修改root密码

ALTER USER USER() IDENTIFIED BY 'QWqw0613#';

并且给Linux中mysql设置所有人可以登录权限

use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

如果出现拒绝用密码访问的错误

# RROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
# 首先得编辑 vim /etc/my.cnf
# 只在[mysqld]下添加一条skip-grant-tables语句
vim /etc/my.cnf
[mysqld]
skip-grant-tables
# wq保存退出

#重启mysql服务
service mysqld restart

# mysql -uroot -p不需要输入密码接着按两次回车即可进入mysql
mysql -uroot -p回车
回车

#修改root用户密码
user mysql;
update user set authentication_string=password('QWqw0613#') where user='root';

# 并且给Linux中mysql设置所有人可以登录权限
use mysql;
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

# 退出MySQL
exit;

# 将刚才在/etc/my.cof里面添加的skip-grant-tables删除
vim /etc/my.cnf
[mysqld]
# wq保存退出

#重启mysql服务
service mysqld restart

设置完成之后就可以用mysql -uroot -pQWqw0613#登录mysql了

[root@hadoop102 etc]# mysql -root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.7.37 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> 

配置hive
进入hive安装目录的conf目录下

cd /export/servers/hive/conf
cp hive-env.sh.template hive-env.sh

编辑hive-env.sh文件

export HADOOP_HOME=/export/servers/hadoop
export HIVE_CONF_DIR=/export/servers/hive/conf
export HIVE_AUX_JARS_PATH=/export/servers/hive/lib
export JAVA_HOME=/export/servers/jdk

新建hive-site.xml并配置相关信息

vim /export/servers/hive/conf/hive-site.xml

	
        hive.metastore.warehouse.dir
        /user/hive_local/warehouse
    
	
	
        hive.exec.scratchdir
        /tmp_local/hive
    
	
	
        hive.metastore.local
        true
    
	
    
        javax.jdo.option.ConnectionURL
         jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8
    
 
    
        javax.jdo.option.ConnectionDriverName
        com.mysql.jdbc.Driver
    
 
    
        javax.jdo.option.ConnectionUserName
        root
    
 
    
        javax.jdo.option.ConnectionPassword
        QWqw0613#
    
 
    
        hive.metastore.event.db.notification.api.auth
        false
    
 
    
        hive.metastore.schema.verification
        false
    

上传JDBC 连接MySQL的驱动包到lib目录下面

scp -r D:桌面hadoop笔记资料4_jar包java栈包mysql-connector-java-5.1.32.jar root@hadoop102:/export/servers/hive/lib

配置hive环境变量

cd /etc/profile.d
vim ./my_env.sh
# 编辑内容如下
export HIVE_HOME=/export/servers/hive
export PATH=$PATH:$HIVE_HOME/bin
# 刷新环境变量
source /etc/profile

初始化mysql

schematool -initSchema -dbType mysql

至此hive的本地模式搭建完成