Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Ranger Autocomplete Resource Name Feature Not Working for Hive Service

avatar
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

avatar

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

avatar
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.

avatar
Contributor
@Felix Albani

Please suggest.