hive错误解决

参考链接：   http://www.yiibai.com/hive/hive_installation.html

安装完hadoop之后按照链接中的步骤安装hive和derby

然后现在hive的bin目录下执行 mv metastore_db metastore_db.tmp 然后执行schematool -initSchema -dbType derby

然后执行./hive即可

错误解决方法：

Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000) org.apache.hadoop.hive.metastore.HiveMetaException: Schema initialization FAILED! Metastore state would be inconsistent !! * schemaTool failed *

解决方法：

Soooooo the answer is:

1. Before you run hive for the first time, run

   schematool -initSchema -dbType derby

2. If you already ran hive and then tried to initSchema and it's failing:

   mv metastore_db metastore_db.tmp

3. Re run

   schematool -initSchema -dbType derby

4. Run hive again

错误信息：

Caused by: java.io.IOException: Failed on local exception: java.io.IOException: javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]; Host Details : local host is: "localhost/127.0.0.1"; destination host is: "lg-hadoop-control01.bj":11200;