关于#hive#的问题,如何解决?

hive安装时遇到schemaTool failed
我运行bin/schematool -initSchema -dbType mysql -verbos
hive-site.xml文件是正确的
代码如下:

<configuration>  
     
<property>    
<name>javax.jdo.option.ConnectionURLname>        <value>jdbc:mysql://01xdy33:3306/hive3?createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8value>    
property>     
<property>        
<name>javax.jdo.option.ConnectionDriverNamename>        <value>com.mysql.jdbc.Drivervalue>    
property>    
<property>        <name>javax.jdo.option.ConnectionUserNamename>        <value>rootvalue>   
property>     
<property>       
<name>javax.jdo.option.ConnectionPasswordname>        <value>654321value>    
property>        
    
<property>        
<name>hive.server2.thrift.bind.hostname>        <value>01xdy33value>    
property>     
   
 <property>        
<name>hive.metastore.urisname>        <value>thrift://01xdy33:9083value>    
property>    
   
<property>        <name>hive.metastore.event.db.notification.api.authname>        <value>falsevalue>   
 property> 
 configuration>


但是初始化元数据依旧失败了

img

你看一下MySQL的版本,如果是8,驱动需要修改一下

<property>        
<name>javax.jdo.option.ConnectionDriverName</name>        <value>com.mysql.cj.jdbc.Driver</value>    
</property>