关于#hive#的问题，如何解决？

Question

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

<configuration>  
     
<property>    
<name>javax.jdo.option.ConnectionURL</name>        <value>jdbc:mysql://01xdy33:3306/hive3?createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8</value>    
</property>     
<property>        
<name>javax.jdo.option.ConnectionDriverName</name>        <value>com.mysql.jdbc.Driver</value>    
</property>    
<property>        <name>javax.jdo.option.ConnectionUserName</name>        <value>root</value>   
</property>     
<property>       
<name>javax.jdo.option.ConnectionPassword</name>        <value>654321</value>    
</property>        
    
<property>        
<name>hive.server2.thrift.bind.host</name>        <value>01xdy33</value>    
</property>     
   
 <property>        
<name>hive.metastore.uris</name>        <value>thrift://01xdy33:9083</value>    
</property>    
   
<property>        <name>hive.metastore.event.db.notification.api.auth</name>        <value>false</value>   
 </property> 
 </configuration>

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

Answer 1

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

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