Dawid Wysakowicz created FLINK-33372:
----------------------------------------
Summary: 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
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)
