...

Discussion thread: https://lists.apache.org/thread/qkvh9p5w9b12s7ykh3l7lv7m9dbgnf1g

JIRA: TBD

Released: <Flink Version>

...

1. Support the new statements and operations in SQL parser and Planner.
2. Extend Executor to support the new operations.

Compatibility, Deprecation, and Migration Plan

This FLIP introduces new SQL keywords, which may cause troubles for the existing SQLs. Users need to escape the new keywords if they use them as SQL identifiers.

The new keywords are:

• • QUERY (new)
  • QUERIES (new)
  • STOP (new)
  • CANCEL (new)
  • TIGGER (already reserved)
  • DISPOSE (new)
  • SAVEPOINT (already reserved)
  • SAVEPOINTS (new)

Rejected Alternatives

An alternative approach to query monitoring is that the SQL client or gateway book keeps every query and is responsible for updating the query status through polling or callbacks. In that way, the query status is better maintained, and we wouldn’t lose track of the queries in cases that they’re cleaned up by the cluster or the cluster is unavailable.

...