[HIVE-25851] Replace HiveRelMdPredicate with RelMdPredicate from Calcite

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Component/s: CBO
• Assignee: Alessandro Solimando
• Reporter: Alessandro Solimando
• Created: 07/Jan/22 10:06
• Updated: 11/Feb/22 11:39

Description

`HiveRelMdPredicates` was copied from `RelMdPredicates` in Calcite long ago, it has few differences which could be ported to the Calcite version, if needed.

The goal of the ticket is to:

1. ascertain which are the additional features in `HiveRelMdPredicates`, port them to Calcite if needed
2. drop `HiveRelMdPredicates` in favour of `RelMdPredicates` in order to benefit from all the advances in such class

Issue Links

• relates to: CALCITE-2205 JoinPushTransitivePredicatesRule should not create a Filter on top of an equivalent Filter
• relates to: HIVE-25758 OOM due to recursive application of CBO rules

Sub-Tasks

• Drop HiveRelMdPredicates::getPredicates(Project...) to use that of RelMdPredicates: Open
• Drop HiveRelMdPredicates::getPredicates(Join...) to use that of RelMdPredicates: In Progress
• Align HiveRelMdPredicates getPredicates() for Project with RelMdPredicates: In Progress