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


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

use plato;
pragma yt.UsePartitionsByKeysForFinalAgg="false";

SELECT
    Pg::count(),
    Pg::count(a),
    Pg::sum(c),
    Pg::min(a),
    Pg::max(a),
    Pg::min(c),
    Pg::max(c),
    Pg::avg(c),
    Pg::avg(PgCast(1p,pgint4)),
    Pg::avg(PgCast(1p,pgint8)),
    Pg::avg(PgCast(1p,pgfloat8)),
    Pg::regr_count(1.0p,1.0p)
FROM Input
group by len(d)