hiveserver2启动：javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS""

最新推荐文章于 2023-06-13 17:23:17 发布
最新推荐文章于 2023-06-13 17:23:17 发布
阅读量1w 收藏 3
点赞数 3
分类专栏： Hadoop 文章标签： hiveserver2 select DB_ID from DB
解决Hive连接失败问题，通过初始化Hive元数据库并生成元数据表。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

原文链接：http://www.cnblogs.com/zwgblog/p/6063993.html

启动hive-metastore和hive-server2 用beeline连接hive报错

1
2
3
4
5
6
7
8
[root@node04 hive]# beeline
Beeline version 0.13.1-cdh5.3.0 by Apache Hive
beeline> !connect jdbc:hive2://172.16.145.114:10000 hive
scan complete in 3ms
Connecting to jdbc:hive2://172.16.145.114:10000
Enter password for jdbc:hive2://172.16.145.114:10000: ****
Error: Could not open connection to jdbc:hive2://172.16.145.114:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)
0: jdbc:hive2://172.16.145.114:10000 (closed)> !connect jdbc:hive2://172.16.145.114:10000 hive

确认已经赋予了hive用户在当前主机链接数据库的权限：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> select host,user from user;
+-----------+------+
| host      | user |
+-----------+------+
| %         | hive |
| 127.0.0.1 | root |
| localhost | hive |
| localhost | root |
| node04    | root |
+-----------+------+
5 rows in set (0.00 sec)

 查看metastore的日志，报错信息如下：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
        ... 47 more
2016-11-14 16:10:00,881 ERROR [main]: metastore.MetaStoreDirectSql (MetaStoreDirectSql.java:<init>(135)) - Self-test query [select "DB_ID" from "DBS"] failed; direc
t SQL is disabled
javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS"".
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
        at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:230)
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:131)
        at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:253)
        at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:224)
        at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
        at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:58)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:506)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:484)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:532)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:406)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:365)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:55)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:60)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4953)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5174)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5093)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
NestedThrowablesStackTrace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'metastore.DBS' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283)
        at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:174)
        at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeQuery(ParamLoggingPreparedStatement.java:381)
        at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:504)
        at org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:280)
        at org.datanucleus.store.query.Query.executeQuery(Query.java:1786)
        at org.datanucleus.store.query.AbstractSQLQuery.executeWithArray(AbstractSQLQuery.java:339)
        at org.datanucleus.store.query.Query.execute(Query.java:1654)
        at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:221)
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:131)
        at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:253)
        at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:224)
        at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
        at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:58)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:506)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:484)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:532)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:406)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:365)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:55)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:60)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4953)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5174)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5093)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
2016-11-14 16:10:01,019 WARN  [main]: metastore.ObjectStore (ObjectStore.java:checkSchema(6304)) - Version information not found in metastore. hive.metastore.schema
.verification is not enabled so recording the schema version 0.13.0
2016-11-14 16:10:01,063 ERROR [main]: metastore.HiveMetaStore (HiveMetaStore.java:startMetaStore(5215)) - javax.jdo.JDODataStoreException: Required table missing :
"`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable
 "datanucleus.autoCreateTables"
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:461)
        at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)
        at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
        at org.apache.hadoop.hive.metastore.ObjectStore.setMetaStoreSchemaVersion(ObjectStore.java:6398)
        at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:6308)
        at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:6286)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108)
        at com.sun.proxy.$Proxy0.verifySchema(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:485)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:532)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:406)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:365)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:55)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:60)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4953)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:5174)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:5093)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
NestedThrowablesStackTrace:|

 由报错信息猜想hive元数据表创建失败，通过查看mysql中hive的元数据库，果真里面一张表都没有。　

 通过”Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"  初步判断可能是因为这个属性没有设置。一顿百度后，看到一个帖子http://blog.youkuaiyun.com/eason_oracle/article/details/52273954，说是修改hive-site.xml:

照着做修改完后重启hive-metastore和hiveserver2，还是没有生成元数据表。

纠结了好久，确定了hive元数据库没有初始化是罪魁祸首，最后，得知hive可以通过命令初始化元数据库

第一次需要执行初始化命令：schematool -dbType mysql -initSchema

查看那初始化后的信息   schematool -dbType mysql -info

进入hive的bin目录下执行schematool脚本 :./schematool -dbType mysql -initSchema

1
2
3
4
5
6
7
8
[root@node04 bin]# ./schematool  -dbType mysql -initSchema
Metastore connection URL:        jdbc:mysql://node04:3306/metastore?createDatabaseIfNotExist=true&characterEncoding=UTF-8
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
Starting metastore schema initialization to 0.13.0
Initialization script hive-schema-0.13.0.mysql.sql
Initialization script completed
schemaTool completed

 查看初始化信息：

1
2
3
4
5
6
7
[root@node04 bin]# ./schematool -dbType mysql -info
Metastore connection URL:        jdbc:mysql://node04:3306/metastore?createDatabaseIfNotExist=true&characterEncoding=UTF-8
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
Hive distribution version:       0.13.0
Metastore schema version:        0.13.0
schemaTool completed

 查看hive的元数据库，发现表已经生成了

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
mysql> show tables;
+---------------------------+
| Tables_in_metastore       |
+---------------------------+
| BUCKETING_COLS            |
| CDS                       |
| COLUMNS_V2                |
| COMPACTION_QUEUE          |
| COMPLETED_TXN_COMPONENTS  |
| DATABASE_PARAMS           |
| DBS                       |
| DB_PRIVS                  |
| DELEGATION_TOKENS         |
| FUNCS                     |
| FUNC_RU                   |
| GLOBAL_PRIVS              |
| HIVE_LOCKS                |
| IDXS                      |
| INDEX_PARAMS              |
| MASTER_KEYS               |
| NEXT_COMPACTION_QUEUE_ID  |
| NEXT_LOCK_ID              |
| NEXT_TXN_ID               |
| NUCLEUS_TABLES            |
| PARTITIONS                |
| PARTITION_EVENTS          |
| PARTITION_KEYS            |
| PARTITION_KEY_VALS        |
| PARTITION_PARAMS          |
| PART_COL_PRIVS            |
| PART_COL_STATS            |
| PART_PRIVS                |
| ROLES                     |
| ROLE_MAP                  |
| SDS                       |
| SD_PARAMS                 |
| SEQUENCE_TABLE            |
| SERDES                    |
| SERDE_PARAMS              |
| SKEWED_COL_NAMES          |
| SKEWED_COL_VALUE_LOC_MAP  |
| SKEWED_STRING_LIST        |
| SKEWED_STRING_LIST_VALUES |
| SKEWED_VALUES             |
| SORT_COLS                

重启metastore和hiveserver2

beeline连接hiveserve2成功

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[root@node05 ~]# beeline
Beeline version 0.13.1-cdh5.3.0 by Apache Hive
beeline> !connect jdbc:hive2://node04:10000 hive
scan complete in 4ms
Connecting to jdbc:hive2://node04:10000
Enter password for jdbc:hive2://node04:10000: ****
Connected to: Apache Hive (version 0.13.1-cdh5.3.0)
Driver: Hive JDBC (version 0.13.1-cdh5.3.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://node04:10000> show tables;
+-----------+--+
| tab_name  |
+-----------+--+
+-----------+--+
No rows selected (0.261 seconds)

 

参考：http://blog.youkuaiyun.com/diudiu2025/article/details/51890673

http://blog.youkuaiyun.com/eason_oracle/article/details/52273954

hiveserver2遇到的问题
beijihukk的博客
03-01 8397
对于hiveserver，看教程是直接一个bin/hiveserver指令就启动了，但是我的总是不行，贴下输出： [root@hadoop apache-hive-2.1.1-bin]# bin/hiveserver2 which: no hbase in (/usr/share/java:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/
启动Hive时初始化元数据失败的问题与解决方法
Marquez96的博客
01-06 4860
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 [mai..
关于hive服务无法正常启动，报错 javax.jdo.JDODataStoreException: Error executing SQL query “select “DB_ID“ from “D
weixin_46555671的博客
06-13 831
2、因为我的元数据存储在Mysql中，检查Mysql的配置发现昨天对Mysql数据库的大小写是否敏感打开了，因为我的表名有挺多大写的，造成找不到表。1、执行下面代码先重新hive的service服务，并观察是否报错。发现元数据找不到metastore.dbs。
hive启动时出现javax.jdo.JDODataStoreException: Error executing SQL query
微电子学与固体电子学-俞驰
05-27 3810
启动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"
javax.jdo.JDODataStoreException: Required table missing : “`VERSION`“ in Catalog ““ Schema ““.
微信公众号: 后端码匠
05-17 1669
问题日志 Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables" org.datanucleus.store.r
PostgreSQL ERROR: invalid escape string 解决办法
12-16
Got exception: org.apache.hadoop.hive.metastore.api.MetaException javax.jdo.JDODataStoreException: Error executing JDOQL query “SELECT “THIS”.”NAME” AS NUCORDER0 FROM “DBS” “THIS” WHERE ...
spark2 任务报错
54MD的博客
12-10 598
spark2 任务报错1： ERROR Datastore.Schema: Failed initialising database. [2020-12-10 09:45:27,624] {bash_operator.py:126} INFO - Unable to open a test connection to the given database. JDBC url = jdbc:derby:;databaseName=metastore_db;create=true, username = A
hive初次安装遇到的3个错误
DATA
04-08 1万+
首次安装hive，碰到一些问题，在此记录一下， 附：hive成功安装的记录：http://blog.csdn.net/bamuta/article/details/44940523 问题1：Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient [hadoop@hadoop
hive> create database bclcredits; 2025-06-23 10:54:32,928 INFO conf.HiveConf: Using the default value passed in for log id: a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2 2025-06-23 10:54:32,929 INFO session.SessionState: Updating thread name to a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2 main 2025-06-23 10:54:32,930 INFO ql.Driver: Compiling command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7): create database bclcredits 2025-06-23 10:54:32,970 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager 2025-06-23 10:54:32,983 INFO ql.Driver: Semantic Analysis Completed (retrial = false) 2025-06-23 10:54:32,986 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null) 2025-06-23 10:54:32,991 INFO ql.Driver: Completed compiling command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7); Time taken: 0.061 seconds 2025-06-23 10:54:32,991 INFO reexec.ReExecDriver: Execution #1 of query 2025-06-23 10:54:32,992 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager 2025-06-23 10:54:32,992 INFO ql.Driver: Executing command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7): create database bclcredits 2025-06-23 10:54:33,003 INFO ql.Driver: Starting task [Stage-0:DDL] in serial mode 2025-06-23 10:54:33,023 INFO sqlstd.SQLStdHiveAccessController: Created SQLStdHiveAccessController for session context : HiveAuthzSessionContext [sessionString=a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2, clientType=HIVECLI] 2025-06-23 10:54:33,025 WARN session.SessionState: METASTORE_FILTER_HOOK will be ignored, since hive.security.authorization.manager is set to instance of HiveAuthorizerFactory. 2025-06-23 10:54:33,026 INFO metastore.HiveMetaStoreClient: Mestastore configuration metastore.filter.hook changed from org.apache.hadoop.hive.metastore.DefaultMetaStoreFilterHookImpl to org.apache.hadoop.hive.ql.security.authorization.plugin.AuthorizationMetaStoreFilterHook 2025-06-23 10:54:33,027 INFO metastore.HiveMetaStore: 0: Cleaning up thread local RawStore... 2025-06-23 10:54:33,027 INFO HiveMetaStore.audit: ugi=aaa ip=unknown-ip-addr cmd=Cleaning up thread local RawStore... 2025-06-23 10:54:33,027 INFO metastore.HiveMetaStore: 0: Done cleaning up thread local RawStore 2025-06-23 10:54:33,027 INFO HiveMetaStore.audit: ugi=aaa ip=unknown-ip-addr cmd=Done cleaning up thread local RawStore 2025-06-23 10:54:33,029 INFO metastore.HiveMetaStore: 0: Opening raw store with implementation class:org.apache.hadoop.hive.metastore.ObjectStore 2025-06-23 10:54:33,030 WARN metastore.ObjectStore: datanucleus.autoStartMechanismMode is set to unsupported value null . Setting it to value: ignored 2025-06-23 10:54:33,030 INFO metastore.ObjectStore: ObjectStore, initialize called 2025-06-23 10:54:33,033 INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL 2025-06-23 10:54:33,033 INFO metastore.ObjectStore: Initialized ObjectStore 2025-06-23 10:54:33,033 INFO metastore.RetryingMetaStoreClient: RetryingMetaStoreClient proxy=class org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=aaa (auth:SIMPLE) retries=1 delay=1 lifetime=0 2025-06-23 10:54:33,037 WARN metastore.ObjectStore: datanucleus.autoStartMechanismMode is set to unsupported value null . Setting it to value: ignored 2025-06-23 10:54:33,037 INFO metastore.ObjectStore: ObjectStore, initialize called 2025-06-23 10:54:33,039 INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL 2025-06-23 10:54:33,039 INFO metastore.ObjectStore: Initialized ObjectStore 2025-06-23 10:54:33,040 INFO metastore.RetryingMetaStoreClient: RetryingMetaStoreClient proxy=class org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ugi=aaa (auth:SIMPLE) retries=1 delay=1 lifetime=0 2025-06-23 10:54:33,040 INFO metastore.HiveMetaStore: 0: create_database: Database(name:bclcredits, description:null, locationUri:hdfs://localhost:9000/user/hive/warehouse/bclcredits.db, parameters:null, ownerName:aaa, ownerType:USER, catalogName:hive) 2025-06-23 10:54:33,040 INFO HiveMetaStore.audit: ugi=aaa ip=unknown-ip-addr cmd=create_database: Database(name:bclcredits, description:null, locationUri:hdfs://localhost:9000/user/hive/warehouse/bclcredits.db, parameters:null, ownerName:aaa, ownerType:USER, catalogName:hive) 2025-06-23 10:54:33,045 ERROR metastore.RetryingHMSHandler: AlreadyExistsException(message:Database bclcredits already exists) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:1311) 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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108) at com.sun.proxy.$Proxy38.create_database(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createDatabase(HiveMetaStoreClient.java:809) 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.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:212) at com.sun.proxy.$Proxy39.createDatabase(Unknown Source) at org.apache.hadoop.hive.ql.metadata.Hive.createDatabase(Hive.java:477) at org.apache.hadoop.hive.ql.exec.DDLTask.createDatabase(DDLTask.java:4828) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:393) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:205) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2664) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2335) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2011) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1709) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1703) at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157) at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:218) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683) 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.util.RunJar.run(RunJar.java:323) at org.apache.hadoop.util.RunJar.main(RunJar.java:236) 2025-06-23 10:54:33,047 ERROR exec.DDLTask: Failed org.apache.hadoop.hive.ql.metadata.HiveException: Database bclcredits already exists at org.apache.hadoop.hive.ql.exec.DDLTask.createDatabase(DDLTask.java:4832) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:393) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:205) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2664) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2335) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2011) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1709) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1703) at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157) at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:218) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:821) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683) 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.util.RunJar.run(RunJar.java:323) at org.apache.hadoop.util.RunJar.main(RunJar.java:236) Caused by: AlreadyExistsException(message:Database bclcredits already exists) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:1311) 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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108) at com.sun.proxy.$Proxy38.create_database(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createDatabase(HiveMetaStoreClient.java:809) 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.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:212) at com.sun.proxy.$Proxy39.createDatabase(Unknown Source) at org.apache.hadoop.hive.ql.metadata.Hive.createDatabase(Hive.java:477) at org.apache.hadoop.hive.ql.exec.DDLTask.createDatabase(DDLTask.java:4828) ... 22 more 2025-06-23 10:54:33,048 INFO reexec.ReOptimizePlugin: ReOptimization: retryPossible: false FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database bclcredits already exists 2025-06-23 10:54:33,049 ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database bclcredits already exists 2025-06-23 10:54:33,049 INFO ql.Driver: Completed executing command(queryId=aaa_20250623105432_133779d8-5bc0-4f88-b570-00c704c1efd7); Time taken: 0.057 seconds 2025-06-23 10:54:33,049 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager 2025-06-23 10:54:33,050 INFO conf.HiveConf: Using the default value passed in for log id: a0cb540e-63b3-4c46-b13f-f2a5b6ab7ce2 2025-06-23 10:54:33,050 INFO session.SessionState: Resetting thread name to main
最新发布
06-24
--查询残留记录```-**步骤2：手动删除残留记录**（谨慎！）：```sqlDELETEFROMDBSWHERENAME='bclcredits';```>**注意**：操作元数据库前需备份，避免破坏Hive服务[^3]。####3.验证权限确保执行用户有权限创建数据库...
Hive 存储元数据库MySQL：Error executing JDOQL query "SELECT '
小透明-溶冰
03-31 4830
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT 'org.apache.hadoop.hive.metastore.model.MDatabase' AS NUCLEUS_TYPE,THIS."DESC",THIS.DB_LOCATION_URI,THIS
javax.jdo.JDOFatalDataStoreException: Failed to create database 'metastore_db', see the next excepti
Ehcoing的博客
12-11 2026
Blinkdb使用hive存储数据。Hive有三种存储方式：本地Derby、本地mysql、远端mysql.当用derby存储方式的时候，运行hive会在当前目录生成一个derby文件和一个metastore_db目录。这种方式的弊端是在同一个目录下只能有一个hive客户端使用数据库，否则会提示： javax.jdo.JDOFatalDataStoreException: Fai
hive报Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection
shine302的博客
04-29 2958
Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection在hive/lib添加mysql.jar包
Failed with exception MetaException(message:javax.jdo.JDODataStoreException: Error(s) were found whi...
weixin_30415801的博客
02-08 591
hive (db_emp)> load data local inpath '/opt/datas/emp.txt' into table emp_part partition(`date`='2018120'); 在加载数据到HDFS上时，报错： Failed with exception MetaException(message:javax.jdo.JDODataStoreExce...
Error while executing SQL query on database '表名': near "truncate": syntax error
haoranhaoshi的博客
07-12 7846
SQLite不支持truncate，如果你想清空db文件里某个表的记录，可以使用delete from 表名 Connection connection = DriverManager.getConnection("jdbc:sqlite:" + DB_PATH); Statement statement = connection.createStatement(); statement.ex...
加载数据到HDFS上时，报错： Failed with exception MetaException(message:javax.jdo.JDODataStoreException
热门推荐
优快云博客专家，领域包括但不限于：AI、大数据、Python、架构师，有合作、课程、问题、疑惑请私信博主
11-21 2万+
hive (db_emp)> load data local inpath ‘/opt/datas/emp.txt’ into table emp_part partition(date=‘2018120’); 在加载数据到HDFS上时，报错： Failed with exception MetaException(message:javax.jdo.JDODataStoreExceptio...
hive2错误信息：Could not open client transport with JDBC Uri: jdbc:hive2://x:10000,lnnu is not allowed
weixin_46429290的博客
12-14 2388
Could not open client transport with JDBC Uri: jdbc:hive2://x:10000,lnnu is not allowed to impersonate root 今天使用DataGrip连接hive的时候，报了以上这个错误，检查了hiveserver2已经开启了，而且端口号10000也没有被占用 上网上找了很多帖子，是让修改hadoop的core-site文件 <property> <name>hadoop.p
报错 【hiveserver2】hive --service hiveserver2 报错 GC overhead limit exceeded
weixin_44484668的博客
02-06 2058
项目场景： hive --service hiveserver2 报错, 导致hiveserver2 服务无法使用 问题描述： Exception in thread "HiveServer2-Handler-Pool: Thread-556" java.lang.OutOfMemoryError: GC overhead limit exceeded 原因分析： hive shell脚本启动的jvm的堆内存 不足 解决方案： cp hive-env.sh.template hive-env.sh vi
2021-10-18 bin/hive --service hiveserver2 hive 执行完这个命令就一直加载session
weixin_51202216的博客
10-18 4038
[root@master hive]# bin/hive --service hiveserver2 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/hbase/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/op.
Caused by: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
06-11
这个错误通常是由于JDO配置或数据库连接配置出现问题导致的。您可以尝试以下几个解决方案： 1. 检查JDO配置文件是否正确配置。例如，确保JDO配置文件中指定的数据源与实际使用的数据源匹配。 2. 确保数据库已正确...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值