Cannot connect to Kerberized Impala server (CDH 5.8) with Talend Studio 6.3.1 metadata DB connection

Talend Version       6.3.1

Summary

 
Additional Versions  
Product Big Data
Component Studio
Problem Description

Using Talend Studio 6.3.1 Repository Metadata Wizard to create an Impala DB Connection against a Kerberized Hadoop Cluster (CDH 5.8)/ Impala Server, with the following steps and properties (given as an example):

  1. Right-click Repository/MetaData/DB Connections.
  2. Click Create Connection.
  3. For Name, use CDH58_impala_connection, then click Next.
  4. For DB type, use Impala.
  5. For Properties, use the following:

    • Distribution = Cloudera
    • Impala version = Cloudera CDH 5.8
    • Login = automation
    • Server = xxx.yyy.zzz
    • Port = 21050
    • DataBase = default
    • Authentication (use Kerberos) / Impala principal = impala/_HOST@CDH.COM
  6. When checking the DB connection to the Impala Daemon Server (by clicking Check), the following exception occurs:

    java.sql.SQLException: Could not establish connection to jdbc:hive2://xxx.yyy.zzz:21050/default;auth=noSasl: null

     

    with this related Java Exception Stack:

    java.sql.SQLException: java.util.concurrent.ExecutionException: java.sql.SQLException: Could not establish connection to jdbc:hive2://xxx.yyy.zzz:21050/default;auth=noSasl: null
          at org.talend.metadata.managment.connection.manager.ImpalaConnectionManager.createConnection(ImpalaConnectionManager.java:107)
          at org.talend.metadata.managment.connection.manager.ImpalaConnectionManager.checkConnection(ImpalaConnectionManager.java:58)
          at org.talend.metadata.managment.repository.ManagerConnection.checkImpalaConnection(ManagerConnection.java:180)
          at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$61.runWithCancel(DatabaseForm.java:3944)
          at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$61.runWithCancel(DatabaseForm.java:1)
          at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
          at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
          at java.util.concurrent.FutureTask.run(Unknown Source)
          at java.lang.Thread.run(Unknown Source)
      Caused by: java.util.concurrent.ExecutionException: java.sql.SQLException: Could not establish connection to jdbc:hive2://xxx.yyy.zzz:21050/default;auth=noSasl: null
          at java.util.concurrent.FutureTask.report(Unknown Source)
          at java.util.concurrent.FutureTask.get(Unknown Source)
          at org.talend.metadata.managment.connection.manager.ImpalaConnectionManager.createConnection(ImpalaConnectionManager.java:101)
          ... 8 more
      Caused by: java.sql.SQLException: Could not establish connection to jdbc:hive2://xxx.yyy.zzz:21050/default;auth=noSasl: null
          at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:499)
          at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:181)
          at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
          at org.talend.metadata.managment.connection.manager.ImpalaConnectionManager$1.call(ImpalaConnectionManager.java:87)
          at org.talend.metadata.managment.connection.manager.ImpalaConnectionManager$1.call(ImpalaConnectionManager.java:1)
          ... 2 more
Problem root cause This issue is due to a bug.
Solution or Workaround

This issue is fixed in Talend 6.3.2, 6.4.1.

Against Talend 6.3.1, the solution consists of applying Patch_20170523_TPS-1899_v1-6.3.1.

    1. Contact Talend Support to request Patch_20170523_TPS-1899_v1-6.3.1.zip.
    2. Once the patch has been assigned to you, download it by logging in to https://talend-update.talend.com using your license credentials.
    3. Use the patch Readme file steps (embedded in the patch zip file) to apply the patch.
JIRA ticket number  
Version history
Revision #:
20 of 20
Last update:
‎02-13-2018 05:02 PM
Updated by:
 
Contributors