Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
aggOWnFn_42.q
blob: 03e34f5002a4d90348562fa56497a94e34339a45 [
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 col1 NOT IN
(-
1
,
0
,
1
,-
65535
,
10000000
)
AND col7 NOT IN
(
false
);