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

[#1]

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)

[#2 · Accepted solution]

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.

[#3]

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

[#4]

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)

[#5]

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.

[#6]

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.

[#7]

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.

[#8]

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