sql - Apache Ignite SQL 是否支持 MERGE WHEN？

Question

Apache Ignite SQL 支持 MERGE 语句。这种支持是否扩展到 MERGE WHEN（例如在 H2 中）？例如

 MERGE INTO account (client_id, tran_ccy, last_tran_dt)
  (SELECT DISTINCT client_id, tran_ccy, Max(tran_dt) 
   FROM transaction
   GROUP BY client_id, tran_ccy)
 WHEN MATCHED THEN 
   UPDATE SET last_tran_dt = tran_dt
 WHEN NOT MATCHED THEN
   INSERT (client_id, tran_ccy, last_tran_dt)
   VALUES (client_id, tran_ccy, tran_dt)

标签： sqlignite

Answer 1

据我所知，Ignite 仅支持简单MERGE的 from H2withoutUSING声明。这是简单形式http://www.h2database.com/html/commands.html#merge的语法。这里也有描述https://apacheignite-sql.readme.io/docs/merge。