hive 常见错误

错误1

java.sql.SQLException: org.apache.thrift.transport.TTransportException: SASL authentication not complete

查询完要关闭Statement 连接，  stmt.close();

错误2

Permission denied: user=anonymous, access=EXECUTE, inode=”/tmp”

由于Hive没有hdfs:/tmp目录的权限，赋权限即可：

hadoop dfs -chmod -R 777 /tmp