Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ranger Autocomplete Resource Name Feature Not Working for Hive Service

Ranger Autocomplete Resource Name Feature Not Working for Hive Service

Contributor

Hello Team,

We are using HDP-2.5.6. We are not using Kerberos security.

We have configured SSL for Hiveserver2 daemon. We have enabled Ranger plugin for Hive service.

When we click on Test connection in Rangers Hive repository, it gives following error:

---------------------------------------------------------------------------------------


Connection Failed.

Unable to retrieve any files using given parameters, You can still save the repository and start creating policies, but you would not be able to use autocomplete for resource names. Check ranger_admin.log for more info.

org.apache.ranger.plugin.client.HadoopException: Unable to connect to Hive Thrift Server instance.. Unable to connect to Hive Thrift Server instance.. Could not open client transport with JDBC Uri: jdbc:hive2://hmaster.test.com:10001: null. 

-------------------------------------------------------------------------------------

Ranger autocomplete resource name feature is not working.

How to resolve it?

Please suggest.

Thanks,

Bhushan

3 REPLIES 3
Highlighted

Re: Ranger Autocomplete Resource Name Feature Not Working for Hive Service

@Bhushan Kandalkar I think this is due your ranger admin truststore may not be properly configured. You may want to check the following video on how to setup ranger admin ssl:

https://community.hortonworks.com/content/supportkb/187924/video-kb-how-to-co-nfigure-ranger-admin-s...

and as a followup step you should add the hive public certificate to the ranger admin truststore.

HTH

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.

Highlighted

Re: Ranger Autocomplete Resource Name Feature Not Working for Hive Service

Contributor

@Felix Albani,

Our 2-way SSL is working properly. Also, hive public certificate is present in ranger admin truststore.

Attached Ranger Hive Repo screenshot hive-repo.png

Please suggest.

Highlighted

Re: Ranger Autocomplete Resource Name Feature Not Working for Hive Service

Contributor
@Felix Albani

Please suggest.

Don't have an account?
Coming from Hortonworks? Activate your account here