Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
cte_mat_2.q
blob: bfef11b9d63c471bc7390fd24f6f8f6445ff3452 [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
src
set
hive
.
mapred
.
mode
=
nonstrict
;
set
hive
.
optimize
.
cte
.
materialize
.
threshold
=
3
;
set
hive
.
explain
.
user
=
true
;
explain
with
q1
as
(
select
*
from
src
where
key
=
'5'
)
select
a
.
key
from
q1 a join q1 b
on a
.
key
=
b
.
key
;