安装配置Hive时报错

bbbbb001 2013-10-09 04:34:51

安装配置Hive时报错：
FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

用调试模式报错如下：
[root@hadoop1 bin]# hive -hiveconf hive.root.logger=DEBUG,console
13/10/09 16:16:27 DEBUG common.LogUtils: Using hive-site.xml found on CLASSPATH at /opt/hive-0.11.0/conf/hive-site.xml
13/10/09 16:16:27 DEBUG conf.Configuration: java.io.IOException: config()
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1039)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:636)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

13/10/09 16:16:27 DEBUG conf.Configuration: java.io.IOException: config()
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:330)
at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1073)
at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1040)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:636)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

Logging initialized using configuration in file:/opt/hive-0.11.0/conf/hive-log4j.properties
13/10/09 16:16:27 INFO SessionState:
Logging initialized using configuration in file:/opt/hive-0.11.0/conf/hive-log4j.properties
13/10/09 16:16:27 DEBUG parse.VariableSubstitution: Substitution is on: hive
Hive history file=/tmp/root/hive_job_log_root_4666@hadoop1_201310091616_1069706211.txt
13/10/09 16:16:27 INFO exec.HiveHistory: Hive history file=/tmp/root/hive_job_log_root_4666@hadoop1_201310091616_1069706211.txt
13/10/09 16:16:27 DEBUG conf.Configuration: java.io.IOException: config()
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
at org.apache.hadoop.security.UserGroupInformation.ensureInitialized(UserGroupInformation.java:187)
at org.apache.hadoop.security.UserGroupInformation.isSecurityEnabled(UserGroupInformation.java:239)
at org.apache.hadoop.security.UserGroupInformation.getLoginUser(UserGroupInformation.java:438)
at org.apache.hadoop.security.UserGroupInformation.getCurrentUser(UserGroupInformation.java:424)
at org.apache.hadoop.hive.shims.HadoopShimsSecure.getUGIForConf(HadoopShimsSecure.java:491)
at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:51)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:365)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:270)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:670)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

13/10/09 16:16:27 DEBUG security.Groups: Creating new Groups object
13/10/09 16:16:27 DEBUG security.Groups: Group mapping impl=org.apache.hadoop.security.ShellBasedUnixGroupsMapping; cacheTimeout=300000
13/10/09 16:16:27 DEBUG security.UserGroupInformation: hadoop login
13/10/09 16:16:27 DEBUG security.UserGroupInformation: hadoop login commit
13/10/09 16:16:27 DEBUG security.UserGroupInformation: using local user:UnixPrincipal锛?root
13/10/09 16:16:27 DEBUG security.UserGroupInformation: UGI loginUser:root
13/10/09 16:16:27 DEBUG security.Groups: Returning fetched groups for 'root'
13/10/09 16:16:27 DEBUG security.Groups: Returning cached groups for 'root'
13/10/09 16:16:27 DEBUG conf.Configuration: java.io.IOException: config(config)
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:260)
at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1044)
at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.init(DefaultHiveAuthorizationProvider.java:30)
at org.apache.hadoop.hive.ql.security.authorization.HiveAuthorizationProviderBase.setConf(HiveAuthorizationProviderBase.java:108)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthorizeProviderManager(HiveUtils.java:339)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:272)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:670)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

13/10/09 16:16:27 DEBUG conf.Configuration: java.io.IOException: config()
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:227)
at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:214)
at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:330)
at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1073)
at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1045)
at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.init(DefaultHiveAuthorizationProvider.java:30)
at org.apache.hadoop.hive.ql.security.authorization.HiveAuthorizationProviderBase.setConf(HiveAuthorizationProviderBase.java:108)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthorizeProviderManager(HiveUtils.java:339)
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:272)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:670)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

...全文

2941 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

tjytad1982 2014-06-25

打赏
举报

学习

明日的明月 2014-06-25

打赏
举报

楼主，我报了同样的问题，想问你解决这个问题没有。！！！！

夏日里的温馨 2014-05-14

打赏
举报

楼主你好，我配置的hive创建了表，但是在show databases、show tables的时候出现以下异常： FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient 我用调试模式报的异常是 14/05/14 19:34:54 DEBUG conf.Configuration: java.io.IOException: config() at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:211) at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:198) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1091) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:636) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 14/05/14 19:34:54 DEBUG conf.Configuration: java.io.IOException: config() at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:211) at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:198) at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:173) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1125) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1092) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:636) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Logging initialized using configuration in file:/opt/hive/conf/hive-log4j.properties 14/05/14 19:34:55 INFO SessionState: Logging initialized using configuration in file:/opt/hive/conf/hive-log4j.properties 14/05/14 19:34:55 DEBUG parse.VariableSubstitution: Substitution is on: hive 14/05/14 19:34:55 DEBUG security.UserGroupInformation: Unix Login: root,root,bin,daemon,sys,adm,disk,wheel 14/05/14 19:34:55 DEBUG conf.Configuration: java.io.IOException: config(config) at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:226) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1096) at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.init(DefaultHiveAuthorizationProvider.java:30) at org.apache.hadoop.hive.ql.security.authorization.HiveAuthorizationProviderBase.setConf(HiveAuthorizationProviderBase.java:112) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthorizeProviderManager(HiveUtils.java:339) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:280) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:670) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) 14/05/14 19:34:55 DEBUG conf.Configuration: java.io.IOException: config() at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:211) at org.apache.hadoop.conf.Configuration.<init>(Configuration.java:198) at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:173) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1125) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:1097) at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.init(DefaultHiveAuthorizationProvider.java:30) at org.apache.hadoop.hive.ql.security.authorization.HiveAuthorizationProviderBase.setConf(HiveAuthorizationProviderBase.java:112) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117) at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthorizeProviderManager(HiveUtils.java:339) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:280) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:670) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) 请楼主帮忙看一下，可能是什么原因造成的

mearer 2014-03-26

打赏
举报

引用 5 楼 u011450470 的回复:

我也遇到这个问题了请问你是怎么解决的？

我找到问题所在了，如果你登陆mysql的IP是locahost的话，那这里的配置应该修改为 <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://192.168.1.101:3306/hive?createDatabaseIfNotExist=true</value> <description>JDBC connect string for a JDBC metastore</description> </property> 把192.168.1.101改为localhost

mearer 2014-03-26

打赏
举报

楼主，请问你解决这个问题了吗，能不能分享一下

mearer 2014-03-26

打赏
举报

我也遇到这个问题，搞了一天也没解决，求方法

lushiquanwzq 2014-03-25

打赏
举报

我也遇到这个问题了请问你是怎么解决的？

zuochanxiaoheshang 2013-10-09

打赏
举报

检查一下MySQL的hive用户（avax.jdo.option.ConnectionUserName：hive)在Hive安装的机器的IP上是否有足够的权限。

bbbbb001 2013-10-09

打赏
举报

hite-site.xml已经配置过了，如下： <property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> <description>locationof default database for the warehouse</description> </property> <property> <name>hive.exec.scratchdir</name> <value>/usr/hive/temp</value> <description>Scratchspace for Hive jobs</description> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://hadoop4:3306/hive?characterEncoding=UTF-8</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hive</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>password</value> </property>

randee_luo 2013-10-09

打赏
举报

引用 1 楼 s060403072 的回复:

这个错误应该是你集成了mysql，从而报错。解决方法是修改hive-site.xml，参照：
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.1.101:3306/hive?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>
也可参考：http://write.blog.csdn.net/postlist

嗯 +1 看错误应该是元数据库配置有问题。

海兰 2013-10-09

打赏
举报

这个错误应该是你集成了mysql，从而报错。解决方法是修改hive-site.xml，参照：

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

也可参考：http://write.blog.csdn.net/postlist