[
https://issues.apache.org/jira/browse/HIVE-25851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17485284#comment-17485284
]
Alessandro Solimando commented on HIVE-25851:
---------------------------------------------
I tried to replace HiveRelMdPredicate with RelMdPredicate but it did not solve.
I did not try with the latest RelMdPredicate though, I have checked few recent
tickets around that, I wanted to list them here but searching for
"RelMdPredicate" in Jira did not find them...
The one I thought would apply here, is one where they suggested to be more
consistent on simplifying predicates:
[https://github.com/apache/hive/pull/2840] this PR attempted at something
similar for HiveRelMdPredicate, it solved some OOM but since RexSimplify has
its limitations, we can anyway reach cases where our predicates are expanding,
although they are redundant, but they cannot be simplified, so we keep
triggering the transitive inference between the LHS and RHS of a join.
I don't know if you have seen other tickets in particular that could help here.
> Replace HiveRelMdPredicate with RelMdPredicate from Calcite
> -----------------------------------------------------------
>
> Key: HIVE-25851
> URL: https://issues.apache.org/jira/browse/HIVE-25851
> Project: Hive
> Issue Type: Improvement
> Components: CBO
> Affects Versions: 4.0.0
> Reporter: Alessandro Solimando
> Priority: Major
>
> `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:
> # ascertain which are the additional features in `HiveRelMdPredicates`, port
> them to Calcite if needed
> # drop `HiveRelMdPredicates` in favour of `RelMdPredicates` in order to
> benefit from all the advances in such class
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
