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
질문됨 5년 전769회 조회
2개 답변
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

답변함 5년 전
0

Thanks for the info.

Dileep
답변함 5년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인