重新build hadoop后进入hive客户端异常
在自己虚拟机上使用mysql作为hive元数据存储, 修改配置如下:[*]<property>
[*]<name>javax.jdo.option.ConnectionURL</name>
[*]<value>jdbc:mysql://localhost:3306/metastore</value>
[*]<description>JDBCconnectstringforaJDBCmetastore</description>
[*]</property>
[*]
[*]<property>
[*]<name>javax.jdo.option.ConnectionDriverName</name>
[*]<value>com.mysql.jdbc.Driver</value>
[*]<description>DriverclassnameforaJDBCmetastore</description>
[*]</property>
[*]
[*]<property>
[*]<name>javax.jdo.option.ConnectionUserName</name>
[*]<value>hive</value>
[*]<description>usernametouseagainstmetastoredatabase</description>
[*]</property>
[*]
[*]<property>
[*]<name>javax.jdo.option.ConnectionPassword</name>
[*]<value>hive</value>
[*]<description>passwordtouseagainstmetastoredatabase</description>
[*]</property>
并将mysql jdbc驱动拷贝到HIVE_HOME/lib目录下.
接下去登陆hive客户端，执行show databases；命令, 异常:
[*]$hive
[*]Hivehistoryfile=/tmp/ruize/hive_job_log_ruize_201204091822_467986476.txt
[*]hive>showdatabases;
[*]FAILED:Errorinmetadata:javax.jdo.JDOFatalInternalException:Unexpectedexceptioncaught.
[*]NestedThrowables:
[*]java.lang.reflect.InvocationTargetException
[*]FAILED:ExecutionError,returncode1fromorg.apache.hadoop.hive.ql.exec.DDLTask
[*]hive>
被这个问题困扰好久, 同样的配置在自己笔记本环境上可以，但在公司机器上异常,
最后网上搜索了一把，发现解决方法如下:
[*]delete$HADOOP_HOME/buildandeverythingshouldbefine
切换到 HADOOP_HOME目录:
[*]$pwd
[*]/opt/app/hadoop-0.20.2-cdh3u3/build
[*]$ls
[*]antc++classescontribexampleshadoop-core-0.20.2-cdh3u3.jarhadoop-tools-0.20.2-cdh3u3.jarivysrctesttoolswebapps
[*]$
果然在HADOOP_HOME/build目录下有新build的信息(我用ant重新build过hadoop)
直接删除build目录:
[*]$rm-rfbuild
重新进入hive客户端:
[*]$hive
[*]Hivehistoryfile=/tmp/ruize/hive_job_log_ruize_201204091826_1452110220.txt
[*]hive>showdatabases;
[*]OK
[*]default
[*]Timetaken:1.786seconds
[*]hive>
这次OK了!
出处http://yaoyinjie.blog.iyunv.com/3189782/830481
页:
[1]