参考链接： 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:
-
Before you run hive for the first time, run
schematool -initSchema -dbType derby
-
If you already ran hive and then tried to initSchema and it's failing:
mv metastore_db metastore_db.tmp
-
Re run
schematool -initSchema -dbType derby
-
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;