Hive安装Mysql安装

export HADOOP_CLASSPATH=$HBASE_HOME/lib/*:$CLASSPATH

yum remove mysql-libs

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

mysql-community.repo
mysql-community-source.repo

yum install mysql-server

rm -rf mysql57-community-release-el7-8.noarch.rpm

service mysqld start

cat /var/log/mysqld.log | grep password

mysql -uroot -p

alter user 'root'@'localhost' identified by 'Www_110';

create database hive;

create user 'hiveme'@'%' identified by 'Www_110';

grant all on hive.* TO 'hiveme'@'%';
grant all on hive.* TO 'hiveowner'@'localhost' identified by 'Www_110';

vim /etc/profile
export HIVE_HOME=/root/hd/apache-hive-2.3.3-bin
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HBASE_HOME/bin:$HIVE_HOME/bin

source /etc/profile

cp hive-default.xml.template hive-site.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
 <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://ip:3306/hive?useSSL=false</value>
</property>
           
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
</property>   

<property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>hiveowner</value>
</property>   

<property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>Welcowww</value>
</property>                  
</configuration>

schematool -dbType mysql -initSchema

org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
Underlying cause: java.lang.ClassNotFoundException : com.mysql.jdbc.Driver

https://downloads.mysql.com/archives/c-j/

 scp -r /Users/hh/desktop/mysql-connector-java-5.1.46-bin.jar hh555:/root/hd/apache-hive-2.3.3-bin/lib/

schematool -dbType mysql -initSchema