[DISCUSSION] implement MERGE INTO statement

Posted by David Cai on Aug 31, 2019; 6:14am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-implement-MERGE-INTO-statement-tp83941.html

hi all,
    CarbonData has supported the insert/update/delete operations.
    Now we can start to discuss the MERGE INTO statement.
    It should combine insert, update and delete operations into a single statement, and it will be executed atomically.
   
SQL maybe like :
     MERGE INTO target_table
     USING source_table
     ON merge_condition
     WHEN MATCHED [ AND condition] THEN
         UPDATE | DELETE ...
     WHEN NOT MATCHED [ AND condition]  THEN
         INSERT ...

    Any question and suggestion are welcome.

Regards
David QiangCai