Re: [DISCUSSION] implement MERGE INTO statement

[恩爸 <44...@qq.com>]

+1


Zhichao Zhang




------------------ Original ------------------
From: "ravipesala [via Apache CarbonData Dev Mailing List archive]"<ml...@n5.nabble.com>;
Date: Sat, Aug 31, 2019 05:16 PM
To: "恩爸"<44...@qq.com>;

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 ml+s1130556n1h67@n5.nabble.com 
 		To unsubscribe from Apache CarbonData Dev Mailing List archive, click here.
 		NAML