[
https://issues.apache.org/jira/browse/FLINK-33372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17781280#comment-17781280
]
xuyang commented on FLINK-33372:
--------------------------------
Hi, [~dwysakowicz] . It seems related about CALCITE-4521. Since Calcite does
not support this feature yet, maybe throwing a clearer exception when building
LogicalTableFunctionScan is a good idea. WDYT? If we agree, I'll try to fix it.
> Cryptic exception for a sub query in a CompiledPlan
> ---------------------------------------------------
>
> Key: FLINK-33372
> URL: https://issues.apache.org/jira/browse/FLINK-33372
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 1.18.0
> Reporter: Dawid Wysakowicz
> Priority: Major
>
> SQL statements with a SUBQUERY can be compiled to a plan, but such plans can
> not be executed and they fail with a cryptic exception.
> Example:
> {code}
> final CompiledPlan compiledPlan = tEnv.compilePlanSql("insert into MySink
> SELECT * FROM LATERAL TABLE(func1(select c from MyTable))");
>
> tEnv.loadPlan(PlanReference.fromJsonString(compiledPlan.asJsonString())).execute();
> {code}
> fails with:
> {code}
> org.apache.flink.table.planner.codegen.CodeGenException: Unsupported call:
> $SCALAR_QUERY()
> If you think this function should be supported, you can create an issue and
> start a discussion for it.
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
