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

CTAS with analytic results in Illegal reference to non-materialized slot

    XMLWordPrintableJSON

    Details

      Description

      [localhost:21000] > create table testtbl as select
                        > first_value(l_orderkey) over (order by l_orderkey rows between current
                        > row and current row),
                        > first_value(l_partkey) over (order by l_orderkey rows between current
                        > row and current row)
                        > from tpch_parquet.lineitem
                        > ;
      Query: create table testtbl as select
      first_value(l_orderkey) over (order by l_orderkey rows between current
      row and current row),
      first_value(l_partkey) over (order by l_orderkey rows between current
      row and current row)
      from tpch_parquet.lineitem
      ERROR: IllegalStateException: Illegal reference to non-materialized slot: tid=0 sid=1
      

        Attachments

          Activity

            People

            • Assignee:
              alex.behm Alexander Behm
              Reporter:
              mjacobs Matthew Jacobs
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: