Cannot connect to Amazon Athena services using Talend Studio

Problem Description

When connecting to Amazon Athena using a tJDBCConnection component, the connection fails with the following error:

[FATAL]: bi_bbs_imcm_di_arch.jb_test_push_0_1.jb_Test_Push - tJDBCConnection_1 [Simba][JDBC](10100) 
Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): AwsRegion, S3OutputLocation; [Simba][JDBC](11480) Optional
Connection Key(s): AwsCredentialsProviderArguments, AwsCredentialsProviderClass, BinaryColumnLength,
ComplexTypeColumnLength, ConnectTimeout, MaxCatalogNameLength, MaxColumnNameLength, MaxErrorRetry,
MaxSchemaNameLength, MaxTableNameLength, ProxyHost, ProxyPort, ProxyPWD,
ProxyUID, RowsToFetchPerBlock, S3OutputEncOption, Schema, SocketTimeout, StringColumnLength,
UseArraySupport, UseAwsLogger, UseResultsetStreaming java.sql.SQLNonTransientConnectionException: [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640)
Required Connection Key(s): AwsRegion, S3OutputLocation; [Simba][JDBC](11480) Optional Connection Key(s):
AwsCredentialsProviderArguments, AwsCredentialsProviderClass, BinaryColumnLength,
ComplexTypeColumnLength, ConnectTimeout, MaxCatalogNameLength, MaxColumnNameLength,
MaxErrorRetry, MaxSchemaNameLength, MaxTableNameLength, ProxyHost, ProxyPort, ProxyPWD,
ProxyUID, RowsToFetchPerBlock, S3OutputEncOption, Schema, SocketTimeout, StringColumnLength,
UseArraySupport, UseAwsLogger, UseResultsetStreaming at java.sql.DriverManager.getConnection(Unknown Source)

 

Root Cause

The tJDBCConnection component may have missing or older Athena JAR files.

 

Solution

  1. Go to the Using Athena with the JDBC Driver page on the Amazon website.
  2. Download the latest Athena JAR file that is compatible with JDK 1.8 or later.
  3. Point the tJDBCConnection to use this JAR, and you'll be able to connect to Athena(S3).

     

Warnings

Note: the AthenaJDBC42-2.0.5.jar is compatible with JDBC 4.2 and requires JDK 8.0 or later. (Source).

Version history
Revision #:
8 of 8
Last update:
‎04-15-2019 02:56 PM
Updated by: