The problem of error reporting in Ranger connection hive is solved

After installing the ranger-1.2.0-hive-plugin plugin, the error is reported in the rangerui interface
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 [*].

Also we will get the same error when we connect with beeline -u jdbc:hive2://localhost:10000 in the backend
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [anonymous] does not have [USE] privilege on [*] (state=42000,code=40000)


Read More: