Search code examples
hiveodbc

'Error while compiling statement: FAILED: HiveAuthzPluginException Unsupported privilege type All'

I'm trying to query Hive over ODBC. I granted all privileges to a user, then got this message:

'Error while compiling statement: FAILED: HiveAuthzPluginException Unsupported privilege type All'

So I went back and granted select to the ODBC user but I still get the same message:

'Error while compiling statement: FAILED: HiveAuthzPluginException Unsupported privilege type All'

what can I do to fix this?

Solution

  • You can get into this issue if you try to grant privileges on Hive Cli. You may need to clean privilege "All" from metastore DB. Here is the nice blog http://www.openkb.info/2015/07/query-fails-with-error.html