[
https://issues.apache.org/jira/browse/FLINK-27344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17616929#comment-17616929
]
Paul Lin commented on FLINK-27344:
----------------------------------
[~AlexeyLV] Thanks a lot for your input! It's very informative.
Providing only system stored procedures without user-defined ones is indeed an
approach we had not thought about or discussed. But given that the community
has voted through the job statement syntax and the related efforts are
currently underway, IMHO it'd be better to stick with the plan if it has no
obvious drawbacks. WDYT?
WRT INFORMATION_SCHEMA tables, I find there might be some problem with Flink's
pluggable catalog design which allows access to external systems (which is
different from common database scenarios). For catalogs like HiveCatalog or
JdbcCatalog, it would be kind of weird that users could find the
INFORMATION_SCHEMA (or maybe another name that is less likely to conflict)
tables only through Flink SQL client.
> FLIP-222: Support full job lifecycle statements in SQL client
> -------------------------------------------------------------
>
> Key: FLINK-27344
> URL: https://issues.apache.org/jira/browse/FLINK-27344
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Client
> Reporter: Paul Lin
> Assignee: Paul Lin
> Priority: Major
>
> With the efforts in FLIP-24 and FLIP-91, Flink SQL client supports submitting
> SQL jobs but lacks further support for their lifecycles afterward which is
> crucial for streaming use cases. That means Flink SQL client users have to
> turn to other clients (e.g. CLI) or APIs (e.g. REST API) to manage the jobs,
> like triggering savepoints or canceling queries, which makes the user
> experience of SQL client incomplete.
> Therefore, this proposal aims to complete the capability of SQL client by
> adding job lifecycle statements. With these statements, users could manage
> jobs and savepoints through pure SQL in SQL client.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
