minmax_tuple.sql 287 B

12345678910111213141516
  1. pragma yt.UsePartitionsByKeysForFinalAgg="false";
  2. USE plato;
  3. select
  4. key,
  5. min(AsTuple(subkey, value)) as min,
  6. max(AsTuple(subkey, value)) as max,
  7. from Input
  8. group by key
  9. order by key;
  10. select
  11. min(AsTuple(subkey, value)) as min,
  12. max(AsTuple(subkey, value)) as max,
  13. from Input;