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.

Connecting To Hive Securely Through JDBC

Connecting To Hive Securely Through JDBC

Contributor

Hello,

Currently, I am able to login into my server using Squirrel by just providing the jdbc connection string and username

Eg: jdbc:hive2://localhost:10000/default

Username: hive

This way, anybody can connect to Hive.

I want to restrict this and make each user provide their own username along with the password.

Is there a way to achieve this?

I have not setup Kerberos yet but is there anyother way to achieve this without setting up Kerberos?

4 REPLIES 4

Re: Connecting To Hive Securely Through JDBC

Super Collaborator
@Rinku Singh

hive can be configured to authenticate with LDAP/PAM. You need to configure hive authentication as per your environment. Review below doc for more info.

https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-Authent...

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_dataintegration/content/enabling_hs2_for...

Re: Connecting To Hive Securely Through JDBC

Re: Connecting To Hive Securely Through JDBC

Contributor

@Rahul Pathak

All the OS users use a ppk file to login. Is there a way to provide the ppk file either in beeline or squirrel?

Re: Connecting To Hive Securely Through JDBC

@Rinku Singh

I am afraid it will not be possible.

Rahul