Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
aggOWnFn_43.q
blob: a281afcc4d54a2cfd7a57922429c1b080ef2b98d [
file
] [
log
] [
blame
]
SELECT MAX
(
lead_col1
)
FROM
(
SELECT col1
,
LEAD
(
col1
)
OVER
(
PARTITION BY col7 ORDER BY col1
)
lead_col1
,
col7 FROM
`allTypsUniq.parquet`
)
sub_query WHERE col7 NOT IN
(
false
);