Re: [DISCUSSION] implement MERGE INTO statement

Posted by on Aug 31, 2019; 4:38pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-implement-MERGE-INTO-statement-tp83941p83951.html

Hi David,
Can you please create a JIRA and upload a design document.

Regards,
Akash

On 2019/08/31 06:14:45, 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
>