[AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Connecting to Amazon Athena Data Source
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]AthenaJDBC 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: connect[Execution ID:nnnnnnnn-nnnn...........]
- Newest
- Most votes
- Most comments
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]AthenaJDBC 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
Relevant content
- asked 3 months ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 3 months ago
oh wow, think you should share how to resolve this error, like "how to open port 444" ...