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
