[FLINK-27977] SavePoints housekeeping API in Flink Cli, Rest API, SQL client

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Command Line Client, Runtime / REST, Table SQL / Client
• Assignee: Unassigned
• Reporter: Jing Ge
• Created: 09/Jun/22 18:25
• Updated: 09/Jun/22 20:03

Description

We ran into this issue that a lot of savepoints have been created by customers (via their apps). It will take extra (hacking) effort to clean it. 

We should support Savepoints housekeeping to delete all savepoints:

1. REST API - /savepoints-disposal{}
2. Flink CLI - $ ./bin/flink savepoint --disposeAll
3. SQL client - DROP SAVEPOINTS (alternative option could be DROP SAVEPOINT ALL, but ALL is a SQL keyword)