When I ran a hive query in HDP2.5, it shows:
FAILED: RuntimeException java.io.FileNotFoundException: /etc/hive/2.5.0.0-817/0/xasecure-audit.xml (No such file or directory)
The issue is related to the fact that Ranger is used for the authorization.
The xasecure-audit entails older versions of Ranger.
The problem found at this location was that they did not have correct "ranger admin" password in the RANGER CONFIG tab in Ambari.
Solution:
When the HDFS was restarted, it tries to create a new ranger repository and it fails due to Incorrect "
rangeradmin" password.
rangeradmin" password.
Once the "rangeradmin" password is updated correctly, the HDFS namenode started with Ranger authorizer and was able to audit all activities via Ranger Console.
Or disable Ranger authorization on Hive:
Find Hive config tab in Ambari, select "None" as Authorization in the Security section,
Then, restart Hive.
Reference: