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
asked 8 months ago244 views
1 Answer
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

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions