[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...........]
- 新しい順
- 投票が多い順
- コメントが多い順
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
Alternatively, you can turn off streaming by adding a JDBC connection property: UseResultsetStreaming=0
oh wow, think you should share how to resolve this error, like "how to open port 444" ...