ranger 连接 hive报错问题解决

在安装好ranger-1.2.0-hive-plugin插件之后 在rangerui界面报错

org.apache.ranger.plugin.client.HadoopException: Unable to execute SQL [show databases like "*"]..
Unable to execute SQL [show databases like "*"]..
Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [root] does not have [USE] privilege on [*].
Permission denied: user [root] does not have [USE] privilege on [*].

 

同时我们在后台用beeline -u jdbc:hive2://localhost:10000连接也会报同样的错 

Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [anonymous] does not have [USE] privilege on [*] (state=42000,code=40000)