Reply
New Contributor
Posts: 1
Registered: ‎01-16-2017

Impala JDBS connection using username and password

[ Edited ]

Hi,

 

I'm trying to connect to Impala using specific username (which is available on host running Impala) and password.

 

I can connect using below connection string (as you see it uses Kerberos)

jdbc:impala://serverXXX.intranet.domain.com:21050;AuthMech=1;KrbRealm=INTRANET.DOMAIN.COM;KrbServiceName=impala;KrbHostFQDN=serverXXX.intranet.domain.com;

 

But when I'm trying to use LDAP

jdbc:impala://serverXXX.intranet.domain.com:21050;AuthMech=3;UID=<user>;PWD=<pass>;

it says

Error initialized or created transport for authentication: Peer indicated failure: Unsupported mechanism type PLAIN.

 

I've already checked topic

https://community.cloudera.com/t5/Cloudera-Manager-Installation/Impala-JDBC-with-username-amp-passwo...

but still cannot figure out how to connect.

 

Why I want to specify particular user/passwod - because only very limited subset of Impala databases are available to my domain user (which is used with Kerberos).

 

Everything works fine if I specify LPAD method and user/pass in HUE but I need to set up JDBC connection.

 

Thanks