啟動metastore和hiveserver2后,

發現hiveserver2啟動失敗，因為沒有被占用10000端口

$HIVE_HOME/logs下出現如下報錯:

2020-05-27T22:39:52,203 WARN [pool-6-thread-1] metastore.MetaStoreDirectSql: Failed to execute [SELECT "TBLS"."TBL_NAME" FROM "TBLS" INNER JOIN "DBS" ON "TBLS"."DB_ID" = "DBS"."DB_ID" WHERE "DBS"."NAME" = ? AND "DBS"."CTLG_NAME" = ? AND "TBLS"."TBL_TYPE" = ? ] with parameters [default, hive, MATERIALIZED_VIEW] javax.jdo.JDODataStoreException: Error executing SQL query "SELECT "TBLS"."TBL_NAME" FROM "TBLS" INNER JOIN "DBS" ON "TBLS"."DB_ID" = "DBS"."DB_ID" WHERE "DBS"."NAME" = ? AND "DBS"."CTLG_NAME" = ? AND "TBLS"."TBL_TYPE" = ?".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.executeWithArray(JDOQuery.java:267) ~[datanucleus-api-jdo-4.2.4.jar:?]at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.executeWithArray(MetaStoreDirectSql.java:1997) [hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getTables(MetaStoreDirectSql.java:419) [hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.ObjectStore$2.getSqlResult(ObjectStore.java:1558) [hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.ObjectStore$2.getSqlResult(ObjectStore.java:1554) [hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:3489) [hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.ObjectStore.getTablesInternal(ObjectStore.java:1566) [hive-exec-3.0.0.jar:3.0.0]at org.apache.hadoop.hive.metastore.ObjectStore.getTables(ObjectStore.java:1542) [hive-exec-3.0.0.jar:3.0.0]at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_131]at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_131]at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97) [hive-exec-3.0.0.jar:3.0.0]at com.sun.proxy.$Proxy25.getTables(Unknown Source) [?:?]at org.apache.hadoop.hive.metastore.MaterializationsInvalidationCache$Loader.run(MaterializationsInvalidationCache.java:143) [hive-exec-3.0.0.jar:3.0.0]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_131]at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_131]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131] Caused by: java.sql.SQLSyntaxErrorException: Table 'hive.TBLS' doesn't existat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.20.jar:8.0.20]at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.20.jar:8.0.20]at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.20.jar:8.0.20]at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.20.jar:8.0.20]at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql-connector-java-8.0.20.jar:8.0.20]at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-2.6.1.jar:?]at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-2.6.1.jar:?]at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeQuery(ParamLoggingPreparedStatement.java:375) ~[datanucleus-rdbms-4.1.19.jar:?]at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:552) ~[datanucleus-rdbms-4.1.19.jar:?]at org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:645) ~[datanucleus-rdbms-4.1.19.jar:?]at org.datanucleus.store.query.Query.executeQuery(Query.java:1855) ~[datanucleus-core-4.1.17.jar:?]at org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:807) ~[datanucleus-rdbms-4.1.19.jar:?]at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368) ~[datanucleus-api-jdo-4.2.4.jar:?]... 20 more 2020-05-27T22:39:52,209 WARN [pool-6-thread-1] metastore.ObjectStore: Falling back to ORM path due to direct SQL failure (this is not an error): See previous errors; Error executing SQL query "SELECT "TBLS"."TBL_NAME" FROM "TBLS" INNER JOIN "DBS" ON "TBLS"."DB_ID" = "DBS"."DB_ID" WHERE "DBS"."NAME" = ? AND "DBS"."CTLG_NAME" = ? AND "TBLS"."TBL_TYPE" = ?". at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.executeWithArray(MetaStoreDirectSql.java:2009) at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getTables(MetaStoreDirectSql.java:419) at org.apache.hadoop.hive.metastore.ObjectStore$2.getSqlResult(ObjectStore.java:1558) 2020-05-27T22:39:52,340 ERROR [pool-6-thread-1] DataNucleus.Datastore: Error thrown executing CREATE TABLE `TBLS` (`TBL_ID` BIGINT NOT NULL,`CREATE_TIME` INTEGER NOT NULL,`DB_ID` BIGINT NULL,`LAST_ACCESS_TIME` INTEGER NOT NULL,`OWNER` VARCHAR(767) BINARY NULL,`OWNER_TYPE` VARCHAR(10) BINARY NULL,`RETENTION` INTEGER NOT NULL,`IS_REWRITE_ENABLED` BIT NOT NULL,`SD_ID` BIGINT NULL,`TBL_NAME` VARCHAR(256) BINARY NULL,`TBL_TYPE` VARCHAR(128) BINARY NULL,`VIEW_EXPANDED_TEXT` TEXT [CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_TEXT` TEXT [CHARACTER SET charset_name] [COLLATE collation_name] NULL,CONSTRAINT `TBLS_PK` PRIMARY KEY (`TBL_ID`) ) ENGINE=INNODB : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:92)at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:879)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:830)at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:546)at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:609)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3385)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896)at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1627)at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:672)at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:425)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:865)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:347)at org.datanucleus.store.query.Query.executeQuery(Query.java:1816)at org.datanucleus.store.query.Query.executeWithArray(Query.java:1744)at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368)at org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:267)at org.apache.hadoop.hive.metastore.ObjectStore.getTablesInternalViaJdo(ObjectStore.java:1594)at org.apache.hadoop.hive.metastore.ObjectStore.access$100(ObjectStore.java:244)at org.apache.hadoop.hive.metastore.ObjectStore$2.getJdoResult(ObjectStore.java:1564)at org.apache.hadoop.hive.metastore.ObjectStore$2.getJdoResult(ObjectStore.java:1554)at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:3498)at org.apache.hadoop.hive.metastore.ObjectStore.getTablesInternal(ObjectStore.java:1566)at org.apache.hadoop.hive.metastore.ObjectStore.getTables(ObjectStore.java:1542)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97)at com.sun.proxy.$Proxy25.getTables(Unknown Source)at org.apache.hadoop.hive.metastore.MaterializationsInvalidationCache$Loader.run(MaterializationsInvalidationCache.java:143)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)at java.util.concurrent.FutureTask.run(FutureTask.java:266)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)at java.lang.Thread.run(Thread.java:748)2020-05-27T22:39:52,341 ERROR [pool-6-thread-1] Datastore.Schema: An exception was thrown while adding/validating class(es) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:92)at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:879)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:830)at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:546)at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:609)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3385)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896)at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1627)at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:672)at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:425)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:865)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:347)at org.datanucleus.store.query.Query.executeQuery(Query.java:1816)at org.datanucleus.store.query.Query.executeWithArray(Query.java:1744)at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368)at org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:267)at org.apache.hadoop.hive.metastore.ObjectStore.getTablesInternalViaJdo(ObjectStore.java:1594)at org.apache.hadoop.hive.metastore.ObjectStore.access$100(ObjectStore.java:244)at org.apache.hadoop.hive.metastore.ObjectStore$2.getJdoResult(ObjectStore.java:1564)at org.apache.hadoop.hive.metastore.ObjectStore$2.getJdoResult(ObjectStore.java:1554)at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:3498)at org.apache.hadoop.hive.metastore.ObjectStore.getTablesInternal(ObjectStore.java:1566)at org.apache.hadoop.hive.metastore.ObjectStore.getTables(ObjectStore.java:1542)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97)at com.sun.proxy.$Proxy25.getTables(Unknown Source)at org.apache.hadoop.hive.metastore.MaterializationsInvalidationCache$Loader.run(MaterializationsInvalidationCache.java:143)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)at java.util.concurrent.FutureTask.run(FutureTask.java:266)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)at java.lang.Thread.run(Thread.java:748)2020-05-27T22:39:52,465 ERROR [pool-6-thread-1] DataNucleus.Datastore: Error thrown executing CREATE TABLE `TBLS` (`TBL_ID` BIGINT NOT NULL,`CREATE_TIME` INTEGER NOT NULL,`DB_ID` BIGINT NULL,`LAST_ACCESS_TIME` INTEGER NOT NULL,`OWNER` VARCHAR(767) BINARY NULL,`OWNER_TYPE` VARCHAR(10) BINARY NULL,`RETENTION` INTEGER NOT NULL,`IS_REWRITE_ENABLED` BIT NOT NULL,`SD_ID` BIGINT NULL,`TBL_NAME` VARCHAR(256) BINARY NULL,`TBL_TYPE` VARCHAR(128) BINARY NULL,`VIEW_EXPANDED_TEXT` TEXT [CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_TEXT` TEXT [CHARACTER SET charset_name] [COLLATE collation_name] NULL,CONSTRAINT `TBLS_PK` PRIMARY KEY (`TBL_ID`) ) ENGINE=INNODB : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:92)at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:879)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:830)at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:546)at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:609)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3385)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896)at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1627)at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:672)at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:425)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:865)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:347)at org.datanucleus.store.query.Query.executeQuery(Query.java:1816)at org.datanucleus.store.query.Query.executeWithArray(Query.java:1744)at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368)at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:255)at org.apache.hadoop.hive.metastore.ObjectStore.getTableObjectsByName(ObjectStore.java:1841)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97)at com.sun.proxy.$Proxy25.getTableObjectsByName(Unknown Source)at org.apache.hadoop.hive.metastore.MaterializationsInvalidationCache$Loader.run(MaterializationsInvalidationCache.java:142)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)at java.util.concurrent.FutureTask.run(FutureTask.java:266)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)at java.lang.Thread.run(Thread.java:748)2020-05-27T22:39:52,465 ERROR [pool-6-thread-1] Datastore.Schema: An exception was thrown while adding/validating class(es) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14 java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[CHARACTER SET charset_name] [COLLATE collation_name] NULL,`VIEW_ORIGINAL_T' at line 14at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:92)at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:879)at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:830)at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:546)at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:609)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3385)at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896)at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1627)at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:672)at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:425)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:865)at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:347)at org.datanucleus.store.query.Query.executeQuery(Query.java:1816)at org.datanucleus.store.query.Query.executeWithArray(Query.java:1744)at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368)at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:255)at org.apache.hadoop.hive.metastore.ObjectStore.getTableObjectsByName(ObjectStore.java:1841)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:97)at com.sun.proxy.$Proxy25.getTableObjectsByName(Unknown Source)at org.apache.hadoop.hive.metastore.MaterializationsInvalidationCache$Loader.run(MaterializationsInvalidationCache.java:142)at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)at java.util.concurrent.FutureTask.run(FutureTask.java:266)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)at java.lang.Thread.run(Thread.java:748)2020-05-27T22:39:52,469 INFO [pool-6-thread-1] metastore.MaterializationsInvalidationCache: Initialized materializations invalidation cache

這個是因為元數據庫被破壞造成的，破壞的原因可以是,你刪除了hive數據庫，但是沒有初始化，然后直接去使用hive客戶端了，

此時就會導致自動生成的元數據庫不完整。

所以解決方法如下:

進入mysql,然后

mysql>drop database hive;

mysql>create database hive;

$ schematool -initSchema -dbType mysql

總結

以上是生活随笔為你收集整理的hive启动时出现javax.jdo.JDODataStoreException: Error executing SQL query的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。