Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
join24.q
blob: a0cd790a8e17d2feccbb2986fab5cc136fdd8dd5 [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
src
create table tst1
(
key STRING
,
cnt INT
);
INSERT OVERWRITE TABLE tst1
SELECT a
.
key
,
count
(
1
)
FROM src a
group
by
a
.
key
;
SELECT sum
(
a
.
cnt
)
FROM tst1 a JOIN tst1 b ON a
.
key
=
b
.
key
;