Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1400

Window function insert issue (LAG() + OVER)

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: Impala 2.0
    • Fix Version/s: Impala 2.0.1
    • Component/s: None
    • Environment:
      CDH 5.2 on Ubuntu 12.04 LTS

      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

        Attachments

        1. insert_fails.png
          119 kB
          Steven
        2. insert_noLAG_works.png
          115 kB
          Steven
        3. select_works.png
          154 kB
          Steven

          Activity

            People

            • Assignee:
              dtsirogiannis Dimitris Tsirogiannis
              Reporter:
              steve77_impala_542a Steven
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: