Versions Compared

Old Version 13

changes.mady.by.user Paul Lam

Saved on

compared with

New Version 14

changes.mady.by.user Paul Lam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Add savepoint syntax in SQL standard

...

This statement triggers savepoints for the specified query, which is similar to `flink savepoint` in CLI.

There're mainly 2 styles of syntax: 

Option 1: 

Code Block
languagesql
titleSyntax: CREATE SAVEPOINT
CREATE SAVEPOINT <query_id>

Option 2

Code Block
languagesql
titleSyntax: Transaction Savepoint
SAVEPOINT <query_id>


The result would the savepoint path.

Code Block
languagesql
titleResult: CREATE SAVEPOINT
+------------------------------------------------------|
|            savepoint_path                            |
+------------------------------------------------------|
| /tmp/flink-savepoints/savepoint-cca7bc-bb1e257f0dab  |
+------------------------------------------------------|

DROP A SAVEPOINT

This statement deletes the specified savepoint, which is similar to `flink savepoint –dispose` in CLI.

There're mainly 2 styles of syntax:

Option 1

Code Block
languagesql
titleSyntax: DROP SAVEPOINT
DROP SAVEPOINT <savepoint_path>

Option 2

Code Block
languagesql
titleSyntax: DROP SAVEPOINTRelease Transaction Savepoint
RELEASEDROP SAVEPOINT <savepoint_path>

...