PREHOOK: query: create temporary table src_temp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@src_temp
POSTHOOK: query: create temporary table src_temp as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_temp
PREHOOK: query: -- subquery exists
select *
from src_temp b
where exists
  (select a.key
  from src_temp a
  where b.value = a.value  and a.key = b.key and a.value > 'val_9'
  )
PREHOOK: type: QUERY
PREHOOK: Input: default@src_temp
#### A masked pattern was here ####
POSTHOOK: query: -- subquery exists
select *
from src_temp b
where exists
  (select a.key
  from src_temp a
  where b.value = a.value  and a.key = b.key and a.value > 'val_9'
  )
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_temp
#### A masked pattern was here ####
90	val_90
90	val_90
90	val_90
92	val_92
95	val_95
95	val_95
96	val_96
97	val_97
97	val_97
98	val_98
98	val_98
PREHOOK: query: -- subquery in
select *
from src_temp
where src_temp.key in (select key from src_temp s1 where s1.key > '9')
PREHOOK: type: QUERY
PREHOOK: Input: default@src_temp
#### A masked pattern was here ####
POSTHOOK: query: -- subquery in
select *
from src_temp
where src_temp.key in (select key from src_temp s1 where s1.key > '9')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_temp
#### A masked pattern was here ####
90	val_90
90	val_90
90	val_90
92	val_92
95	val_95
95	val_95
96	val_96
97	val_97
97	val_97
98	val_98
98	val_98
PREHOOK: query: select b.key, min(b.value)
from src_temp b
group by b.key
having b.key in ( select a.key
                from src_temp a
                where a.value > 'val_9' and a.value = min(b.value)
                )
PREHOOK: type: QUERY
PREHOOK: Input: default@src_temp
#### A masked pattern was here ####
POSTHOOK: query: select b.key, min(b.value)
from src_temp b
group by b.key
having b.key in ( select a.key
                from src_temp a
                where a.value > 'val_9' and a.value = min(b.value)
                )
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_temp
#### A masked pattern was here ####
90	val_90
92	val_92
95	val_95
96	val_96
97	val_97
98	val_98
PREHOOK: query: drop table src_temp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_temp
PREHOOK: Output: default@src_temp
POSTHOOK: query: drop table src_temp
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@src_temp
POSTHOOK: Output: default@src_temp