[IMPALA-1400] Window function insert issue (LAG() + OVER)

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.0.1
• Labels: LAG() OVER impala insert
• Environment: CDH 5.2 on Ubuntu 12.04 LTS
• Assignee: Dimitris Tsirogiannis
• Reporter: Steven
• Created: 20/Oct/14 10:44
• Updated: 20/Dec/15 00:05
• Resolved: 22/Oct/14 02:41

Description

Hi,

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.

Steven