combine_all_pg.sql 343 B

1234567891011121314151617
  1. use plato;
  2. pragma yt.UsePartitionsByKeysForFinalAgg="false";
  3. SELECT
  4. Pg::count(),
  5. Pg::count(a),
  6. Pg::sum(c),
  7. Pg::min(a),
  8. Pg::max(a),
  9. Pg::min(c),
  10. Pg::max(c),
  11. Pg::avg(c),
  12. Pg::avg(PgCast(1p,pgint4)),
  13. Pg::avg(PgCast(1p,pgint8)),
  14. Pg::avg(PgCast(1p,pgfloat8)),
  15. Pg::regr_count(1.0p,1.0p)
  16. FROM Input