Connecting to Impala through JDBC

One Star

Connecting to Impala through JDBC

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?
Moderator

Re: Connecting to Impala through JDBC

Hi,
Are you using two different realm in kerberos client?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Connecting to Impala through JDBC

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

Re: Connecting to Impala through JDBC

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads