[
https://issues.apache.org/jira/browse/SPARK-42869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
GuangWeiHong updated SPARK-42869:
---------------------------------
Description:
SELECT * FROM ( SELECT *, COUNT(1) OVER itr AS grp_size FROM test WINDOW itr AS
(PARTITION BY model) ) tbl WINDOW itr2 AS (PARTITION BY model )
Window specification itr is not defined in the WINDOW clause.
!image-2023-03-20-18-00-40-578.png|width=560,height=361!
was:
SELECT * FROM ( SELECT *, COUNT(1) OVER itr AS grp_size FROM test WINDOW itr AS
(PARTITION BY model) ) tbl WINDOW itr2 AS (PARTITION BY model )
Window specification itr is not defined in the WINDOW clause.
> can not analyze window exp on sub query
> ---------------------------------------
>
> Key: SPARK-42869
> URL: https://issues.apache.org/jira/browse/SPARK-42869
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.2.1
> Reporter: GuangWeiHong
> Priority: Major
> Attachments: image-2023-03-20-18-00-40-578.png
>
>
>
> SELECT * FROM ( SELECT *, COUNT(1) OVER itr AS grp_size FROM test WINDOW itr
> AS (PARTITION BY model) ) tbl WINDOW itr2 AS (PARTITION BY model )
>
> Window specification itr is not defined in the WINDOW clause.
> !image-2023-03-20-18-00-40-578.png|width=560,height=361!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
