question Re: Hive user unable to access or connect Hiveserver2 in Archives of Support Questions (Read Only)

Hive user unable to access or connect Hiveserver2

skonduru — Tue, 17 Nov 2015 11:30:01 GMT

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

Re: Hive user unable to access or connect Hiveserver2

nsabharwal — Tue, 17 Nov 2015 11:31:31 GMT

@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)

Re: Hive user unable to access or connect Hiveserver2

skonduru — Tue, 17 Nov 2015 11:48:14 GMT

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