[
https://issues.apache.org/jira/browse/FLINK-14089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17328283#comment-17328283
]
Flink Jira Bot commented on FLINK-14089:
----------------------------------------
This major issue is unassigned and itself and all of its Sub-Tasks have not
been updated for 30 days. So, it has been labeled "stale-major". If this ticket
is indeed "major", please either assign yourself or give an update. Afterwards,
please remove the label. In 7 days the issue will be deprioritized.
> SQL CLI doesn't support explain DMLs
> ------------------------------------
>
> Key: FLINK-14089
> URL: https://issues.apache.org/jira/browse/FLINK-14089
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Client
> Reporter: Rui Li
> Priority: Major
> Labels: stale-major
>
> It seems SQL CLI only supports explaining queries. Tried to explain some
> INSERT statement and get
> {noformat}
> 2019-09-16 21:04:51,755 WARN org.apache.flink.table.client.cli.CliClient
> - Could not execute SQL statement.
> org.apache.flink.table.client.gateway.SqlExecutionException: Invalid SQL
> statement.
> at
> org.apache.flink.table.client.gateway.local.LocalExecutor.explainStatement(LocalExecutor.java:310)
> at
> org.apache.flink.table.client.cli.CliClient.callExplain(CliClient.java:459)
> at
> org.apache.flink.table.client.cli.CliClient.callCommand(CliClient.java:289)
> at java.util.Optional.ifPresent(Optional.java:159)
> at
> org.apache.flink.table.client.cli.CliClient.open(CliClient.java:201)
> at org.apache.flink.table.client.SqlClient.openCli(SqlClient.java:123)
> at org.apache.flink.table.client.SqlClient.start(SqlClient.java:105)
> at org.apache.flink.table.client.SqlClient.main(SqlClient.java:194)
> Caused by: org.apache.flink.table.client.gateway.SqlExecutionException:
> Invalid SQL statement.
> at
> org.apache.flink.table.client.gateway.local.LocalExecutor.createTable(LocalExecutor.java:537)
> at
> org.apache.flink.table.client.gateway.local.LocalExecutor.explainStatement(LocalExecutor.java:306)
> ... 7 more
> Caused by: org.apache.flink.table.api.ValidationException: Unsupported SQL
> query! sqlQuery() only accepts a single SQL query of type SELECT, UNION,
> INTERSECT, EXCEPT, VALUES, and ORDER_BY.
> at
> org.apache.flink.table.api.internal.TableEnvironmentImpl.sqlQuery(TableEnvironmentImpl.java:301)
> at
> org.apache.flink.table.client.gateway.local.LocalExecutor.lambda$createTable$12(LocalExecutor.java:534)
> at
> org.apache.flink.table.client.gateway.local.ExecutionContext.wrapClassLoader(ExecutionContext.java:216)
> at
> org.apache.flink.table.client.gateway.local.LocalExecutor.createTable(LocalExecutor.java:534)
> ... 8 more
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
