http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-implement-MERGE-INTO-statement-tp83941p83950.html
> 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
>