--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.optimize.cte.materialize.threshold=-1;
set hive.explain.user=true;

create database mydb;
use mydb;
create table q1_n0 (colnum int, colstring string);
insert into q1_n0 values (5, 'A');

use default;

show tables in mydb;

explain
with q1_n0 as (select * from src where key= '5')
select a.colnum
from mydb.q1_n0 as a join q1_n0 as b
on a.colnum=b.key;

with q1_n0 as (select * from src where key= '5')
select a.colnum
from mydb.q1_n0 as a join q1_n0 as b
on a.colnum=b.key;