Re: [DISCUSSION] implement MERGE INTO statement

Posted by xm_zzc on Sep 02, 2019; 3:41am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-implement-MERGE-INTO-statement-tp83941p83954.html

+1


Zhichao Zhang




------------------ Original ------------------
From: "ravipesala [via Apache CarbonData Dev Mailing List archive]"<[hidden email]>;
Date: Sat, Aug 31, 2019 05:16 PM
To: "恩爸"<[hidden email]>;

Subject: Re: [DISCUSSION] implement MERGE INTO statement



  Hi David,

+1

It is better to follow the hive syntax rather than having our own. Please
check it
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Merge

And also it is better to have design document explaining the changes to be
done on current IUD.

Regards,
Ravindra.

On Sat, 31 Aug 2019 at 11:44 AM, David Cai <[hidden email]> wrote:

> 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
>

--  
Thanks & Regards,
Ravi
 
 
 
  If you reply to this email, your message will be added to the discussion below:
  http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/DISCUSSION-implement-MERGE-INTO-statement-tp83941p83948.html 
  To start a new topic under Apache CarbonData Dev Mailing List archive, email [hidden email]
  To unsubscribe from Apache CarbonData Dev Mailing List archive, click here.
  NAML