ql/src/test/results/clientpositive/orc_min_max.q.out

PREHOOK: query: create table if not exists alltypes_n2 (
 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<string, string>,
 l array<int>,
 st struct<c1:int, c2:string>
) 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_n2
POSTHOOK: query: create table if not exists alltypes_n2 (
 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<string, string>,
 l array<int>,
 st struct<c1:int, c2:string>
) 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_n2
PREHOOK: query: create table alltypes_orc_n3 like alltypes_n2
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@alltypes_orc_n3
POSTHOOK: query: create table alltypes_orc_n3 like alltypes_n2
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypes_orc_n3
PREHOOK: query: alter table alltypes_orc_n3 set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
PREHOOK: Input: default@alltypes_orc_n3
PREHOOK: Output: default@alltypes_orc_n3
POSTHOOK: query: alter table alltypes_orc_n3 set fileformat orc
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@alltypes_orc_n3
POSTHOOK: Output: default@alltypes_orc_n3
PREHOOK: query: load data local inpath '../../data/files/alltypes2.txt' overwrite into table alltypes_n2
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@alltypes_n2
POSTHOOK: query: load data local inpath '../../data/files/alltypes2.txt' overwrite into table alltypes_n2
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@alltypes_n2
PREHOOK: query: insert overwrite table alltypes_orc_n3 select * from alltypes_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypes_n2
PREHOOK: Output: default@alltypes_orc_n3
POSTHOOK: query: insert overwrite table alltypes_orc_n3 select * from alltypes_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypes_n2
POSTHOOK: Output: default@alltypes_orc_n3
POSTHOOK: Lineage: alltypes_orc_n3.bi SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:bi, type:bigint, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.bo SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:bo, type:boolean, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.c SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:c, type:char(5), comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.d SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:d, type:double, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.da SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:da, type:date, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.de SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:de, type:decimal(10,3), comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.f SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:f, type:float, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.i SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:i, type:int, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.l SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:l, type:array<int>, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.m SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:m, type:map<string,string>, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.s SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:s, type:string, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.si SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:si, type:smallint, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.st SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:st, type:struct<c1:int,c2:string>, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.ti SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:ti, type:tinyint, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.ts SIMPLE [(alltypes_n2)alltypes_n2.FieldSchema(name:ts, type:timestamp, comment:null), ]
POSTHOOK: Lineage: alltypes_orc_n3.vc SIMPLE [(alltypes_n2)alltypes_n2.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_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypes_n2
#### 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_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypes_n2
#### 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_n3
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypes_orc_n3
#### 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_n3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypes_orc_n3
#### 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