[
https://issues.apache.org/jira/browse/FLINK-39957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated FLINK-39957:
-----------------------------------
Labels: pull-request-available (was: )
> Support EXPLAIN CREATE [OR ALTER] MATERIALIZED TABLE statements
> ---------------------------------------------------------------
>
> Key: FLINK-39957
> URL: https://issues.apache.org/jira/browse/FLINK-39957
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API, Table SQL / Planner
> Reporter: Ramin Gharib
> Assignee: Ramin Gharib
> Priority: Major
> Labels: pull-request-available
>
> h2. Problem
> Running {{EXPLAIN}} against a {{CREATE [OR ALTER] MATERIALIZED TABLE ... AS
> SELECT}} statement fails with a parse error, blocking the ability to inspect
> query plans for materialized table definitions.
> h2. Steps to reproduce
> Run the following statement:
> {code:java}
> EXPLAIN CREATE OR ALTER MATERIALIZED TABLE mt
> AS SELECT a, b, c
> FROM t1;{code}
> h2. Actual result
> The statement fails with:
> {quote}SQL parse failed. Unsupported CREATE OR REPLACE statement for EXPLAIN.
> The statement must define a query using the AS clause (i.e. CTAS/RTAS
> statements).
> {quote}
> This is misleading — the statement above does define a query using an {{AS}}
> clause, so the error message does not reflect what is actually happening.
> h2. Expected result
> {{EXPLAIN}} should be supported for {{CREATE [OR ALTER] MATERIALIZED TABLE
> ... AS SELECT}} statements and return the query plan, consistent with how it
> works for CTAS/RTAS.
> h2. Impact
> Without {{EXPLAIN}} support, users cannot inspect or validate query plans
> before creating materialized tables, which makes debugging and tuning
> materialized table definitions difficult.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
