1 2 3 4 5 6
/* 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;