/* syntax version 1 */ use plato; select distinct k || "_" as k1, "_" || v as v1 from Input2 group by key as k, value as v order by k1,v1;