Athena API vs JDBC Driver

0

Hi,

We are planning to use Athena in our team. We noticed there are two ways to query data using Athena (API vs JDBC). We are looking differences in terms of performance and salability. Does using JDBC driver is more performant than API since potentially Driver can cache some of the metadata and figure out security during the connection creation instead of running as part of every single query?

What is AWS recommendation?

Dileep
asked 4 years ago123 views
2 Answers
0

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

answered 4 years ago
0

Thanks for the info.

Dileep
answered 4 years ago

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