Rui Li created FLINK-14089:
------------------------------
Summary: 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
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.2#803003)
