[jira] [Created] (CALCITE-3957) AggregateMergeRule should be able to merge SUM0 into COUNT even with empty group by

2020-04-24 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-3957: -- Summary: AggregateMergeRule should be able to merge SUM0 into COUNT even with empty group by Key: CALCITE-3957 URL: https://issues.apache.org/jira/browse/CALCITE-3957

Re: [DISCUSS] Deprecate grouped window functions

2020-04-24 Thread Rui Wang
Hi Timo, My intention is to fully drop concepts such as SqlGroupedWindowFunction and auxiliary group functions, which include relevant code in parser/syntax, operator, planner, etc. Since you mentioned the need for more time to migrate. How many Calcite releases that you think can probably leave

[jira] [Created] (CALCITE-3956) Unify comparison logic for RelOptCost

2020-04-24 Thread Liya Fan (Jira)
Liya Fan created CALCITE-3956: - Summary: Unify comparison logic for RelOptCost Key: CALCITE-3956 URL: https://issues.apache.org/jira/browse/CALCITE-3956 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-3955) Remove the first operand of RexCall from SqlWindowTableFunction

2020-04-24 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3955: --- Summary: Remove the first operand of RexCall from SqlWindowTableFunction Key: CALCITE-3955 URL: https://issues.apache.org/jira/browse/CALCITE-3955 Project: Calcite

Re: [DISCUSS] Deprecate grouped window functions

2020-04-24 Thread Timo Walther
Hi everyone, so far Apache Flink depends on this feature. We are fine with improving the SQL compliance and eventually dropping GROUP BY TUMBLE/HOP/SESSION in the future. However, we would like to give our users some time to migrate their existing pipelines. What does dropping mean for

Re: [DISCUSS] Deprecate grouped window functions

2020-04-24 Thread Julian Hyde
+1 Let’s remove TUMBLE etc from the GROUP BY clause. Since this is a SQL change, not an API change, I don’t we need to give notice. Let’s just do it. Julian > On Apr 22, 2020, at 4:05 PM, Rui Wang wrote: > > Made a mistake on the example above, and update it as follows: > > // Table