ql/src/test/results/clientpositive/llap/orc_ppd_schema_evol_2b.q.out

PREHOOK: query: create table unique_1( 
i int, 
d string, 
s string) 
row format delimited 
fields terminated by '|' 
stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@unique_1
POSTHOOK: query: create table unique_1( 
i int, 
d string, 
s string) 
row format delimited 
fields terminated by '|' 
stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@unique_1
PREHOOK: query: load data local inpath '../../data/files/unique_1.txt' into table unique_1
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@unique_1
POSTHOOK: query: load data local inpath '../../data/files/unique_1.txt' into table unique_1
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@unique_1
PREHOOK: query: create table unique_2( 
i int, 
d string, 
s string)
row format delimited 
fields terminated by '|' 
stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@unique_2
POSTHOOK: query: create table unique_2( 
i int, 
d string, 
s string)
row format delimited 
fields terminated by '|' 
stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@unique_2
PREHOOK: query: load data local inpath '../../data/files/unique_2.txt' into table unique_2
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@unique_2
POSTHOOK: query: load data local inpath '../../data/files/unique_2.txt' into table unique_2
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@unique_2
PREHOOK: query: create table test_two_files( 
i int, 
d string, 
s string)
stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@test_two_files
POSTHOOK: query: create table test_two_files( 
i int, 
d string, 
s string)
stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_two_files
PREHOOK: query: insert into table test_two_files select * from unique_1 where cast(d as double) <= 0 order by cast(d as double)
PREHOOK: type: QUERY
PREHOOK: Input: default@unique_1
PREHOOK: Output: default@test_two_files
POSTHOOK: query: insert into table test_two_files select * from unique_1 where cast(d as double) <= 0 order by cast(d as double)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@unique_1
POSTHOOK: Output: default@test_two_files
POSTHOOK: Lineage: test_two_files.d SIMPLE [(unique_1)unique_1.FieldSchema(name:d, type:string, comment:null), ]
POSTHOOK: Lineage: test_two_files.i SIMPLE [(unique_1)unique_1.FieldSchema(name:i, type:int, comment:null), ]
POSTHOOK: Lineage: test_two_files.s SIMPLE [(unique_1)unique_1.FieldSchema(name:s, type:string, comment:null), ]
unique_1.i	unique_1.d	unique_1.s
PREHOOK: query: insert into table test_two_files select * from unique_2 where cast(d as double) > 0 order by cast(d as double)
PREHOOK: type: QUERY
PREHOOK: Input: default@unique_2
PREHOOK: Output: default@test_two_files
POSTHOOK: query: insert into table test_two_files select * from unique_2 where cast(d as double) > 0 order by cast(d as double)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@unique_2
POSTHOOK: Output: default@test_two_files
POSTHOOK: Lineage: test_two_files.d SIMPLE [(unique_2)unique_2.FieldSchema(name:d, type:string, comment:null), ]
POSTHOOK: Lineage: test_two_files.i SIMPLE [(unique_2)unique_2.FieldSchema(name:i, type:int, comment:null), ]
POSTHOOK: Lineage: test_two_files.s SIMPLE [(unique_2)unique_2.FieldSchema(name:s, type:string, comment:null), ]
unique_2.i	unique_2.d	unique_2.s
PREHOOK: query: alter table test_two_files change column d d double
PREHOOK: type: ALTERTABLE_RENAMECOL
PREHOOK: Input: default@test_two_files
PREHOOK: Output: default@test_two_files
PREHOOK: query: select s from test_two_files where d = -4996703.42
PREHOOK: type: QUERY
PREHOOK: Input: default@test_two_files
#### A masked pattern was here ####
s
luke quirinius
PREHOOK: query: select s from test_two_files where d = -4996703.42
PREHOOK: type: QUERY
PREHOOK: Input: default@test_two_files
#### A masked pattern was here ####
s
luke quirinius
PREHOOK: query: select s from test_two_files where d = -4996703.42
PREHOOK: type: QUERY
PREHOOK: Input: default@test_two_files
#### A masked pattern was here ####
s
luke quirinius
PREHOOK: query: select s from test_two_files where d = -4996703.42
PREHOOK: type: QUERY
PREHOOK: Input: default@test_two_files
#### A masked pattern was here ####
s
luke quirinius