+1 Regards Kumar Vishal On Sat, 31 Aug 2019 at 14:42, Ravindra Pesala <ravi.pes...@gmail.com> wrote:
> 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 <qiang...@apache.org> 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 >
