Re: Window functions frame_exclusion

2023-07-16 Thread Julian Hyde
It would be good to have this as a feature. Are you proposing to fully implement the feature (I.e. add to parser, validator, and Enumerable convention, so that we can execute such queries) or just add it to the parser? I think our users might be confused or frustrated if the parser supports the

[jira] [Created] (CALCITE-5854) Test against Go 1.19 and 1.20

2023-07-16 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-5854: --- Summary: Test against Go 1.19 and 1.20 Key: CALCITE-5854 URL: https://issues.apache.org/jira/browse/CALCITE-5854 Project: Calcite Issue Type: New Featu

[jira] [Created] (CALCITE-5853) Use HBase Phoenix images from GitHub container registry

2023-07-16 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-5853: --- Summary: Use HBase Phoenix images from GitHub container registry Key: CALCITE-5853 URL: https://issues.apache.org/jira/browse/CALCITE-5853 Project: Calcite

Re: [VOTE] Release Apache Calcite 1.35.0 (release candidate 0)

2023-07-16 Thread Julian Hyde
I don’t think the short links are an improvement to the vote email. The release notes could be improved. I think CONVERT counts as a new feature. Puffin and PairList do not (they’re utility classes). There are so many new functions this time, how about adding a new section, and sorting them a

Window functions frame_exclusion

2023-07-16 Thread Itiel Sadeh
Hello All, PostgreSQL supports "frame exclusion" in window function, e.g.: "SELECT sum(x) OVER (PARTITION BY y ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING EXCLUDE CURRENT ROW) from t", (you can see here