Apachge 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)

Answer 1

据

我所知，Ignite 仅支持来自H2的简单MERGE USING而没有语句。这是简单形式 http://www.h2database.com/html/commands.html#merge 的语法。这里也有描述 https://apacheignite-sql.readme.io/docs/merge。