origin:?http://blog.163.com/songyalong1117@126/blog/static/1713918972014124481752/

hadoop hive 的安裝問題??

2014-02-24 16:10:13|??分類：?hadoop|舉報|字號?訂閱

能了一下午終于把hive搞好了，其中出現很多的問題
1、hadoop和hive的版本問題，最好上網查一查，走很多的彎路啊。hadoop重裝了，hive用了兩個0.7.1和0.11和0.12，最后是0.12搞定。
2、遇到一個問題用了我將近二個小時才解決，分享下：
hive> show tables;
?
FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
?這個問題上網查了很多的資料各種的方法都有，自己都試一試，都不符合自己的東西。
解決方法：
cd ${HIVE_HOME}/bin
?
./hive -hiveconf hive.root.logger=DEBUG,console
粗無提示如下：
?java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
??? at org.apache.hadoop.hive.ql.metadata.Hive.getAllDatabases(Hive.java:1074)
??? at org.apache.hadoop.hive.ql.exec.DDLTask.showDatabases(DDLTask.java:2198)
??? at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:328)
??? at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
??? at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
??? at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1414)
??? at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1192)
??? at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1020)
??? at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
??? at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
??? at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
??? at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
??? at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
??? at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
??? 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:212)
Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
??? at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1212)
??? at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
??? at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
??? at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2372)
??? at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2383)
??? at org.apache.hadoop.hive.ql.metadata.Hive.getAllDatabases(Hive.java:1072)
??? ... 19 more
Caused by: java.lang.reflect.InvocationTargetException
??? at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
??? at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
??? at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
??? at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
??? at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1210)
??? ... 24 more
Caused by: MetaException(message:Version information not found in metastore. )
??? at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:5638)
??? at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:5622)
??? 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.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:124)
??? at $Proxy11.verifySchema(Unknown Source)
??? at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:403)
??? at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:441)
??? at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:326)
??? at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:286)
??? at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
??? at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
??? at org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4060)
??? at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:121)
??? ... 29 more
最后找到答案了：
將hive.site.xml文件中的
<property>
??<name>hive.metastore.schema.verification</name>
??<value>true</value>
???<description>
???</description>
</property>
改為false
ok了，希望對大家有幫助。

轉載于:https://blog.51cto.com/hanfei2511/1577589

總結

以上是生活随笔為你收集整理的hadoop hive 的安装问题的全部內容，希望文章能夠幫你解決所遇到的問題。

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