question Re: HDP 2.5 TP issue running Hive query - xasecure-audit.xml (No such file or directory) in Archives of Support Questions (Read Only)

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

bmathew — Sun, 03 Jul 2016 23:35:48 GMT

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)

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

mgaido — Mon, 04 Jul 2016 15:13:22 GMT

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)

bmathew — Tue, 05 Jul 2016 04:19:24 GMT

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)

mgaido — Tue, 05 Jul 2016 14:03:53 GMT

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)

bmathew — Wed, 06 Jul 2016 01:41:37 GMT

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)

mgaido — Thu, 07 Jul 2016 16:56:42 GMT

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)

SQLShaw — Tue, 23 Aug 2016 21:33:53 GMT

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)

Ozzmaster — Thu, 01 Nov 2018 14:35:38 GMT

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