Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
aggOWnFn_44.q
blob: 3d54503bea18409ea2ae79c323e7d3fff8035a31 [
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
(
true
);