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

最新推荐文章于 2024-05-12 15:33:22 发布
最新推荐文章于 2024-05-12 15:33:22 发布
阅读量1w 收藏 3
点赞数 3
分类专栏： Hadoop 文章标签： hiveserver2 select DB_ID from DB

原文链接：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.csdn.net/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.csdn.net/diudiu2025/article/details/51890673

http://blog.csdn.net/eason_oracle/article/details/52273954

nana-li
关注
  • 3
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
启动Hive时初始化元数据失败的问题与解决方法
Marquez96的博客
01-06 4595
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 存储元数据库MySQL：Error executing JDOQL query "SELECT '
小透明-溶冰
03-31 4621
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
关于hive服务无法正常启动，报错 javax.jdo.JDODataStoreException: Error executing SQL query “select “DB_ID“ from “D
weixin_46555671的博客
06-13 530
2、因为我的元数据存储在Mysql中，检查Mysql的配置发现昨天对Mysql数据库的大小写是否敏感打开了，因为我的表名有挺多大写的，造成找不到表。1、执行下面代码先重新hive的service服务，并观察是否报错。发现元数据找不到metastore.dbs。
正确解决com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常的有效解决方法
最新发布
wbajsjhhhhh的博客
05-12 2957
正确解决com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常的有效解决方法
hive启动时出现javax.jdo.JDODataStoreException: Error executing SQL query
微电子学与固体电子学-俞驰
05-27 3507
启动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"
windows搭建hadoop
chenzhen7454的博客
01-05 566
1. Java 下载Java 1.8 64位版本https://java.com/en/download/. 如果不是64位java，在启动资源节点管理器时会出现错误 Java 安装自选目录, 必须是中间不带空格的目录结构：比如C:\java64 安装完成后，使用“java -version”命令在命令行中确认运行了正确的版本 　　 C:\Users>java -version java version "1.8.0_251" Java(TM) SE Runtime Environment ..
javax.jdo-3.2.0-m3-API文档-中英对照版.zip
07-14
赠送jar包：javax.jdo-3.2.0-m3.jar； 赠送原API文档：javax.jdo-3.2.0-m3-javadoc.jar； 赠送源代码：javax.jdo-3.2.0-m3-sources.jar； 赠送Maven依赖信息文件：javax.jdo-3.2.0-m3.pom； 包含翻译后的API文档：...
Java xml出现错误 javax.xml.transform.TransformerException: java.lang.NullPointerException
09-01
主要介绍了Java xml出现错误 javax.xml.transform.TransformerException: java.lang.NullPointerException的相关资料,需要的朋友可以参考下
javax.enterprise.deploy:javax.enterprise.deploy api的存储库
05-17
:warning: 该项目现在是EE4J计划的一部分。 该仓库已被归档，因为所有活动现在都在。 有关整体EE4J过渡状态，请参见。 javax.enterprise.deploy javax.enterprise.deploy API的存储库
javax.mail.SendFailedException: Sending failed问题原因
09-03
主要介绍了javax.mail.SendFailedException: Sending failed问题原因,需要的朋友可以参考下
javax.servlet-3.0.0.v201112011016-API文档-中文版.zip
06-04
赠送jar包：javax.servlet-3.0.0.v201112011016.jar； 赠送原API文档：javax.servlet-3.0.0.v201112011016-javadoc.jar； 赠送源代码：javax.servlet-3.0.0.v201112011016-sources.jar； 赠送Maven依赖信息文件：...
安装hive出现的各种问题(这些问题出现在spark连接mysql的时候)
微电子学与固体电子学-俞驰
07-21 1391
首先在启动hive的时候，进入debug模式， hive -hiveconf hive.root.logger=DEBUG,console 才能出现下面的信息，终端上的信息会非常多，我们可以按下shift+pageup键，把信息拷贝到一个txt上，然后搜索error这个单词所在位置，往往就是报错信息，然后进行不断地人机交互． 进入hive 执行show databases时报错， 错误如下...
Hive启动错误Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the giv
十二
02-17 4566
hive启动时报错Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true, username = roo...
hive从mysql恢复数据_根据mysql元数据还原hive建表语句
weixin_33925615的博客
01-20 242
#!/usr/bin/env python#-*- coding:utf8 -*-# 从mysql中提取hive建表语句import osimport fileinputimport datetimeimport mysql.connectordef hive_create_table():#conn = mysql.connector.connect(host="11.11.11.11",use...
安装hive出现的各种问题
记录
12-05 6248
进入hive 执行show databases时报错，利用/usr/local/Cellar/hive/2.3.1/libexec/bin目录下的hive进入hive，再执行show databases查看日志：./hive -hiveconf hive.root.logger=DEBUG,console报如下错误： The specified datastore driver (“com.my
spark2 任务报错
54MD的博客
12-10 524
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
Error while compiling statement: FAILED: LockException [Error 10280]
微电子学与固体电子学-俞驰
12-14 2272
beeline在创建数据库时碰见报错 Error: Error while compiling statement: FAILED: LockException [Error 10280]: Error communicating with the metastore (state=42000,code=10280) 去$HIVE_HOME/logs看了下报错 javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_I
2021-10-18 bin/hive --service hiveserver2 hive 执行完这个命令就一直加载session
weixin_51202216的博客
10-18 3447
[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. 确保数据库已正确配置，并且数据库服务正在运行。您可以尝试使用数据库命令行工具连接到数据库并测试连接。 3. 检查数据库连接属性是否正确设置。例如，确保数据库连接URL、用户名和密码等属性与实际使用的数据库匹配。 4. 确保数据库驱动程序已正确安装并在类路径中可用。 如果您仍然无法解决问题，请提供更多细节，我会尽力帮助您解决问题。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值