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

주제

분석

태그

아마존 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>

관련 콘텐츠