Athena query fails with GENERIC_INTERNAL_ERROR: Missing variable:

Question

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

Accepted Answer

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>

Relevanter Inhalt