[SPARK-42869] can not analyze window exp on sub query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.2.1
• Component/s: SQL
• Assignee: Unassigned
• Reporter: GuangWeiHong
• Created: 20/Mar/23 09:59
• Updated: 19/Apr/23 08:56

Description

 

CREATE TABLE test_noindex_table(`name` STRING,`age` INT,`city` STRING) PARTITIONED BY (`date` STRING);

 

SELECT
    *
FROM
(
    SELECT *, COUNT(1) OVER itr AS grp_size
    FROM test_noindex_table 
    WINDOW itr AS (PARTITION BY city)
) tbl
WINDOW itr2 AS (PARTITION BY
    city
)
 
Window specification itr is not defined in the WINDOW clause.