We are using pyathenajdbc module due to Python. As the module name indicates, behinde the scene it is using jdbc driver provided by aws to query Athena. After compararision of pyathena (REST API based) module and pyathenajdbc (JDBC based), we found that JDBC driver based access is faster. Also, if you are using Java then JDBC based access should be fastest.
Another point, if you are using Python, then boto3 based access is even faster compared to JDBC driver, however you will have to write boilerplate code for having JDBC kind of interface.
Edited by: psl-shareinsights on May 2, 2019 5:18 AM
Thanks for the info.
Extremely slow queries on Lakeformation governed tables via Athenaasked a month ago
Connecting to Athena using JDBC driver from a Spring Java applicationasked 2 years ago
Athena ODBC - Multiple Catalogsasked 7 months ago
Accessing Amazon Athena over JDBC with an IAM roleAccepted Answerasked 2 years ago
Connecting Users to AWS Athena and AWS Lake Formation via Tableau Desktop using the Simba Athena JDBC Driver and Okta as Identity Providerasked 5 months ago
Odd Athena Query Performance Issueasked 7 months ago
PowerBI access to S3/AthenaAccepted Answerasked 4 years ago
S3 Select vs AthenaAccepted Answerasked 2 years ago
When querying athena using aws sdk, is it necessary to save results in s3?Accepted Answerasked 5 months ago
Athena API vs JDBC Driverasked 4 years ago