topic Re: Connecting to Impala through JDBC in Talend Studio

Connecting to Impala through JDBC

_AnonymousUser — Sat, 16 Nov 2024 09:56:16 GMT

Talend data fabric 6.3 enterprise
Impala - Cloudera Hadoop 5.7 with Kerberos
When trying to connect with tImpalaConnection I get:
"Exception in component tImpalaConnection java.lang.IllegalArgumentException: Unrecognized Hadoop major version number: 0.20.205.0"
When trying to create a connection through meta data I get "Connection failure. You must change the Database Settings.
java.sql.SQLException: java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: Can't get Kerberos realm"
When working through the shell with impala shell using kinit and a key tab it works.
I wanted to install a different JDBC driver, but couldnt find a suitable guide for that.
Any ideas?

Re: Connecting to Impala through JDBC

Anonymous — Wed, 05 Apr 2017 09:38:21 GMT

Hi,
Are you using two different realm in kerberos client?
Best regards
Sabrina

Re: Connecting to Impala through JDBC

_AnonymousUser — Wed, 05 Apr 2017 11:17:37 GMT

Only one realm.
We have an all-in-one cloudera server+AD/DC server+windows workstation with Talend. Trying to connect from the workstation.

Re: Connecting to Impala through JDBC

Anonymous — Thu, 06 Apr 2017 10:48:42 GMT

Hello,
Could you please report a ticket on talend support portal for your Talend data fabric 6.3 product? In this way, we can give you a remote assistance(webex)on this connection issue to see if it is a bug through support cycle with priority.
Best regards
Sabrina