Hi community, I have submited two prs with CALCITE-5971 and CALCITE-5994.
In CALCITE-5971,I have added a rule to rewrite the bernoulli sample as Filter,the logic is same as trino/presto’s ImplementBernoulliSampleAsFilter rule. In CALCITE-5994,I have added a rule to remove the redundant order by when its source row number is less than or equal 1,the logic is same as trino/presto’s RemoveRedundantSort rule. I also plan to add more optimization logic to this rule in the future. If someone has time,please help me to review this PR,I would appreciate it very much. 1. CALCITE-5971, link: https://issues.apache.org/jira/browse/CALCITE-5971,The PR link: https://github.com/apache/calcite/pull/3410 2. CALCITE-5994, link:https://issues.apache.org/jira/browse/CALCITE-5994,The PR link:https://github.com/apache/calcite/pull/3418 Best, LakeShen