yql/essentials/tests/sql/suites/blocks/minmax_tuple.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

pragma yt.UsePartitionsByKeysForFinalAgg="false";

USE plato;

select
  key,
  min(AsTuple(subkey, value)) as min,
  max(AsTuple(subkey, value)) as max,
from Input
group by key
order by key;

select
  min(AsTuple(subkey, value)) as min,
  max(AsTuple(subkey, value)) as max,
from Input;