Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

In Sandbox, HDP 2.5, getting a Hive Cli error

Super Guru

FAILED: RuntimeException /etc/hive/

I tried a few different users (root, hdfs, hive)

[hive@sandbox conf]$ hive cli
WARNING: Use "yarn jar" to launch YARN applications.
Logging initialized using configuration in file:/etc/hive/
hive> show functions;
FAILED: RuntimeException /etc/hive/ (No such file or directory)
hive> show tables;
Exception in thread "main" java.lang.AssertionError: Authorization plugins not initialized!
at org.apache.hadoop.hive.ql.session.SessionState.getAuthorizationMode(
at org.apache.hadoop.hive.ql.session.SessionState.isAuthorizationModeV2(
at org.apache.hadoop.hive.ql.Driver.doAuthorization(
at org.apache.hadoop.hive.ql.Driver.compile(
at org.apache.hadoop.hive.ql.Driver.compile(
at org.apache.hadoop.hive.ql.Driver.compileInternal(
at org.apache.hadoop.hive.ql.Driver.runInternal(
at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(
at org.apache.hadoop.hive.cli.CliDriver.processCmd(
at org.apache.hadoop.hive.cli.CliDriver.processLine(
at org.apache.hadoop.hive.cli.CliDriver.executeDriver(
at org.apache.hadoop.hive.cli.CliDriver.main(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.apache.hadoop.util.RunJar.main(
[hive@sandbox conf]$

@Timothy Spann

Try setting in hive-site and

You can search on ambari Hive for those configurations and test after changing them.

View solution in original post



A quick workaround is to disable ranger authorization from hive->authorization in ambari UI and restart hive. However, if ranger is part of your tests and want to keep it enabled, this is not the solution.

@Timothy Spann

Try setting in hive-site and

You can search on ambari Hive for those configurations and test after changing them.

Rising Star

@Timothy Spann the above instructions by @Felix Albani should work. In Ambari it looks like so within the Hive configuration.


@Timothy Spann do you see this issue with beeline as well?

Super Collaborator

Hi @Timothy Spann, there is a bug from Ambari perspective, it is not generating hiveserver2-site.xml. So any changes made in Advanced Hiveserver2 site section from Ambari are not getting reflected, (we make changes in hiveserver2-site.xml for Ranger) so if you disable authorization from the general settings as mentioned above, you will be able to run Hive cli but Ranger policies will not work as expected. This issue has been raised up and will be resolved soon in the upcoming releases of Sandbox.

For now, you can use Hive but without any Ranger policies.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.