PREHOOK: query: -- union test
with q1 as (select * from src where key= '5'),
q2 as (select * from src s2 where key = '4')
select * from q1 union all select * from q2
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- union test
with q1 as (select * from src where key= '5'),
q2 as (select * from src s2 where key = '4')
select * from q1 union all select * from q2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
4	val_4
5	val_5
5	val_5
5	val_5
PREHOOK: query: -- insert test
create table s1 like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@s1
POSTHOOK: query: -- insert test
create table s1 like src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@s1
PREHOOK: query: with q1 as ( select key, value from src where key = '5')
from q1
insert overwrite table s1
select *
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@s1
POSTHOOK: query: with q1 as ( select key, value from src where key = '5')
from q1
insert overwrite table s1
select *
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@s1
POSTHOOK: Lineage: s1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: s1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select * from s1
PREHOOK: type: QUERY
PREHOOK: Input: default@s1
#### A masked pattern was here ####
POSTHOOK: query: select * from s1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@s1
#### A masked pattern was here ####
5	val_5
5	val_5
5	val_5
PREHOOK: query: drop table s1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@s1
PREHOOK: Output: default@s1
POSTHOOK: query: drop table s1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@s1
POSTHOOK: Output: default@s1
PREHOOK: query: -- from style
with q1 as (select * from src where key= '5')
from q1
select *
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- from style
with q1 as (select * from src where key= '5')
from q1
select *
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
5	val_5
5	val_5
5	val_5
PREHOOK: query: -- ctas
create table s2 as
with q1 as ( select key from src where key = '4')
select * from q1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@s2
POSTHOOK: query: -- ctas
create table s2 as
with q1 as ( select key from src where key = '4')
select * from q1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@s2
PREHOOK: query: select * from s2
PREHOOK: type: QUERY
PREHOOK: Input: default@s2
#### A masked pattern was here ####
POSTHOOK: query: select * from s2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@s2
#### A masked pattern was here ####
4
PREHOOK: query: drop table s2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@s2
PREHOOK: Output: default@s2
POSTHOOK: query: drop table s2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@s2
POSTHOOK: Output: default@s2
PREHOOK: query: -- view test
create view v1 as
with q1 as ( select key from src where key = '5')
select * from q1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@v1
POSTHOOK: query: -- view test
create view v1 as
with q1 as ( select key from src where key = '5')
select * from q1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@v1
PREHOOK: query: select * from v1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@v1
#### A masked pattern was here ####
POSTHOOK: query: select * from v1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@v1
#### A masked pattern was here ####
5
5
5
PREHOOK: query: drop view v1
PREHOOK: type: DROPVIEW
PREHOOK: Input: default@v1
PREHOOK: Output: default@v1
POSTHOOK: query: drop view v1
POSTHOOK: type: DROPVIEW
POSTHOOK: Input: default@v1
POSTHOOK: Output: default@v1
PREHOOK: query: -- view test, name collision
create view v1 as
with q1 as ( select key from src where key = '5')
select * from q1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@v1
POSTHOOK: query: -- view test, name collision
create view v1 as
with q1 as ( select key from src where key = '5')
select * from q1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@v1
PREHOOK: query: with q1 as ( select key from src where key = '4')
select * from v1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@v1
#### A masked pattern was here ####
POSTHOOK: query: with q1 as ( select key from src where key = '4')
select * from v1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@v1
#### A masked pattern was here ####
5
5
5
PREHOOK: query: drop view v1
PREHOOK: type: DROPVIEW
PREHOOK: Input: default@v1
PREHOOK: Output: default@v1
POSTHOOK: query: drop view v1
POSTHOOK: type: DROPVIEW
POSTHOOK: Input: default@v1
POSTHOOK: Output: default@v1