Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientnegative
/
ptf_negative_HavingLeadWithNoGBYNoWindowing.q
blob: abe0bac6a7eb24f7452ec9495e10c0e49e5e7a77 [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
part
--
testHavingLeadWithNoGBYNoWindowing
select
p_mfgr
,
p_name
,
p_size
from
part
having lead
(
p_size
,
1
)
over
()
<=
p_size
distribute
by
p_mfgr
sort
by
p_name
;