You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Jia Fan (Jira)" <ji...@apache.org> on 2023/04/17 11:10:00 UTC
[jira] [Commented] (SPARK-42869) can not analyze window exp on sub query
[ https://issues.apache.org/jira/browse/SPARK-42869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713029#comment-17713029 ]
Jia Fan commented on SPARK-42869:
---------------------------------
Can you try with master branch? I tested without any problem. Maybe already fixed.
!image-2023-04-17-19-06-28-069.png|width=678,height=472!
!image-2023-04-17-19-09-41-485.png|width=673,height=435!
> 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, image-2023-04-17-19-06-28-069.png, image-2023-04-17-19-06-54-728.png, image-2023-04-17-19-09-41-485.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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org