Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
nestedAggs
/
basic_9.q
blob: c11f6086b0295a59c803bfd796659ae8472eb9f3 [
file
]
SELECT col8
,
COUNT
(
COUNT
(
col8
))
OVER
(
PARTITION BY col7 ORDER BY col0
)
count_col8
,
col7 FROM
`allTypsUniq.parquet`
GROUP BY col0
,
col7
,
col8
;