[jira] [Created] (FLINK-21285) Support MERGE INTO for flink sql

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-21285) Support MERGE INTO for flink sql

Shang Yuanchun (Jira)
Jun Zhang created FLINK-21285:
---------------------------------

             Summary: Support  MERGE INTO for flink sql
                 Key: FLINK-21285
                 URL: https://issues.apache.org/jira/browse/FLINK-21285
             Project: Flink
          Issue Type: Improvement
          Components: Table SQL / API
    Affects Versions: 1.12.1
            Reporter: Jun Zhang
             Fix For: 1.13.0


Support MERGE INTO for flink sql,refer to hive syntax:
{code:java}
MERGE INTO <target table> AS T USING <source expression/table> AS S
ON <boolean expression1>
WHEN MATCHED [AND <boolean expression2>] THEN UPDATE SET <set clause list>
WHEN MATCHED [AND <boolean expression3>] THEN DELETE
WHEN NOT MATCHED [AND <boolean expression4>] THEN INSERT VALUES<value list>
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)