[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...........]
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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
Relevanter Inhalt
AWS OFFICIALAktualisiert vor 3 Jahren- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
oh wow, think you should share how to resolve this error, like "how to open port 444" ...