JingDas

[CALCITE-5756] Expand ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog

16

This feature is mainly about expanding ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog. The main steps are as follows: 1. Analyse the column used...

[CALCITE-5881] Support to get foreign keys metadata in RelMetadataQuery

9

We can get constraints by RelOptTable#getReferentialConstraints method, but maybe can't get appropriate constraints at top relNode. Foreign keys metadata is very useful in many optimize scenes. Such as it can...

[CALCITE-5894] Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent on other sort fields

6

Sorting is an expensive operation, however. Therefore, it is imperative that sorting is optimized to avoid unnecessary sort field. Add SortRemoveRedundantRule, it removes redundant sort fields if they are functionally...