hive 启动提交sql报错

hive版本 3.1.2
hadoop 3.1.0
元数据存放在mysql中 mysql版本5.7

我初始化了元数据
schematool -dbType mysql -initSchema
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/module/hbase/hbase1.3.1/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/module/hadoop3.x/hadoop-3.1.3/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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.slf4j.impl.Log4jLoggerFactory]
Metastore connection URL: jdbc:mysql://hadoop100:3306/metastore?useSSL=false
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: root
Starting metastore schema initialization to 3.1.0
Initialization script hive-schema-3.1.0.mysql.sq
Initialization script completed
schemaTool completed
登入hive 执行show databases;

FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

网上都说没有初始化 但我初始化过的
配置文件

<configuration> 
     
    <property> 
        <name>javax.jdo.option.ConnectionURL</name> 
        <value>jdbc:mysql://hadoop100:3306/metastore?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>root</value> 
    </property> 
 
   
    <property> 
        <name>javax.jdo.option.ConnectionPassword</name>    
     <value>000000</value> 
</property> 
 
    
    <property> 
        <name>hive.metastore.schema.verification</name>        
 <value>false</value> 
</property> 
 
     
    <property> 
        <name>hive.metastore.event.db.notification.api.auth</name> 
        <value>false</value>     
</property> 

    
    <property> 
        <name>hive.metastore.warehouse.dir</name> 
        <value>/user/hive/warehouse</value> 
    </property> 
</configuration> 

求解

-分割线

我尝试降低hive版本至2. X
可以执行查询sql 插入 sql报找不到枚举常量
版本不兼容所致
官网推荐的版本 无法启用客户端会话
或找不到method ...get password()