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_keys.sql

distinct_opt_state_keys.sql 220 B
History Raw

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

  2. 

  3. USE plato;
    4. 

  4. 

  5. SELECT
    6. 

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

  7. FROM Input
    8. 

  8. GROUP BY key
    9. 

  9. ORDER BY key
    10. 

  10.