/* postgres can not */ -- kikimr only: pragma kikimr.UnwrapReadTableValues = "false"; create table plato.Output (key varchar null, subkey varchar null, value varchar null, primary key (key)); commit; insert into plato.Output with truncate (key, subkey, value) select key, subkey, "1" as value from plato.Input;