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


1
2
3
4
5
6
7
8
9

USE plato;
pragma yt.UseNativeDescSort;
pragma yt.UsePartitionsByKeysForFinalAgg="false";

SELECT
    count(*),min(i8)
FROM (SELECT * FROM concat(Dates,Dates)) as t
GROUP BY na,wa,naz,waz,nd,ndz,wd,wdz,nt,ntz,wt,wtz,ni,wi;