3
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

Amazon Athena「No output location provided」エラーの対処法

Posted at

#エラー発生
Athenaでパーティション設定時に下記のエラーが発生した。

Your query has the following error(s):

No output location provided. An output location is required either through the Workgroup result configuration setting or as an API input. (Service: AmazonAthena; Status Code: 400; Error Code: InvalidRequestException; Request ID: XXXXXXXXXXXXXXXXXXX)

スクリーンショット 2021-05-08 16.24.12.png

#解決方法
クラスメソッドのAthena でクエリ実行時に”No output location provided ……”というエラーが表示された時の対処方法の記事によると、クエリ結果の出力場所を指定する必要があるということ。

おそらく記事作成時とUIが変わり、現在のUIでは「Settings」から設定が可能。
スクリーンショット 2021-05-08 16.36.23.png
S3パスがわからなくても、「Select」から選択が可能。
スクリーンショット 2021-05-08 16.39.25.png

3
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
3
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?