hi Flavio, TableEnvironment.getCompletionHints maybe already meet the requirement.
Flavio Pompermaier <pomperma...@okkam.it> 于2020年1月18日周六 下午3:39写道: > Why not adding also a suggest() method (also unimplemented initially) that > would return the list of suitable completions/tokens on the current query? > How complex eould it be to implement it in you opinion? > > Il Ven 17 Gen 2020, 18:32 Fabian Hueske (Jira) <j...@apache.org> ha > scritto: > > > Fabian Hueske created FLINK-15644: > > ------------------------------------- > > > > Summary: Add support for SQL query validation > > Key: FLINK-15644 > > URL: https://issues.apache.org/jira/browse/FLINK-15644 > > Project: Flink > > Issue Type: New Feature > > Components: Table SQL / API > > Reporter: Fabian Hueske > > > > > > It would be good if the {{TableEnvironment}} would offer methods to check > > the validity of SQL queries. Such a method could be used by services (CLI > > query shells, notebooks, SQL UIs) that are backed by Flink and execute > > their queries on Flink. > > > > Validation should be available in two levels: > > # Validation of syntax and semantics: This includes parsing the query, > > checking the catalog for dbs, tables, fields, type checks for expressions > > and functions, etc. This will check if the query is a valid SQL query. > > # Validation that query is supported: Checks if Flink can execute the > > given query. Some syntactically and semantically valid SQL queries are > not > > supported, esp. in a streaming context. This requires running the > > optimizer. If the optimizer generates an execution plan, the query can be > > executed. This check includes the first step and is more expensive. > > > > The reason for this separation is that the first check can be done much > > fast as it does not involve calling the optimizer. Hence, it would be > > suitable for fast checks in an interactive query editor. The second check > > might take more time (depending on the complexity of the query) and might > > not be suitable for rapid checks but only on explicit user request. > > > > Requirements: > > * validation does not modify the state of the {{TableEnvironment}}, i.e. > > it does not add plan operators > > * validation does not require connector dependencies > > * validation can identify the update mode of a continuous query result > > (append-only, upsert, retraction). > > > > Out of scope for this issue: > > * better error messages for unsupported features as suggested by > > FLINK-7217 > > > > > > > > -- > > This message was sent by Atlassian Jira > > (v8.3.4#803005) > > >