MapReduce服务 MRS-MERGE INTO:示例

时间：2023-11-01 16:25:25

MapReduce服务 MRS

示例

merge into h0 as targetusing (select id, name, price, flag from s) sourceon target.id = source.idwhen matched then update set *when not matched then insert *;merge into h0using (select id, name, price, flag from s) sourceon h0.id = source.idwhen matched and flag != 'delete' then update set id = source.id, name = source.name, price = source.price * 2when matched and flag = 'delete' then deletewhen not matched then insert (id,name,price) values(source.id, source.name, source.price);merge into t0 as targetusing s0 sourceon target.id = source.idwhen matched then update set *when not matched then insert *;

上一篇：MapReduce服务 MRS-MERGE INTO:参数描述

下一篇：MapReduce服务 MRS-DELETE:示例