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

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

            Dates

              Created:
              Updated:
              Resolved: