Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 18686b50ca
Branches Tags
ydb
/
yt
/
yql
/
tests
/
sql
/
suites
/
blocks
/
distinct_opt_state_all.sql

distinct_opt_state_all.sql 189 B
History Raw

1234567 
  1. pragma yt.UsePartitionsByKeysForFinalAgg="false";
    2. 

  2. 

  3. USE plato;
    4. 

  4. 

  5. SELECT
    6. 

  6.     count(*),max(subkey),sum(distinct subkey),avg(subkey),count(distinct subkey/2u),avg(distinct subkey/2u)
    7. 

  7. FROM Input
    8.