[jira] [Commented] (FLINK-33372) Cryptic exception for a sub query in a CompiledPlan

["xuyang (Jira)" <ji...@apache.org>]

    [ 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)