[jira] [Updated] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is null

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6440: Summary: Add optimization to remove sortkey when The Order By parameter in the Sort operator is

[jira] [Commented] (CALCITE-6442) Validator rejects FILTER in OVER windows

[ https://issues.apache.org/jira/browse/CALCITE-6442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856099#comment-17856099 ] Julian Hyde commented on CALCITE-6442: -- Can you see who added it to the grammar, and as part of

[jira] [Commented] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856089#comment-17856089 ] Julian Hyde commented on CALCITE-6440: -- [~caicancai], No, the rule should not do what you suggest.

[jira] [Comment Edited] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856087#comment-17856087 ] Caican Cai edited comment on CALCITE-6440 at 6/19/24 12:42 AM: --- [~mbudiu]

[jira] [Comment Edited] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856087#comment-17856087 ] Caican Cai edited comment on CALCITE-6440 at 6/19/24 12:42 AM: --- [~mbudiu]

[jira] [Commented] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856087#comment-17856087 ] Caican Cai commented on CALCITE-6440: - [~mbudiu] I re-edited the jira description, it looks like I

[jira] [Updated] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6440: Summary: Add optimization to remove sortkey when The Order By parameter in the Sort operator is

[jira] [Created] (CALCITE-6442) Validator rejects FILTER in OVER windows

Mihai Budiu created CALCITE-6442: Summary: Validator rejects FILTER in OVER windows Key: CALCITE-6442 URL: https://issues.apache.org/jira/browse/CALCITE-6442 Project: Calcite Issue Type: Bug

[jira] [Reopened] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan reopened CALCITE-6440: - Looks the SortRemoveConstantKeysRule can't remove the sort key when the sort key is NULL. > Add

[jira] [Commented] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856071#comment-17856071 ] xiong duan commented on CALCITE-6440: - +1 reopen this Jira case. > Add optimization to returns

[jira] [Resolved] (CALCITE-6008) ARRAY_AGG should returns ARRAY NULL when there's no input rows

[ https://issues.apache.org/jira/browse/CALCITE-6008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6008. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-5855) Implement frame exclusion in window functions

[ https://issues.apache.org/jira/browse/CALCITE-5855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-5855. -- Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855987#comment-17855987 ] Caican Cai edited comment on CALCITE-6440 at 6/18/24 4:14 PM: -- The rule

[jira] [Commented] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855987#comment-17855987 ] Caican Cai commented on CALCITE-6440: - The rule before SortRemoveConstantKeys optimization is

[jira] [Assigned] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan reassigned CALCITE-5634: -- Assignee: Norman Jordan > Enable GREATEST, LEAST functions in PostgreSQL library >

[jira] [Commented] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855971#comment-17855971 ] Caican Cai commented on CALCITE-6439: - It seems that calcite treats null as a Boolean value,

[jira] [Closed] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6439. --- Resolution: Not A Problem > FILTER_INSTANCE in RelOptRule does not take effect >

[jira] [Commented] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855966#comment-17855966 ] Caican Cai commented on CALCITE-6439: - ok, i will test it > FILTER_INSTANCE in RelOptRule does not

[jira] [Comment Edited] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

[ https://issues.apache.org/jira/browse/CALCITE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855910#comment-17855910 ] xiong duan edited comment on CALCITE-6431 at 6/18/24 12:07 PM: --- Maybe

[jira] [Commented] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

[ https://issues.apache.org/jira/browse/CALCITE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855910#comment-17855910 ] xiong duan commented on CALCITE-6431: - Maybe Spark or Hive can optimize CASE WHEN: CASE COUNT(*)

[jira] [Commented] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

[ https://issues.apache.org/jira/browse/CALCITE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855907#comment-17855907 ] xiong duan commented on CALCITE-6431: - Spark and Hive will throw exception 'Scalar subquery

[jira] [Commented] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855809#comment-17855809 ] Dmitry Sysolyatin commented on CALCITE-5634: I had planned to finish this task almost a

[jira] [Assigned] (CALCITE-5634) Enable GREATEST, LEAST functions in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Sysolyatin reassigned CALCITE-5634: -- Assignee: (was: Dmitry Sysolyatin) > Enable GREATEST, LEAST functions