Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
nestedAggs
/
DRILL4808_2.q.failing
blob: e4affad44c3887ce618137a0838f7341b1b78432 [
file
]
SELECT
*,
AVG
(
SUM
(
col0
))
OVER
(
PARTITION BY col7 ORDER BY col8
)
avg_sum_c0
FROM
`allTypsUniq.parquet`
GROUP BY col7
,
col8
;