blob: 776834e93aa9ee56dc2a7e3bb7fdb4d8735090a4 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
pragma yt.UsePartitionsByKeysForFinalAgg="false";
USE plato;
select
key,
max(s) as maxs,
min(s) as mins,
min(s_opt) as mins_opt,
max(s_opt) as maxs_opt,
max(distinct utf) as dmaxs,
min(distinct utf) as dmins,
min(distinct s_opt) as dmins_opt,
max(distinct s_opt) as dmaxs_opt,
from Input
group by key
order by key;
|
