By using AWS re:Post, you agree to the Terms of Use
/[AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Connecting to Amazon Athena Data Source/

[AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Connecting to Amazon Athena Data Source

0

I received the following issue when connecting to Amazon Athena from the IDE (client desktop). However, I see a query running in the Athena console under the specified workgroup.

Simba(100123) An error has occurred. Exception during column initialization: Details: Unable to execute HTTP request:Connect to Athena us-east-1-amazonaws.com…….. failed: Connection timed out: connectExecution ID:xxxxxxxx-xxxx...........

1 Answers
0
Accepted Answer

The connection between the host where the JDBC/ODBC driver was installed and the Athena endpoints is the cause of this problem. Please ensure that port 444, which Athena uses to stream query results, is open to outbound traffic. When you use a PrivateLink endpoint to connect to Athena, ensure that the security group attached to the PrivateLink endpoint is open to inbound traffic on port 444. If port 444 is blocked, you may receive the error message Simba(100123) An error has occurred. Exception during column initialization.

https://aws.amazon.com/premiumsupport/knowledge-center/athena-connection-timeout-jdbc-odbc-driver/ https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions