hive 安装 bug汇总

最新推荐文章于 2025-11-29 18:33:44 发布

原创最新推荐文章于 2025-11-29 18:33:44 发布 · 177 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#hive #hadoop

本文详细介绍了在使用Hive时遇到的数据库连接配置问题，包括配置JDBC连接参数、解决连接不上数据库的问题、修改元数据库字符集以解决创建表时出现的错误。并提供了具体的解决步骤和实例，帮助开发者快速定位和解决问题。

一 Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
1 hive配置文件的问题
初学者只要使用数据库连接的属性就可以啦

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://127.0.0.1:3306/metastore_db?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hive</value>
  <description>username to use against metastore database</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>a123</value>
  <description>password to use against metastore database</description>
</property>

参考：[url]http://bo-hai.iteye.com/blog/1880930[/url]
2 连接不上数据库
这里有多种原因，我列举几条
（1）连接数据库的username和password不正确。
（2）usernam的权限不够
（3）端口号写错数据库名（我写了数据库名）

二
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Error(s) were found while auto-creating/validating the datastore for classes. The errors are printed in the log, and are attached to this exception.
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

解决的方法是到mysql中的hive数据库里执行 alter database hive character set latin1;改变hive元数据库的字符集，问题就可以解决！

参考：[url]http://www.cnblogs.com/Blueren/archive/2011/06/29/Sir_001.html[/url]

三
show tables; 正常
创建表，抛出异常

Cannot create directory /user/hive/warehouse/test. Name node is in safe mode.

google找到

your NN is not coming out of safemode. it should do that automatically after a few seconds. use this command to come out of it manually :
bin/hadoop dfsadmin -safemode leave
then retry with your command.

使用 bin/hadoop dfsadmin -safemode leave 就可以解决