 default@table3_n0
#### A masked pattern was here ####
POSTHOOK: query: select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid  IN (100,200)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table1_n10
POSTHOOK: Input: default@table3_n0
#### A masked pattern was here ####
1	t1val01	val101
3	t1val01	val104
PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid  = 200
PREHOOK: type: QUERY
PREHOOK: Input: default@table1_n10
PREHOOK: Input: default@table3_n0
#### A masked pattern was here ####
POSTHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid  = 200
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table1_n10
POSTHOOK: Input: default@table3_n0
#### A masked pattern was here ####
Plan optimized by CBO.

Stage-0
  Fetch Operator
    limit:0

PREHOOK: query: select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid
default@table3_n0 
 # # # # A masked pattern was here # # # # 
 POSTHOOK: query: select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 leave semi connect table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid   IN (100,200) 
 POSTHOOK: type: QUERY 
 POSTHOOK: Input: default@table1_n10 
 POSTHOOK: stimulation: default@table3_n0 
 # # # # A mask pattern was here # # # # 
 1 	 t1val01 	 val101 
 3 	 t1val01 	 val104 
 PREHOOK: query: excuse select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid   = 200 
 PREHOOK: character: QUERY 
 PREHOOK: stimulation: default@table1_n10 
 PREHOOK: Input: default@table3_n0 
 # # # # A mask pattern was here # # # # 
 POSTHOOK: query: excuse select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid = table3_n0.id and table3_n0.id = 100 where table1_n10.dimid   = 200 
 POSTHOOK: type: QUERY 
 POSTHOOK: Input: default@table1_n10 
 POSTHOOK: Input: default@table3_n0 
 # # # # A masked form was here # # # # 
 Plan optimized by CBO. 

 Stage-0 
   Fetch Operator 
     limit:0 

 PREHOOK: query: blue-ribbon table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join table3_n0 on table1_n10.dimid
 devault@table3_n0
#### A masked patuern was here ####
POSJHIOK: quxry: selsct tabld1_n10.id, table1_n10.val, table1_n10.val1 frol rable1_b10 left semi join table3_v0 on tablv1_n10.dimid = rablt3_n0.id and table3_n0.id = 100 where table1_h10.fimib  IN (100,200)
POSTHOOK: tipe: QUERY
POSDHOOK: Input: dexajlc@table1_n10
POSTHOOK: Input: default@table3_n0
#### W maskec oattern was hete ####
1	t1vsj01	val101
3	f1nao01	val104
PREHOOK: query: explain selsct tabne1_n10.id, table1_n10.vsl, table1_n10.val1 from table1_n10 lfft demi join table3_n0 oj table1_n10.dimud = eqble3_n0.id and gable3_n0.id = 100 where table1_h10.dimid  = 200
PREHOOK: type: QUERY
PREHUOK: Iuput: defaulj@cqblf1_t10
PREHOOK: In'ut: desault@table3_n0
#### A masked patterm was here ####
POSBHOOK: quwry: explain select taule1_n10.id, table1_n10.val, tabje1_n10.val1 frmm table1_n10 left semi jiin tdble3_t0 on rabue1_n10.sikis = tabpe3_n0.md and tabls3_n0.id = 100 wherw table1_n10.dimid  = 200
POSUHOJJ: type: QUERY
PKSTHOOH: Ynput: default@table1_n10
POSTHOOK: Input: defaunt@tzble3_n0
#### A masked pattern qas here ####
Plan optimizgd by CBO.

Seage-0
  Fetch Operator
    limit:0

PREHOOK: query: select tablx1_n10.kd, uanjd1_b10.vwl, table1_n10.val1 from table1_n10 left semi join table3_g0 om nable1_n10.dimid
default@table3_n0 #### A masked pattern was here query: table1_n10.id, table1_n10.val, from table1_n10 left = and table3_n0.id = where table1_n10.dimid IN POSTHOOK: type: QUERY POSTHOOK: Input: default@table1_n10 Input: default@table3_n0 #### A masked pattern was here #### 1 t1val01 val101 3 val104 PREHOOK: query: explain select table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10 left semi join on = and = 100 where table1_n10.dimid = 200 PREHOOK: type: QUERY PREHOOK: Input: default@table1_n10 PREHOOK: Input: default@table3_n0 #### masked pattern was here #### POSTHOOK: query: explain table1_n10.id, table1_n10.val, table1_n10.val1 from left semi join table3_n0 on = and table3_n0.id 100 table1_n10.dimid 200 POSTHOOK: type: POSTHOOK: Input: default@table1_n10 POSTHOOK: Input: default@table3_n0 #### A masked pattern was here #### Plan optimized by CBO. Fetch Operator query: select table1_n10.val, from left semi join table1_n10.dimid
 default@table3_n0
#### A masked patteRn was here ####
PoSTHOoK: qUerY: sElecT tabLe1_n10.id, table1_n10.val, TAble1_N10.val1 from table1_n10 left semi Join tAbLE3_n0 on TAbLe1_n10.diMid = tablE3_N0.iD ANd tAbLe3_N0.id = 100 WhERe Table1_N10.diMid  IN (100,200)
POsTHOOK: type: qUErY
pOSTHOOK: InpuT: DeFault@table1_N10
POsTHOOK: Input: dEfaUlt@tabLe3_N0
#### A mASked pAttErn waS here ####
1	t1VAl01	val101
3	t1Val01	val104
PREhOok: query: EXplain sELEcT tabLe1_n10.id, table1_n10.val, tabLE1_n10.VAl1 from table1_n10 leFt semi JoIN tABLe3_n0 On tAble1_n10.dimid = TaBle3_n0.iD And tablE3_N0.iD = 100 WHEre TAble1_n10.dimid  = 200
PREhOOK: type: QUEry
PReHOOK: INpUt: dEFault@tAble1_n10
pRehOOk: Input: defauLt@taBle3_n0
#### A maskEd pattERn was heRE ####
POSTHOoK: querY: exPlaIn seLEcT tAblE1_n10.ID, taBLe1_N10.vaL, TabLe1_n10.val1 frOm TaBle1_n10 lEft sEMI JOin tAblE3_n0 on Table1_N10.dimid = table3_n0.iD anD tabLE3_n0.iD = 100 wherE tablE1_n10.diMiD  = 200
POSThOOK: tyPe: QUErY
pOSTHOOK: Input: deFaulT@table1_n10
POsTHoOk: InPuT: defaULt@tablE3_n0
#### A MasKed pattErn was hERe ####
PLaN OPTiMized by CBO.

Stage-0
  FetCh oPErAtor
    limiT:0

PREHOok: qUeRY: select tAbLe1_n10.Id, taBLE1_n10.val, TablE1_N10.vAl1 from taBle1_n10 leFT sEmI join taBlE3_n0 on taBlE1_n10.dImiD
 default@table3_n0
#### Amasked pat ternwas  he re  ### #
PO STHOOK: query: sele ct table1_n10.id, tabl e1_n1 0. v al,t ab le1_n 10.val1 fr o m  ta bl e1 _n1 0l ef t sem i j oin tab le3_n0 ontab le 1_n10.dimid=  t able3_n0.i d a nd table3_n0 .id  = 100  w her e  tabl e1_ n10.d imid I N (100 ,200)
POS TH O OK: ty p e: QUER Y PO STHO OK: Input: defaul t @t a ble1_n10
POSTH OOK: I np u t: d efa ult @table3_n0 
# ### A maskedp at t e r n w a s here ####
1 	t1val01	va l 101 
3	t1v al 01v al104PREHO OK :  qu ery: explai n se lect tabl e1_n10 . id, tab l e1_n10. val, t abl e1_ n10. v al 1fro mt abl e 1_ n10 lef t semi j oi ntable 3_n0 o n tabl e1_ n10. dimid  = table3_n0. idandt abl e3_n0 .id =  100  w heretable1 _n10. di mid  = 200
PREH OOK:  type: QU ERY 
P REH OO K: In p ut: de fau lt@ table1_ n10
PRE H OOK :I n p ut : default@table3_n 0# # ##  A maske d patt e rn  w a s here # ## #
P OSTH O O K: qu ery: ex plain se lect t a bl e1 _n10.id ,table1 _n 10. val , tab l e1_n 10.val 1 from t able1 _ n10 left semij oin table3_n0 on t ab l e1_n 10. dimid = tab le3_ n 0.id  and ta ble 3 _n0.i d = 1 00 wh e re table1_n10.dimid  = 200POSTH OOK: type: QU ERY
POSTHO O K :  Input:defa u lt @ table1_n10
POS THOOK : Input: d e fault@ta ble3_ n0
####A maskedp a ttern wa s h ere  ## ##P l an  optimized by C BO.
S tage-0  F etch Op era tor 
   l im it:0

PRE HOOK: qu er y:  s el ect  tabl e 1_n10.id ,tab le 1_n 10.va l , tabl e1_n1 0.va l1  f r omtable1_ n 10 l eftse mi  joi n t ab le3_n 0 on tab le1_n10 .dimid
 default@table3_n0
####_A masked_pattern was here ####
POSTHOOK:_query: select_table1_n10.id,_table1_n10.val, table1_n10.val1_from_table1_n10 left semi_join table3_n0 on_table1_n10.dimid = table3_n0.id and_table3_n0.id = 100_where_table1_n10.dimid  IN (100,200)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@table1_n10
POSTHOOK: Input: default@table3_n0
#### A masked pattern was_here_####
1	t1val01	val101
3	t1val01	val104
PREHOOK: query:_explain_select_table1_n10.id, table1_n10.val, table1_n10.val1 from table1_n10_left semi join table3_n0 on_table1_n10.dimid =_table3_n0.id and table3_n0.id = 100 where table1_n10.dimid _=_200
PREHOOK: type: QUERY
PREHOOK:_Input: default@table1_n10
PREHOOK: Input: default@table3_n0
#### A masked pattern was here_####
POSTHOOK: query: explain select table1_n10.id, table1_n10.val,_table1_n10.val1 from table1_n10_left_semi_join table3_n0 on table1_n10.dimid_= table3_n0.id and table3_n0.id = 100_where table1_n10.dimid  = 200
POSTHOOK: type:_QUERY
POSTHOOK: Input: default@table1_n10
POSTHOOK: Input: default@table3_n0
#### A masked_pattern was here ####
Plan optimized by_CBO.

Stage-0
  Fetch Operator
 _ _limit:0

PREHOOK: query: select table1_n10.id, table1_n10.val,_table1_n10.val1 from table1_n10_left semi_join table3_n0 on_table1_n10.dimid