INTERNAL_ERROR_QUERY_ENGINE after upgrade Athen engine to version 3

0

I received INTERNAL_ERROR_QUERY_ENGINE error with existing query after upgrade athena engine to version 3.

The same query works fine with version 2.

The data size scan is 40.37 MB for the query below, and I have 5 TB limit per query.

SELECT DISTINCT source
FROM production_data.events

The weird part is that

  • If I add LIMIT in the query, it works without any error.
  • If I use same select with different table then also works (why only this table?)

I couldn't find any log that explain the reasons why that is the case. Is it possible to get detail log?

Any thought? Thanks

質問済み 1年前325ビュー
1回答
0

Hello,

I understand that query running on Athena engine V3 errors out however with V2 it is successful. Also similar query works on a different table or same table with limited data.

In order to further troubleshoot the issue, please create a support ticket here with query IDs run on Athena Engine V2 and V3.

AWS
回答済み 1年前

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

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

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

関連するコンテンツ