Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
aggOWnFn_36.q
blob: 37c2a16d7384c14d99c2ff4e96a0b30521f7906e [
file
] [
log
] [
blame
]
SELECT MIN
(
firstVal_col1
)
FROM
(
SELECT FIRST_VALUE
(
col1
)
OVER
(
PARTITION BY col7 ORDER BY col1
)
firstVal_col1
,
col7 FROM
`allTypsUniq.parquet`
)
sub_query
;