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