Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
nestedAggs
/
wPbOb_14.q
blob: 293084da57bad317c92fb67ca7bfab34cad9fd59 [
file
]
SELECT c2
,
MAX
(
COUNT
(
c1
))
OVER
(
PARTITION BY c2 ORDER BY c2
)
FROM
`tblWnulls.parquet`
GROUP BY c2
;