启动Hive时初始化元数据失败的问题与解决方法

启动Hive时初始化元数据失败的问题与解决方法

 INFO [main] metastore.HivemetaStore: 0: Opening raw store with implementation class:org.apache.hadoop.hive.metastore.ObjectStore
2022-01-06T10:01:13,592  INFO [main] metastore.ObjectStore: ObjectStore, initialize called
2022-01-06T10:01:13,597  WARN [main] metastore.metaStoreDirectSql: Self-test query [select "DB_ID" from "DBS"] failed; direct SQL is disabled
javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS"".
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) ~[datanucleus-api-jdo-4.2.4.jar:?]
        at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:391) ~[datanucleus-api-jdo-4.2.4.jar:?]
        at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:216) ~[datanucleus-api-jdo-4.2.4.jar:?]
        at org.apache.hadoop.hive.metastore.metaStoreDirectSql.runTestQuery(metaStoreDirectSql.java:276) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.metaStoreDirectSql.(metaStoreDirectSql.java:184) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:498) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:420) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:375) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:77) ~[hadoop-common-3.1.3.jar:?]
        at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:137) ~[hadoop-common-3.1.3.jar:?]
        at org.apache.hadoop.hive.metastore.RawStoreProxy.(RawStoreProxy.java:59) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.HivemetaStore$HMSHandler.newRawStoreForConf(HivemetaStore.java:718) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.HivemetaStore$HMSHandler.getMSForConf(HivemetaStore.java:696) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.HivemetaStore$HMSHandler.getMS(HivemetaStore.java:690) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.HivemetaStore$HMSHandler.createDefaultDB(HivemetaStore.java:767) ~[hive-exec-3.1.2.jar:3.1.2]
        at org.apache.hadoop.hive.metastore.HivemetaStore$HMSHandler.init(HivemetaStore.java:538) ~[hive-exec-3.1.2.jar:3.1.2]
        at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) ~[?:?]

 输入：schematool -dbType mysql -initSchema

[atguigu@hadoop102 bin]$ schematool -dbType mysql -initSchema
metastore connection URL:        jdbc:mysql://hadoop102:3306/metastore?useSSL=false&characterEncoding=UTF-8
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.sql



Error: Table 'ctlgs' already exists (state=42S01,code=1050)
org.apache.hadoop.hive.metastore.HivemetaException: Schema initialization FAILED! metastore state would be inconsistent !!
Underlying cause: java.io.IOException : Schema script failed, errorcode 2
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

 查看元数据./schematool -dbType mysql -info
 

[atguigu@hadoop102 bin]$ ./schematool -dbType mysql -info
metastore connection URL:        jdbc:mysql://hadoop102:3306/metastore?useSSL=false&characterEncoding=UTF-8
metastore Connection Driver :    com.mysql.jdbc.Driver
metastore connection User:       root
Hive distribution version:       3.1.0
metastore schema version:        3.1.0
schemaTool completed