When I try inserting results to a table from the query below with the OVER clause, I get the following error:
"IllegalStateException: Illegal reference to non-materialized tuple: tid=3"
Running the select alone works fine. Tried using a subquery instead of CTE and also aliased everything but did not help. Tables are not partitioned but are in the Parquet format.
I have attached screenshots from Hue where the schema is visible as well. Not sure if this is a bug or only an error message that I cannot figure out. It looked strange enough to raise here; sorry if not relevant.
Thank you for this great product and your work.