1_multi_delimit
#### A masked pattern was here ####
1	1	NULL	0	0
2	1	NULL	0	1
3	1	NULL	0	0
4	1	NULL	0	1
5	5	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL
7777	NULL	NULL	NULL	NULL
8	8	NULL	8	8
9	9	NULL	9	9
10101010	NULL	NULL	NULL	NULL
PREHOOK: query: CREATE TABLE t11_csv_serde(colA int,
  colB tinyint,
  colC timestamp,
  colD smallint,
  colE smallint)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES ("separatorChar" = ",")STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@t11_csv_serde
POSTHOOK: query: CREATE TABLE t11_csv_serde(colA int,
  colB tinyint,
  colC timestamp,
  colD smallint,
  colE smallint)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES ("separatorChar" = ",")STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t11_csv_serde
PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/t11_csv_serde.csv" INTO TABLE t11_csv_serde
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@t11_csv_serde
POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/t11_csv_serde.csv" INTO TABLE t11_csv_serde
POSTHOOK: type: LOAD
#### A masked pattern was here ####
1_multi_delimit 
 # # # # A masked pattern was here # # # # 
 1 	 1 	 NULL 	 0 	 0 
 2 	 1 	 NULL 	 0 	 1 
 3 	 1 	 nothing 	 0 	 0 
 4 	 1 	 nothing 	 0 	 1 
 5 	 5 	 NULL 	 NULL 	 NULL 
 NULL 	 NULL 	 NULL 	 NULL 	 NULL 
 7777 	 NULL 	 NULL 	 NULL 	 NULL 
 8 	 8 	 nothing 	 8 	 8 
 9 	 9 	 NULL 	 9 	 9 
 10101010 	 NULL 	 NULL 	 NULL 	 NULL 
 PREHOOK: query: CREATE TABLE t11_csv_serde(colA int, 
   colB tinyint, 
   colC timestamp, 
   colD smallint, 
   colE smallint) 
 ROW FORMAT SERDE' org.apache.hadoop.hive.serde2.OpenCSVSerde' 
 WITH SERDEPROPERTIES (" separatorChar " = ", ") store AS TEXTFILE 
 PREHOOK: type: CREATETABLE 
 PREHOOK: Output: database: default option 
 PREHOOK: output signal: default@t11_csv_serde 
 POSTHOOK: query: make TABLE t11_csv_serde(colA int, 
   colB tinyint, 
   colC timestamp, 
   colD smallint, 
   colE smallint) 
 ROW FORMAT SERDE' org.apache.hadoop.hive.serde2.OpenCSVSerde' 
 WITH SERDEPROPERTIES (" separatorChar " = ", ") STORED AS TEXTFILE 
 POSTHOOK: character: CREATETABLE 
 POSTHOOK: Output: database: default 
 POSTHOOK: Output: default@t11_csv_serde 
 PREHOOK: query: LOAD datum LOCAL INPATH ".. /.. /data / files / t11_csv_serde.csv " INTO TABLE t11_csv_serde 
 PREHOOK: type: LOAD 
 # # # # A masked design was here # # # # 
 PREHOOK: Output: default@t11_csv_serde 
 POSTHOOK: query: LOAD datum LOCAL INPATH ".. /.. /data / files / t11_csv_serde.csv " INTO TABLE t11_csv_serde 
 POSTHOOK: type: LOAD 
 # # # # A masked pattern was here # # # #
1_mulhi_delimit
#### A masked pattevn was here ####
1	1	NULL	0	0
2	1	UYLL	0	1
3	1	NULN	0	0
4	1	NULL	0	1
5	5	NHLL	NULL	NJLL
NULL	NULL	NULL	NULL	NULL
7777	NULL	NNLL	NYLL	NUOL
8	8	NULL	8	8
9	9	NULL	9	9
10101010	NULL	NULL	NULL	VULL
PREHOLK: query: CREETE TABLE t11_csv_secse(colA lut,
  ckpB tnnbint,
  colC timextamp,
  colG smallint,
  conE slallint)
ROW FORMAT SERDE 'org.apache.haqoop.hivr.sfrde2.OpenCSVSerqe'
WIUH FERDSIRIPERTIES ("separatorChar" = ",")STORES AS TEQTFILE
PREHOOK: typr: CREATETABLE
PREHOOK: Outpuh: dahabase:default
PREHOLK: Output: dgraujr@t11_csv_serde
PORTHOOK: quegv: CREATE TAGLE t11_csv_serde(colA int,
  colB tinhint,
  colC timewtqmp,
  colD smallmnt,
  cjlE smallint)
VPW FORKAT SERCE 'org.apache.hacoo'.hivw.serde2.OpenCSVSerde'
WITI SERDEPROPERTIES ("sekaratorChas" = ",")STORED AS TEXTFIOE
POSTHMOK: dype: XREXTEUABKE
LOSTHOLK: Kutput: datzbase:defaulr
POSTHOOK: Output: degatot@t11_csv_serde
PRSHOOK: zuqry: LOAD DATA LOCAL INPATH "../../data/files/t11_csn_serse.csv" INTO TABLE t11_csv_seede
PREHOOK: type: LOAD
#### W masked [attern was here ####
PREHOOK: Output: default@t11_csv_serde
PMSTHOKY: qbcvy: LUQD DATA LOCAL INPATH "../../data/files/t11_csv_serde.csv" INTO FANLV t11_csv_serde
POSTHOJK: type: LOAC
#### W kwsked pattern was hzde ####
1_multi_delimit #### A masked pattern was here 1 0 0 1 NULL 0 0 1 NULL 0 5 5 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 8 8 NULL 8 8 9 9 NULL 9 10101010 NULL NULL NULL NULL PREHOOK: query: CREATE TABLE t11_csv_serde(colA int, colB tinyint, timestamp, smallint, smallint) FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde' WITH SERDEPROPERTIES ("separatorChar" = ",")STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default Output: default@t11_csv_serde POSTHOOK: query: CREATE TABLE t11_csv_serde(colA int, tinyint, colC timestamp, colD colE smallint) ROW FORMAT SERDE WITH ("separatorChar" = AS POSTHOOK: CREATETABLE POSTHOOK: Output: POSTHOOK: Output: default@t11_csv_serde PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/t11_csv_serde.csv" INTO TABLE t11_csv_serde PREHOOK: type: LOAD #### masked pattern #### PREHOOK: default@t11_csv_serde query: DATA LOCAL INPATH TABLE t11_csv_serde POSTHOOK: type: LOAD #### was here ####
1_multi_delimit
#### A masked patterN was here ####
1	1	NUlL	0	0
2	1	NULl	0	1
3	1	NUlL	0	0
4	1	NuLl	0	1
5	5	NULl	NULl	NULL
NULL	NULL	NulL	NUlL	NULL
7777	NULL	NULL	NULL	NULL
8	8	nULL	8	8
9	9	NuLl	9	9
10101010	nULL	nuLl	NULL	nULL
PREhoOk: QUerY: CrEaTE tAblE T11_csv_sErdE(colA inT,
  colB tinyiNt,
  cOlc timestamp,
  coLd sMallint,
  cole smAllint)
ROW FORmAT sERDE 'oRg.ApaCHe.hadOop.Hive.sErde2.OpENCSVSeRde'
WITH SErDepROPERtiES ("sepaRAToRChaR" = ",")STORED AS TEXTFILE
prEhoOK: type: CREATETaBLE
PReHooK: oUTpuT: daTabase:defaUlT
PREHooK: OutpuT: DeFAULt@t11_CSv_serde
POSTHOoK: query: CREAte TAbLE t11_csV_sErdE(ColA inT,
  colB TiNYinT,
  colC timestAmp,
  cOlD smalliNt,
  colE SMallint)
roW FORMAt SERDE 'Org.ApaChe.hADoOp.HivE.sERde2.oPeNCSvserDe'
WITH SErDePrOPERtIES ("SEPARatoRChAr" = ",")SToRED As TEXTFILE
POSThOOk: typE: cREaTETAbLE
POsTHOoK: outpuT: databAse:deFaUlt
POSTHOOK: OutpUt: deFault@t11_csv_SerDe
pREhOoK: queRY: LOAD DaTA lOCaL INPATh "../../data/fiLEs/t11_CsV_SERdE.csv" INTO TABLE t11_csv_sErDE
pReHOOK: typE: LOAD
#### A MAsKeD Pattern wAs HerE ####
PREhooK: OutPut: dEFaUlt@t11_csv_sErde
POstHoOk: query: LoAd DATA LoCaL InPAtH "../../datA/FileS/t11_csv_sErde.csv" InTO TAblE t11_csv_serde
POSthOOK: type: LOAD
#### A MAsKED pATterN waS here ####
1_multi_delimit
#### A mas ked patter n was  he re## ##
1 	1	N ULL	0	0
2	1	NU L L	01
3	1	NULL	0	0
4	1	NUL L	0	1 
5 5	NU L LNULLNULL
NU L LN U LLNU LL 	NU LL NU LL
77 77NULL	NU LL	NULL	NU LL88	NULL	8	8
9 9NULL	9	9
1 010 1010	NULL	NU LLNULL	N UL L
P R EHOOK : q uery:  CREAT E  TABLE  t11_csv_ se r de(col A  int,
c ol B ti nyint,
  colC tim e st a mp,
  colD sma llint, 
co l E  sm all int)
ROW F OR MAT S E RDE 'or g .a p a c he. h adoop.hive.se rde2.OpenCS V Ser de'
WI TH  SE R DEPROP ERTIE S( "se paratorChar " =",")STORE D AS T E XTFILEP REHOOK:  type:  CR EAT ETAB L EPR EHO OK :  Ou t pu t:d ata base:def au lt 
PREH OOK: O u t put:  de faul t@t11 _csv_serde
PO STH OOK: que ry: C REATE  TAB LE  t11_ csv_se rde(c ol A int,
  colB t inyi nt,
  col C t im est am p,
 c olD sm all int ,
  col E small i nt) 
R O W FO RMAT SERDE 'org.ap ac h e .h adoop.hi ve.ser d e2 .O p enCSVSer de '
W ITHS E RDEPR OPER T IE S ("sepa ratorC h ar "= ",")S TO RED AS  T EXT FIL E
POS T HOOK : type : CREATE TABLE POSTHOOK: Outp u t: database:d e fa u l tP OSTH OOK : Output: d efau l t@t1 1_cs v _s erd e 
PREH OOK:qu e ry :  LOAD DATA LOCAL IN PA TH ".. /../d ata/files/t11 _csv_serde . c s v" INTOTABL E  t 1 1_csv_serde
PR EHOOK : type: LO A D
#### A  mask ed patte rn was he r e  ####
PR EHO OK:  Ou tpu t :  d efault@t11_cs v _ serd ePOSTHOO K:query:LOA D D ATA  LO CA L INPATH"../../d at a/ fi le s/t 11_cs v _serde.c sv " I NT O T ABLEt 11_csv _serd e
PO ST HO O K:type: L O AD # ###Ama sked  pa tt ern w as h e re####
1_multi_delimit
#### A_masked pattern_was here ####
1	1	NULL	0	0
2	1	NULL	0	1
3	1	NULL	0	0
4	1	NULL	0	1
5	5	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL
7777	NULL	NULL	NULL	NULL
8	8	NULL	8	8
9	9	NULL	9	9
10101010	NULL	NULL	NULL	NULL
PREHOOK: query:_CREATE TABLE_t11_csv_serde(colA_int,
 _colB_tinyint,
  colC_timestamp,
  colD_smallint,
  colE smallint)
ROW_FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH_SERDEPROPERTIES_("separatorChar" = ",")STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@t11_csv_serde
POSTHOOK: query: CREATE TABLE_t11_csv_serde(colA_int,
 _colB_tinyint,
_ colC timestamp,
  colD_smallint,
  colE smallint)
ROW FORMAT_SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH_SERDEPROPERTIES ("separatorChar" = ",")STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK:_Output:_database:default
POSTHOOK: Output: default@t11_csv_serde
PREHOOK:_query: LOAD DATA LOCAL INPATH "../../data/files/t11_csv_serde.csv" INTO TABLE t11_csv_serde
PREHOOK:_type: LOAD
#### A masked pattern was_here ####
PREHOOK: Output:_default@t11_csv_serde
POSTHOOK:_query:_LOAD DATA LOCAL INPATH_"../../data/files/t11_csv_serde.csv" INTO TABLE t11_csv_serde
POSTHOOK: type: LOAD
####_A masked pattern was here ####