Athena JDBC driver error
1 Nov 2018
Using SQL workbench to connect to AWS Athena resulted in the error mentioned below. It looks like the URL structure might have changed.
The default JDBC driver (Simba) recommended at AWS https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html gave issues.
[Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): AwsRegion, S3OutputLocation; [Simba][JDBC](11480) Optional Connection Key(s): AwsCredentialsProviderArguments, AwsCredentialsProviderClass, BinaryColumnLength, ComplexTypeColumnLength, ConnectTimeout, MaxCatalogNameLength, MaxColumnNameLength, MaxErrorRetry, MaxSchemaNameLength, MaxTableNameLength, ProxyHost, ProxyPort, ProxyPWD, ProxyUID, S3OutputEncOption, Schema, SocketTimeout, StringColumnLength, UseAwsLogger
Example connection details.
URL : jdbc:awsathena://athena.us-east-1.amazonaws.com:443?max_error_retries=20&connection_timeout=20000
Extended properties:
s3_staging_dir : s3_staging_dir : s3://aws-athena-query-results-<account-id>-us-east-1/rchamart