Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientnegative
/
ptf_negative_NoWindowDefn.q
blob: 214b143b06ac65debf633b91c8c5c83dd0bc1f32 [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
part
--
testNoWindowDefn
select
p_mfgr
,
p_name
,
p_size
,
sum
(
p_size
)
over
(
w1
)
as
s1
,
sum
(
p_size
)
over
(
w2
)
as
s2
from
part
window w1
as
(
rows between
2
preceding
and
2
following
)
distribute
by
p_mfgr
sort
by
p_mfgr
;