Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
nestedAggs
/
frmclause02.q
blob: 22de9ae58298028d709abc78e3094f4abefd765c [
file
]
SELECT
col7
,
MAX
(
COUNT
(
col1
))
OVER
(
PARTITION BY col7 ORDER BY col8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
)
mx_count_c1
,
col8
FROM
`allTypsUniq.parquet`
GROUP BY col7
,
col8
;