Athena Query: Encountered INTERNAL_ERROR_QUERY_ENGINE Error

0

Hi,

I am creating a table by UNION ALL 6 views with same schema. However, I am getting INTERNAL_ERROR_QUERY_ENGINE when executing the query. I tried to run just the SELECT parts without the CREATE TABLE AS statement but receiving the same error code.

Without UNION ALL I was able to query each table separately, but once I wanted to union them, the error showed up.

The full error message is:

[ErrorCode: INTERNAL_ERROR_QUERY_ENGINE] Amazon Athena experienced an internal error while executing this query. Please contact AWS support for further assistance. You will not be charged for this query. We apologize for the inconvenience.
This query ran against the "<db_name>" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: b8953978-21e8-465f-b0af-857a656a4858

What could be the cause of this error, and how can I fix it? Thanks.

質問済み 2ヶ月前89ビュー
1回答
1

Please review the considerations regarding Athena query complexity. The same type of problem was answered here and was accepted: https://repost.aws/questions/QUGT6bO34ZRGKIV03TynLpPg/consistently-getting-errorcode-internal-error-query-engine-after-adding-a-new-union-to-a-view

profile pictureAWS
エキスパート
回答済み 2ヶ月前
profile picture
エキスパート
レビュー済み 2ヶ月前
profile picture
エキスパート
レビュー済み 2ヶ月前

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

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

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

関連するコンテンツ