Connection getting hung when using Simba JDBC to connect to Athena

0

Hello

I have been trying to setup a jdbc connection to Amazon Athena but my connection gets hung. Below is the line at which connection just hangs

Sep 06 23:34:24.281 TRACE 291 com.simba.athena.athena.api.AJClient.AJClient(): +++++ enter +++++

Sep 06 23:34:24.281 TRACE 291 com.simba.athena.athena.utilities.AJUtilities.createAwsCredentialsProvider(): +++++ enter +++++

Sep 06 23:34:24.281 TRACE 291 com.simba.athena.athena.utilities.AJUtilities.createAwsStaticCredentialsProvider(): +++++ enter +++++

Sep 06 23:34:24.281 DEBUG 291 com.simba.athena.athena.api.AJClient.AJClient: Building Athena client with endpoint = 'https://athena.us-east-1.amazonaws.com:443' and region = 'us-east-1'.

Sep 06 23:34:24.289 TRACE 291 com.simba.athena.athena.api.AJClient.buildGlueClient(): +++++ enter +++++

Sep 06 23:34:24.290 DEBUG 291 com.simba.athena.athena.api.AJClient.buildGlueClient: Building Glue client with region = 'us-east-1'.

Sep 06 23:34:24.296 DEBUG 291 com.simba.athena.athena.api.AJClient.AJClient: Building Athena Streaming client with endpoint = 'https://athena.us-east-1.amazonaws.com:444' and region = 'us-east-1'.

Sep 06 23:34:24.302 TRACE 291 com.simba.athena.athena.api.AJClient.checkGlueSupport(): +++++ enter +++++

Sep 06 23:34:24.302 DEBUG 291 com.simba.athena.athena.api.AJClient.checkGlueSupport: Performing AWS Glue availability detection.

Sep 06 23:34:24.302 DEBUG 291 com.simba.athena.athena.api.AJClient.checkGlueSupport: Aws::Glue - GlueClient - getCatalogImportStatus +++++ enter +++++

Sep 06 23:34:24.302 DEBUG 291 com.simba.athena.athena.api.AJClient.checkGlueSupport: Build a test AWS Glue Client with the retry policy.

Sep 06 23:34:24.302 TRACE 291 com.simba.athena.athena.api.AJClient.buildGlueClient(): +++++ enter +++++

Sep 06 23:34:24.303 DEBUG 291 com.simba.athena.athena.api.AJClient.buildGlueClient: Building Glue client with region = 'us-east-1'.

Connection URL - jdbc:awsathena://AwsRegion=us-east-1;

I also tried below URL jdbc:awsathena://athena.us-east-1.amazonaws.com:443

I am using IAM user to connect using Account Key and Secret Key

Neo
已提问 8 个月前259 查看次数
1 回答
0
  • thanks for responding and yes I have opened the ports on my security groups as well as added the correct policy for the user I am using to access the Athena. I am still not able to connect

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则