[
https://issues.apache.org/jira/browse/CALCITE-5365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17628466#comment-17628466
]
Julian Hyde commented on CALCITE-5365:
--------------------------------------
Well, you did ask for all expressions! :)
But seriously, there should be some way to call
{{RelMetadataQuery.getAllPredicates()}} and
{{RelMdExpressionLineage.createAllPossibleExpressions()}} without blowing
memory. I propose adding overloads of these methods with something like a 'int
limit' parameter (and that parameter will reduce as we make recursive calls).
Similar to the {{int maxCnfNodeCount}} parameter added to {{toCnf}} in
CALCITE-1290.
> RelMdExpressionLineage#createAllPossibleExpressions will create many RexCall
> lead to OOM
> ------------------------------------------------------------------------------------------
>
> Key: CALCITE-5365
> URL: https://issues.apache.org/jira/browse/CALCITE-5365
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.30.0
> Reporter: hqbhoho
> Priority: Blocker
>
> Execute query like:
> {code:java}
> select
> *
> from
> (
> select *
> from
> (
> select * from A1
> )
> union all
> (
> select * from A2
> )
> union all
> (
> select * from A3
> )
> ) t1
> left join
> (
> select *
> from
> (
> select * from B1
> )
> union all
> (
> select * from B2
> )
> union all
> (
> select * from B3
> )
> )t2
> on t1.a1 = t2.b1
> and t1.a2 = t2.b2
> and t1.a3 = t2.b3
> and t1.a4 = t2.b4
> and t1.a5 = t2.b5
> and t1.a6 = t2.b6
> and t1.a7 = t2.b7
> left join C1 name
> on t2.b8=name.c1 {code}
> I will get all Predicates via RelMetadataQuery.getAllPredicates()，but will
> occur oom.
> RelMdExpressionLineage#createAllPossibleExpressions will retrun 3^14 RexCall
> when t1 join t2 with 7 condition? (t1.a1 will have 3 replacement)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
