What is causing the excessive number of requests to s3?

0

I searched in athena and uploaded the searched content to s3.

I used the select statement about 10 times and uploaded a small query log to s3.

However, looking at the charges charged, there were hundreds of thousands of requests.

It is unknown what caused this number of requests.

Why is there such a large number of requests?

joker
質問済み 2年前618ビュー
2回答
1
承認された回答

Without proper partitioning, Athena will scan large data sets and therefore it could end up costing a lot. It is very important to partition the data correctly - https://docs.aws.amazon.com/athena/latest/ug/partitions.html

profile pictureAWS
エキスパート
回答済み 2年前
0

Yep Indranil is right about the partitioning. For a tutorial and tips about this, also see https://www.linkedin.com/pulse/using-athena-partition-projection-query-cloudtrail-other-kinsman/. It uses AWS logs as examples but the information is generic.

エキスパート
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ