fedora安装配置HIve报错

使用命令schematool -initSchema -dbType mysql初始化Hive元数据一直报出Underlying cause: java.lang.ClassNotFoundException : com.mysql.cj.jdbc.Driver,但是我已经在hive-lib下面加入了mysql驱动包,也配置了远程登录,有网友说要把驱动包命改成mysql-connector-java.jar我也改了,配置文件hive-site.xml也加入了相关配置代码,奇怪奇怪,烦请各位解答一下
报错代码:

[root@czq hadoop]# schematool -initSchema -dbType mysql
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/hadoop/share/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL:     jdbc:mysql://localhost:3306/hive?useSSL=false&allowPublicKeyRetrieval=true
Metastore Connection Driver :     com.mysql.cj.jdbc.Driver
Metastore connection User:     hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver
Underlying cause: java.lang.ClassNotFoundException : com.mysql.cj.jdbc.Driver
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

驱动包:

img

部分配置文件:


```xml

   <property>
             <name>javax.jdo.option.ConnectionURL</name>
            <value><![CDATA[jdbc:mysql://localhost:3306/hive?useSSL=false&allowPublicKeyRetrieval=true]]></value>
   </property>
   <property>
            <name>javax.jdo.option.ConnectionDriverName</name>
            <value>com.mysql.cj.jdbc.Driver</value>
    </property>
    <property>
                 <name>javax.jdo.option.ConnectionUserName</name>
                 <value>root</value>
                 <description>username to use against metastore database</description>
    </property>
    <property>
                <name>javax.jdo.option.ConnectionPassword</name>
               <value> **********</value>
               <description>password to use against metastore database</description>
    </property>
    <property>  
            <name>hive.metastore.warehouse.dir</name>  
           <value>/user/hive/warehouse</value>  
    </property> 

```

你的mysql是什么版本