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

PREHOOK: query: create table ppr_test (key string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@ppr_test
POSTHOOK: query: create table ppr_test (key string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@ppr_test
PREHOOK: query: insert overwrite table ppr_test partition(ds='2') select '2' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test@ds=2
POSTHOOK: query: insert overwrite table ppr_test partition(ds='2') select '2' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test@ds=2
POSTHOOK: Lineage: ppr_test PARTITION(ds=2).key SIMPLE []
PREHOOK: query: insert overwrite table ppr_test partition(ds='22') select '22' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test@ds=22
POSTHOOK: query: insert overwrite table ppr_test partition(ds='22') select '22' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test@ds=22
POSTHOOK: Lineage: ppr_test PARTITION(ds=22).key SIMPLE []
PREHOOK: query: select * from ppr_test where ds = '2'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test
PREHOOK: Input: default@ppr_test@ds=2
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test where ds = '2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test
POSTHOOK: Input: default@ppr_test@ds=2
#### A masked pattern was here ####
2	2
PREHOOK: query: select * from ppr_test where ds = '22'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test
PREHOOK: Input: default@ppr_test@ds=22
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test where ds = '22'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test
POSTHOOK: Input: default@ppr_test@ds=22
#### A masked pattern was here ####
22	22
PREHOOK: query: create table ppr_test2 (key string) partitioned by (ds string, s string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@ppr_test2
POSTHOOK: query: create table ppr_test2 (key string) partitioned by (ds string, s string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@ppr_test2
PREHOOK: query: insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test2@ds=1/s=2
POSTHOOK: query: insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test2@ds=1/s=2
POSTHOOK: Lineage: ppr_test2 PARTITION(ds=1,s=2).key SIMPLE []
PREHOOK: query: insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test2@ds=2/s=1
POSTHOOK: query: insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test2@ds=2/s=1
POSTHOOK: Lineage: ppr_test2 PARTITION(ds=2,s=1).key SIMPLE []
PREHOOK: query: select * from ppr_test2 where s = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test2
PREHOOK: Input: default@ppr_test2@ds=2/s=1
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test2 where s = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test2
POSTHOOK: Input: default@ppr_test2@ds=2/s=1
#### A masked pattern was here ####
2	2	1
PREHOOK: query: select * from ppr_test2 where ds = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test2
PREHOOK: Input: default@ppr_test2@ds=1/s=2
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test2 where ds = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test2
POSTHOOK: Input: default@ppr_test2@ds=1/s=2
#### A masked pattern was here ####
1	1	2
PREHOOK: query: create table ppr_test3 (key string) partitioned by (col string, ol string, l string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@ppr_test3
POSTHOOK: query: create table ppr_test3 (key string) partitioned by (col string, ol string, l string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@ppr_test3
PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test3@col=1/ol=2/l=3
POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test3@col=1/ol=2/l=3
POSTHOOK: Lineage: ppr_test3 PARTITION(col=1,ol=2,l=3).key SIMPLE []
PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test3@col=1/ol=1/l=2
POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test3@col=1/ol=1/l=2
POSTHOOK: Lineage: ppr_test3 PARTITION(col=1,ol=1,l=2).key SIMPLE []
PREHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@ppr_test3@col=1/ol=2/l=1
POSTHOOK: query: insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@ppr_test3@col=1/ol=2/l=1
POSTHOOK: Lineage: ppr_test3 PARTITION(col=1,ol=2,l=1).key SIMPLE []
PREHOOK: query: select * from ppr_test3 where l = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where l = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
#### A masked pattern was here ####
3	1	2	1
PREHOOK: query: select * from ppr_test3 where l = '2'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=1/l=2
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where l = '2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=1/l=2
#### A masked pattern was here ####
2	1	1	2
PREHOOK: query: select * from ppr_test3 where ol = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=1/l=2
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where ol = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=1/l=2
#### A masked pattern was here ####
2	1	1	2
PREHOOK: query: select * from ppr_test3 where ol = '2'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=3
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where ol = '2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=3
#### A masked pattern was here ####
3	1	2	1
1	1	2	3
PREHOOK: query: select * from ppr_test3 where col = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=1/l=2
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=3
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where col = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=1/l=2
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=3
#### A masked pattern was here ####
2	1	1	2
3	1	2	1
1	1	2	3
PREHOOK: query: select * from ppr_test3 where ol = '2' and l = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where ol = '2' and l = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
#### A masked pattern was here ####
3	1	2	1
PREHOOK: query: select * from ppr_test3 where col='1' and ol = '2' and l = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@ppr_test3
PREHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
#### A masked pattern was here ####
POSTHOOK: query: select * from ppr_test3 where col='1' and ol = '2' and l = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@ppr_test3
POSTHOOK: Input: default@ppr_test3@col=1/ol=2/l=1
#### A masked pattern was here ####
3	1	2	1