Support Questions
Find answers, ask questions, and share your expertise

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