Member since
10-05-2016
3
Posts
0
Kudos Received
0
Solutions
10-05-2016
05:47 PM
how do I do that?
... View more
10-05-2016
04:27 PM
Full error: org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [admin] does not have [USE] privilege on [null] [ERROR_STATUS]
org.apache.ambari.view.hive.client.HiveInvalidQueryException: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [admin] does not have [USE] privilege on [null] [ERROR_STATUS]
at org.apache.ambari.view.hive.client.Utils.verifySuccess(Utils.java:46)
at org.apache.ambari.view.hive.client.Connection.execute(Connection.java:614)
at org.apache.ambari.view.hive.client.Connection.executeSync(Connection.java:629)
at org.apache.ambari.view.hive.client.DDLDelegator.getDBListCursor(DDLDelegator.java:76)
at org.apache.ambari.view.hive.client.DDLDelegator.getDBList(DDLDelegator.java:65)
[plus more that didn't fit]
Press CTRL + Space to autocomplete
You can execute queries with multiple SQL statements delimited by a semicolon ';'
You can highlight and run a fragment of a query
" style="box-sizing: border-box; display: block; font-stretch: normal; line-height: 1; font-family: FontAwesome; font-size: 20px; text-rendering: auto; -webkit-font-smoothing: antialiased; cursor: pointer; border-bottom: 1px solid rgb(221, 221, 221); padding: 10px;">SQLTEZ
... View more
10-05-2016
04:20 PM
The error I'm getting when I go into Hive is this: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [admin] does not have [USE] privilege on [null] [ERROR_STATUS] I suspect maybe Ranger isn't setup correctly? Is there a way to make sure all of my users I setup in Ambari are given permissions via Ranger?
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Ranger