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

Impala JDBS connection using username and password

[ Edited ]



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)



But when I'm trying to use LDAP


it says

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


I've already checked topic

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.