[jira] [Assigned] (SPARK-39548) CreateView Command with a window clause query hit a wrong window definition not found issue
[ https://issues.apache.org/jira/browse/SPARK-39548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wenchen Fan reassigned SPARK-39548: --- Assignee: Rui Wang > CreateView Command with a window clause query hit a wrong window definition > not found issue > --- > > Key: SPARK-39548 > URL: https://issues.apache.org/jira/browse/SPARK-39548 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.3.0 >Reporter: Rui Wang >Assignee: Rui Wang >Priority: Major > > This query will hit a w2 window definition not found in `WindowSubstitute` > rule, however this is a bug since the w2 definition is defined in the query. > ``` > create or replace temporary view test_temp_view as > with step_1 as ( > select * , min(a) over w2 as min_a_over_w2 from (select 1 as a, 2 as b, 3 as > c) window w2 as (partition by b order by c)) , step_2 as > ( > select *, max(e) over w1 as max_a_over_w1 > from (select 1 as e, 2 as f, 3 as g) > join step_1 on true > window w1 as (partition by f order by g) > ) > select * > from step_2 > ``` > Also we can move the unresolved window expression check from > `WindowSubstitute` rule to `CheckAnalysis` phrase. -- This message was sent by Atlassian Jira (v8.20.7#820007) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Assigned] (SPARK-39548) CreateView Command with a window clause query hit a wrong window definition not found issue
[ https://issues.apache.org/jira/browse/SPARK-39548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-39548: Assignee: Apache Spark > CreateView Command with a window clause query hit a wrong window definition > not found issue > --- > > Key: SPARK-39548 > URL: https://issues.apache.org/jira/browse/SPARK-39548 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.3.0 >Reporter: Rui Wang >Assignee: Apache Spark >Priority: Major > > This query will hit a w2 window definition not found in `WindowSubstitute` > rule, however this is a bug since the w2 definition is defined in the query. > ``` > create or replace temporary view test_temp_view as > with step_1 as ( > select * , min(a) over w2 as min_a_over_w2 from (select 1 as a, 2 as b, 3 as > c) window w2 as (partition by b order by c)) , step_2 as > ( > select *, max(e) over w1 as max_a_over_w1 > from (select 1 as e, 2 as f, 3 as g) > join step_1 on true > window w1 as (partition by f order by g) > ) > select * > from step_2 > ``` > Also we can move the unresolved window expression check from > `WindowSubstitute` rule to `CheckAnalysis` phrase. -- This message was sent by Atlassian Jira (v8.20.7#820007) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Assigned] (SPARK-39548) CreateView Command with a window clause query hit a wrong window definition not found issue
[ https://issues.apache.org/jira/browse/SPARK-39548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-39548: Assignee: (was: Apache Spark) > CreateView Command with a window clause query hit a wrong window definition > not found issue > --- > > Key: SPARK-39548 > URL: https://issues.apache.org/jira/browse/SPARK-39548 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 3.3.0 >Reporter: Rui Wang >Priority: Major > > This query will hit a w2 window definition not found in `WindowSubstitute` > rule, however this is a bug since the w2 definition is defined in the query. > ``` > create or replace temporary view test_temp_view as > with step_1 as ( > select * , min(a) over w2 as min_a_over_w2 from (select 1 as a, 2 as b, 3 as > c) window w2 as (partition by b order by c)) , step_2 as > ( > select *, max(e) over w1 as max_a_over_w1 > from (select 1 as e, 2 as f, 3 as g) > join step_1 on true > window w1 as (partition by f order by g) > ) > select * > from step_2 > ``` > Also we can move the unresolved window expression check from > `WindowSubstitute` rule to `CheckAnalysis` phrase. -- This message was sent by Atlassian Jira (v8.20.7#820007) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
