[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...........]
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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
Contenus pertinents
- demandé il y a un an
- demandé il y a 2 mois
AWS OFFICIELA mis à jour il y a 2 ans
oh wow, think you should share how to resolve this error, like "how to open port 444" ...