ping @Timo @Jark @Shengkai Best, Paul Lam
> 2022年4月18日 17:12,Paul Lam <paullin3...@gmail.com> 写道: > > Hi team, > > I’d like to start a discussion about FLIP-222 [1], which adds query lifecycle > statements to SQL client. > > Currently, SQL client supports submitting queries (queries in a broad sense, > including DQLs and DMLs) but no further lifecycle statements, like canceling > a query or triggering a savepoint. That makes SQL users have to rely on > CLI or REST API to manage theirs queries. > > Thus, I propose to introduce the following statements to fill the gap. > SHOW QUERIES > STOP QUERY <query_id> > CANCEL QUERY <query_id> > TRIGGER SAVEPOINT <savepoint_path> > DISPOSE SAVEPOINT <savepoint_path> > These statement would align SQL client with CLI, providing the full lifecycle > management for queries/jobs. > > Please see the FLIP page[1] for more details. Thanks a lot! > (For reference, the previous discussion thread see [2].) > > [1] > https://cwiki.apache.org/confluence/display/FLINK/FLIP-222%3A+Support+full+query+lifecycle+statements+in+SQL+client > > <https://cwiki.apache.org/confluence/display/FLINK/FLIP-222:+Support+full+query+lifecycle+statements+in+SQL+client> > [2] https://lists.apache.org/thread/wr47ng0m2hdybjkrwjlk9ftwg403odqb > <https://lists.apache.org/thread/wr47ng0m2hdybjkrwjlk9ftwg403odqb> > > Best, > Paul Lam >