hive select FAILED: RuntimeException java.io.FileNotFoundException: /etc/hive/2.4.2.0-258/0/xasecure

[root@rdsp-dn-03 ~]# hive

WARNING: Use "yarn jar" to launch YARN applications.

 

Logging initialized using configuration in file:/etc/hive/2.4.2.0-258/0/hive-log4j.properties

hive> show databases;

FAILED: RuntimeException java.io.FileNotFoundException: /etc/hive/2.4.2.0-258/0/xasecure-audit.xml (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(SessionState.java:1523)

at org.apache.hadoop.hive.ql.session.SessionState.isAuthorizationModeV2(SessionState.java:1527)

at org.apache.hadoop.hive.ql.Driver.doAuthorization(Driver.java:620)

at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:504)

at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316)

at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1189)

at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1237)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1126)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1116)

at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:216)

at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:168)

at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:379)

at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:739)

at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:684)

at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hadoop.util.RunJar.run(RunJar.java:221)

at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

原因：(个人猜测)ranger未配置,却开启了ranger策略

解决办法：在ambari:8080界面找到hive里面的Enable Authorization=true改为false,然后restart hive即可.