[
https://issues.apache.org/jira/browse/CALCITE-5304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17611406#comment-17611406
]
Jiajun Xie edited comment on CALCITE-5304 at 9/30/22 7:25 AM:
--------------------------------------------------------------
+1 for this ticket. Here is a relNode that contains RexSubQuery.
{code:java}
LogicalProject("K0"=[$0], "C1"=[$1], "F1"."A0"=[$2], "F2"."A0"=[$3],
"F0"."C0"=[$4], "F1"."C0"=[$5], "F0"."C1"=[$6], "F1"."C2"=[$7], "F2"."C3"=[$8])
LogicalFilter(condition=[=($4, $SCALAR_QUERY({
LogicalAggregate(group=[{}], EXPR$0=[MAX($0)])
LogicalProject("F1"."C0"=[$5])
LogicalFilter(condition=[=($cor0."K0", $0)])
LogicalTableScan(table=[[CATALOG, STRUCT, T]])
}))], variablesSet=[[$cor0]])
LogicalTableScan(table=[[CATALOG, STRUCT, T]])
{code}
ImmutableSet also should be support, now exception message: `type not
serializable: [$cor0] (type com.google.common.collect.SingletonImmutableSet).`
was (Author: jiajunbernoulli):
+1 for this ticket. Here is a relNode that contains RexSubQuery.
{code:java}
LogicalProject("K0"=[$0], "C1"=[$1], "F1"."A0"=[$2], "F2"."A0"=[$3],
"F0"."C0"=[$4], "F1"."C0"=[$5], "F0"."C1"=[$6], "F1"."C2"=[$7], "F2"."C3"=[$8])
LogicalFilter(condition=[=($4, $SCALAR_QUERY({
LogicalAggregate(group=[{}], EXPR$0=[MAX($0)])
LogicalProject("F1"."C0"=[$5])
LogicalFilter(condition=[=($cor0."K0", $0)])
LogicalTableScan(table=[[CATALOG, STRUCT, T]])
}))], variablesSet=[[$cor0]])
LogicalTableScan(table=[[CATALOG, STRUCT, T]])
{code}
ImmutableSet also should be support, now exception message: type not
serializable: [$cor0] (type com.google.common.collect.SingletonImmutableSet).
> RelJson should support RexSubQuery
> ----------------------------------
>
> Key: CALCITE-5304
> URL: https://issues.apache.org/jira/browse/CALCITE-5304
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.32.0
> Reporter: Benchao Li
> Assignee: Benchao Li
> Priority: Major
>
> In CALCITE-5127, we found that {{RelJson}} does not support {{RexSubQuery}}
> now, and we should support it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
