[
https://issues.apache.org/jira/browse/SPARK-42869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
GuangWeiHong updated SPARK-42869:
---------------------------------
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.
!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.
!image-2023-03-20-18-00-40-578.png|width=560,height=361!
> 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
>
>
>
> 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.
> !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
