PREHOOK: query: create table if not exists alltypes ( bo boolean, ti tinyint, si smallint, i int, bi bigint, f float, d double, de decimal(10,3), ts timestamp, da date, s string, c char(5), vc varchar(5), m map, l array, st struct ) row format delimited fields terminated by '|' collection items terminated by ',' map keys terminated by ':' stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@alltypes POSTHOOK: query: create table if not exists alltypes ( bo boolean, ti tinyint, si smallint, i int, bi bigint, f float, d double, de decimal(10,3), ts timestamp, da date, s string, c char(5), vc varchar(5), m map, l array, st struct ) row format delimited fields terminated by '|' collection items terminated by ',' map keys terminated by ':' stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@alltypes PREHOOK: query: create table alltypes_orc like alltypes PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@alltypes_orc POSTHOOK: query: create table alltypes_orc like alltypes POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@alltypes_orc PREHOOK: query: alter table alltypes_orc set fileformat orc PREHOOK: type: ALTERTABLE_FILEFORMAT PREHOOK: Input: default@alltypes_orc PREHOOK: Output: default@alltypes_orc POSTHOOK: query: alter table alltypes_orc set fileformat orc POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@alltypes_orc POSTHOOK: Output: default@alltypes_orc PREHOOK: query: load data local inpath '../../data/files/alltypes2.txt' overwrite into table alltypes PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@alltypes POSTHOOK: query: load data local inpath '../../data/files/alltypes2.txt' overwrite into table alltypes POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@alltypes PREHOOK: query: insert overwrite table alltypes_orc select * from alltypes PREHOOK: type: QUERY PREHOOK: Input: default@alltypes PREHOOK: Output: default@alltypes_orc POSTHOOK: query: insert overwrite table alltypes_orc select * from alltypes POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypes POSTHOOK: Output: default@alltypes_orc POSTHOOK: Lineage: alltypes_orc.bi SIMPLE [(alltypes)alltypes.FieldSchema(name:bi, type:bigint, comment:null), ] POSTHOOK: Lineage: alltypes_orc.bo SIMPLE [(alltypes)alltypes.FieldSchema(name:bo, type:boolean, comment:null), ] POSTHOOK: Lineage: alltypes_orc.c SIMPLE [(alltypes)alltypes.FieldSchema(name:c, type:char(5), comment:null), ] POSTHOOK: Lineage: alltypes_orc.d SIMPLE [(alltypes)alltypes.FieldSchema(name:d, type:double, comment:null), ] POSTHOOK: Lineage: alltypes_orc.da SIMPLE [(alltypes)alltypes.FieldSchema(name:da, type:date, comment:null), ] POSTHOOK: Lineage: alltypes_orc.de SIMPLE [(alltypes)alltypes.FieldSchema(name:de, type:decimal(10,3), comment:null), ] POSTHOOK: Lineage: alltypes_orc.f SIMPLE [(alltypes)alltypes.FieldSchema(name:f, type:float, comment:null), ] POSTHOOK: Lineage: alltypes_orc.i SIMPLE [(alltypes)alltypes.FieldSchema(name:i, type:int, comment:null), ] POSTHOOK: Lineage: alltypes_orc.l SIMPLE [(alltypes)alltypes.FieldSchema(name:l, type:array, comment:null), ] POSTHOOK: Lineage: alltypes_orc.m SIMPLE [(alltypes)alltypes.FieldSchema(name:m, type:map, comment:null), ] POSTHOOK: Lineage: alltypes_orc.s SIMPLE [(alltypes)alltypes.FieldSchema(name:s, type:string, comment:null), ] POSTHOOK: Lineage: alltypes_orc.si SIMPLE [(alltypes)alltypes.FieldSchema(name:si, type:smallint, comment:null), ] POSTHOOK: Lineage: alltypes_orc.st SIMPLE [(alltypes)alltypes.FieldSchema(name:st, type:struct, comment:null), ] POSTHOOK: Lineage: alltypes_orc.ti SIMPLE [(alltypes)alltypes.FieldSchema(name:ti, type:tinyint, comment:null), ] POSTHOOK: Lineage: alltypes_orc.ts SIMPLE [(alltypes)alltypes.FieldSchema(name:ts, type:timestamp, comment:null), ] POSTHOOK: Lineage: alltypes_orc.vc SIMPLE [(alltypes)alltypes.FieldSchema(name:vc, type:varchar(5), comment:null), ] PREHOOK: query: select min(bo), max(bo), min(ti), max(ti), min(si), max(si), min(i), max(i), min(bi), max(bi), min(f), max(f), min(d), max(d), min(de), max(de), min(ts), max(ts), min(da), max(da), min(s), max(s), min(c), max(c), min(vc), max(vc) from alltypes PREHOOK: type: QUERY PREHOOK: Input: default@alltypes #### A masked pattern was here #### POSTHOOK: query: select min(bo), max(bo), min(ti), max(ti), min(si), max(si), min(i), max(i), min(bi), max(bi), min(f), max(f), min(d), max(d), min(de), max(de), min(ts), max(ts), min(da), max(da), min(s), max(s), min(c), max(c), min(vc), max(vc) from alltypes POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypes #### A masked pattern was here #### false true 10 20 100 200 1000 2000 10000 20000 4.0 8.0 20.0 40.0 2.222 4.222 1969-12-31 15:59:58.174 1970-12-31 15:59:58.174 1970-01-01 1971-01-01 abcd string hello world hello world PREHOOK: query: select min(bo), max(bo), min(ti), max(ti), min(si), max(si), min(i), max(i), min(bi), max(bi), min(f), max(f), min(d), max(d), min(de), max(de), min(ts), max(ts), min(da), max(da), min(s), max(s), min(c), max(c), min(vc), max(vc) from alltypes_orc PREHOOK: type: QUERY PREHOOK: Input: default@alltypes_orc #### A masked pattern was here #### POSTHOOK: query: select min(bo), max(bo), min(ti), max(ti), min(si), max(si), min(i), max(i), min(bi), max(bi), min(f), max(f), min(d), max(d), min(de), max(de), min(ts), max(ts), min(da), max(da), min(s), max(s), min(c), max(c), min(vc), max(vc) from alltypes_orc POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypes_orc #### A masked pattern was here #### false true 10 20 100 200 1000 2000 10000 20000 4.0 8.0 20.0 40.0 2.222 4.222 1969-12-31 15:59:58.174 1970-12-31 15:59:58.174 1970-01-01 1971-01-01 abcd string hello world hello world