Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

Solved Go to solution

HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

installed HDP 2.5 TP, keep getting this error for Hive:

FAILED: SemanticException java.lang.RuntimeException: java.io.FileNotFoundException: /etc/hive/2.5.0.0-817/0/xasecure-audit.xml (No such file or directory)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

Rising Star

The issue is related to the fact that Ranger is used for the authorization. You just need to go on Hive config tab in Ambari, select None as Authorization in the Security section and restart Hive.

7 REPLIES 7
Highlighted

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

Rising Star

The issue is related to the fact that Ranger is used for the authorization. You just need to go on Hive config tab in Ambari, select None as Authorization in the Security section and restart Hive.

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

Changing "choose authorization" to NONE fixed the problem. 2016-08-23-09-34-47.png

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

That still didn't solve the issue. I set 'Enable Authorization' to false and I still get the same error message:

FAILED: RuntimeException java.io.FileNotFoundException: /etc/hive/2.5.0.0-817/0/xasecure-audit.xml (No such file or directory)

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

Rising Star

Because you've not done what I told you. You have to go in the config tab in Ambari, in the Settings tab (not Advanced) and change "Choose authorization" to "None" (instead of Ranger) in the Security area.

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

I'm saying that I did what you recommended. I want into Ambari and changed the property for Enable Authorization to both 'false' and 'none' . tried both. still does not fix the issue.

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

Rising Star

You're saying that you're changing "Enable authorization". I'm saying that you have to change "Choose authorization". They are different things. "Enable authorization" is in the Advanced tab, "Choose authorization" is in the Settings tab.

Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory)

New Contributor

How does one fix this issue when one WANTS TO have ranger running?

Don't have an account?
Coming from Hortonworks? Activate your account here