hive 不同用户 权限设置 出错处理
今天安装了hive
在a账号安装的,一切正常
但是到其他账户下,报错
>show tables;
Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
以为是权限问题
查看log
Nested Throwables StackTrace:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
后来的解决方案:一个老外的方案:
|
I had the same issue and resolved it by the following way. The issue is because of two possible reasons.
Be warned that this will give permissions to all users. Tweak r-w-x bits accordingly though.
|