Hi After creating quite complex view based on "UNION ALL" of 4 complex selects I've ended up with a curious situation: 1. The view itself is queried OK with simple queries like `select * from where ` 2. Once I wrap it into bigger select like `select count(*) from (select * from where )` I get the following strange error: `GENERIC_INTERNAL_ERROR: Missing variable: ` where `` is absolutely live and valid column that could be queried and returned as usual The issue is repeatable - once I recreate the same set of views on another Database and same data - issue repeats However it's barely searched on the web - looks like nobody faced such errors

Update on the topic: I had the hypothesis that the resulting query is too long (after unwrapping all the selects from underlying views) So I changed the `` to Create Table As Select and looks like it fixed my problem, however I'm not sure that exactly this helped

Athena query fails with GENERIC_INTERNAL_ERROR: Missing variable: <column_name>

Hi
After creating quite complex view based on "UNION ALL" of 4 complex selects I've ended up with a curious situation:

The view itself is queried OK with simple queries like select * from <view_name> where <conditions>
Once I wrap it into bigger select like select count(*) from (select * from <view_name> where <conditions>) I get the following strange error:
GENERIC_INTERNAL_ERROR: Missing variable: <column_name> where <column_name> is absolutely live and valid column that could be queried and returned as usual

The issue is repeatable - once I recreate the same set of views on another Database and same data - issue repeats

However it's barely searched on the web - looks like nobody faced such errors

トピック

分析

タグ

Amazon Athena

言語

English

Sergey N

質問済み 2年前636ビュー

1回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

承認された回答

Update on the topic: I had the hypothesis that the resulting query is too long (after unwrapping all the selects from underlying views)
So I changed the <view_name> to Create Table As Select and looks like it fixed my problem, however I'm not sure that exactly this helped

Sergey N

回答済み 2年前

Athena query fails with GENERIC_INTERNAL_ERROR: Missing variable: <column_name>

関連するコンテンツ