Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
notable_alias3.q
blob: 414ba2470284cd8e6044280223645b17dc1e088e [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
src
CREATE TABLE dest1_n102
(
c
string
,
key INT
,
value DOUBLE
)
STORED AS TEXTFILE
;
FROM src
INSERT OVERWRITE TABLE dest1_n102 SELECT
'1234'
,
src
.
key
,
sum
(
src
.
value
)
WHERE src
.
key
<
100
group
by
key
;