CentOS Hive安装详细步骤

yum localinstall https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm
yum install mysql-server
systemctl enable mysqld.service
service mysqld start

mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password123';

远程设置：
CREATE USER 'root'@'%' IDENTIFIED BY 'password123';
grant all on *.* to 'root'@'%';

cd /opt/hive-2.3.9/conf/
cp hive-default.xml.template hive-site.xml
cp hive-env.sh.template hive-env.sh

vi /etc/profile
export HIVE_HOME=/opt/hive-2.3.9
export PATH=$HIVE_HOME/bin:$PATH
source /etc/profile

vi hive-env.sh
export HIVE_HOME=/opt/hive-2.3.9
export HIVE_CONF_DIR=/opt/hive-2.3.9/conf
export HADOOP_HOME=/opt/hadoop-3.3.1
source /etc/profile

hdfs dfs -mkdir -p /hive/warehouse
hdfs dfs -mkdi