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 [*].
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:
- An error is reported when the file in hive parquet format is written in the Flink connection
- “Hive metadata problem” hive.metastore.HiveMetaException : Failed to get schema version.
- Error reporting when importing sqoop from Mysql to hive
- Solve the problem that the connection between ADB and nocturnal God cannot be solved
- Beeline connection hive2 reports an error permission denied
- Java connection zookeeper high availability hive error
- Ranger Solr audit log installation
- Threejs is used in Vue to introduce error reporting problem of orbitcontrols
- Ranger yarn plug-in installation
- The error problem of loading autoware maptool function package by utiny is solved
- pom.xml Depending on the error report, the problem of missing artifact XXX is solved
- Error reporting: attributeerror: module ‘******* has no attribute’ ******* and other problems are solved
- After vivado joined ILA, the [DRC lutlp-1] problem of error problem was solved
- Ant Design ‘cross env’ is not an internal or external command, nor is it an error reporting problem for a runnable program
- R language-Error in file(out, “wt”): Unable to open the link problem solved
- In many cases, the problem of error reporting by label in latex
- How to solve the problem of error reporting in Flink
- Successfully solved the problem of “runtimee” in RESNET dataset classification rror:expected scalar type Long but found Float”
- hive is not allowed to impersonate anonymous
- no target device found problem solved