Hive user unable to access or connect Hiveserver2

[#1]

As Hive user beeline unable to connect Hiveserver2, receiving ranger permissions error.

Unable to disable Hive ranger plugin security to none. Ambari failing to save new status with following error:

16 Nov 2015 15:20:52,270 INFO [qtp-client-223] StackAdvisorRunner:71 - advisor script stderr: 16 Nov 2015 15:22:42,245 INFO [qtp-client-232] PersistKeyValueService:82 - Looking for keyName user-pref-admin-dashboard

[#2 · Accepted solution]

@skonduru Make sure that hive user is added into Ranger under Hive policies.

Also, I have noticed that sometimes save option is disabled after changing the Authroization. In that case , click service actions --> restart all ( otherwise Ambari will give only discard option)

[#3]

Thank you Neeraj, As suggested restarted all hive services, added hive user along with ambari-qa and test was successful.