PREHOOK: query: -- SORT_QUERY_RESULTS create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@orc_split_elim POSTHOOK: query: -- SORT_QUERY_RESULTS create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_split_elim PREHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_split_elim PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@orc_split_elim POSTHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_split_elim POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@orc_split_elim PREHOOK: query: -- The above table will have 5 splits with the followings stats -- Stripe 1: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 2 max: 100 sum: 499902 -- Column 2: count: 5000 min: foo max: zebra sum: 24998 -- Column 3: count: 5000 min: 0.8 max: 8.0 sum: 39992.8 -- Column 4: count: 5000 min: 0 max: 1.2 sum: 1.2 -- Column 5: count: 5000 -- Stripe 2: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 13 max: 100 sum: 499913 -- Column 2: count: 5000 min: bar max: zebra sum: 24998 -- Column 3: count: 5000 min: 8.0 max: 80.0 sum: 40072.0 -- Column 4: count: 5000 min: 0 max: 2.2 sum: 2.2 -- Column 5: count: 5000 -- Stripe 3: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 29 max: 100 sum: 499929 -- Column 2: count: 5000 min: cat max: zebra sum: 24998 -- Column 3: count: 5000 min: 8.0 max: 8.0 sum: 40000.0 -- Column 4: count: 5000 min: 0 max: 3.3 sum: 3.3 -- Column 5: count: 5000 -- Stripe 4: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 70 max: 100 sum: 499970 -- Column 2: count: 5000 min: dog max: zebra sum: 24998 -- Column 3: count: 5000 min: 1.8 max: 8.0 sum: 39993.8 -- Column 4: count: 5000 min: 0 max: 4.4 sum: 4.4 -- Column 5: count: 5000 -- Stripe 5: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 5 max: 100 sum: 499905 -- Column 2: count: 5000 min: eat max: zebra sum: 24998 -- Column 3: count: 5000 min: 0.8 max: 8.0 sum: 39992.8 -- Column 4: count: 5000 min: 0 max: 5.5 sum: 5.5 -- Column 5: count: 5000 -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=0 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- The above table will have 5 splits with the followings stats -- Stripe 1: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 2 max: 100 sum: 499902 -- Column 2: count: 5000 min: foo max: zebra sum: 24998 -- Column 3: count: 5000 min: 0.8 max: 8.0 sum: 39992.8 -- Column 4: count: 5000 min: 0 max: 1.2 sum: 1.2 -- Column 5: count: 5000 -- Stripe 2: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 13 max: 100 sum: 499913 -- Column 2: count: 5000 min: bar max: zebra sum: 24998 -- Column 3: count: 5000 min: 8.0 max: 80.0 sum: 40072.0 -- Column 4: count: 5000 min: 0 max: 2.2 sum: 2.2 -- Column 5: count: 5000 -- Stripe 3: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 29 max: 100 sum: 499929 -- Column 2: count: 5000 min: cat max: zebra sum: 24998 -- Column 3: count: 5000 min: 8.0 max: 8.0 sum: 40000.0 -- Column 4: count: 5000 min: 0 max: 3.3 sum: 3.3 -- Column 5: count: 5000 -- Stripe 4: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 70 max: 100 sum: 499970 -- Column 2: count: 5000 min: dog max: zebra sum: 24998 -- Column 3: count: 5000 min: 1.8 max: 8.0 sum: 39993.8 -- Column 4: count: 5000 min: 0 max: 4.4 sum: 4.4 -- Column 5: count: 5000 -- Stripe 5: -- Column 0: count: 5000 -- Column 1: count: 5000 min: 5 max: 100 sum: 499905 -- Column 2: count: 5000 min: eat max: zebra sum: 24998 -- Column 3: count: 5000 min: 0.8 max: 8.0 sum: 39992.8 -- Column 4: count: 5000 min: 0 max: 5.5 sum: 5.5 -- Column 5: count: 5000 -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=0 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### PREHOOK: query: -- 0 mapper select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=0 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 0 mapper select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=0 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### PREHOOK: query: -- 5 mappers. count should be 0 select count(*) from orc_split_elim where userid<=0 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers. count should be 0 select count(*) from orc_split_elim where userid<=0 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 0 PREHOOK: query: -- 0 mapper select count(*) from orc_split_elim where userid<=0 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 0 mapper select count(*) from orc_split_elim where userid<=0 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 0 PREHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 1 mapper select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 1 mapper select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 2 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 2 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 3 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 3 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 4 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 4 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 5 eat 0.8 6 1969-12-31 16:00:20 70 dog 1.8 4 1969-12-31 16:00:15 PREHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 5 eat 0.8 6 1969-12-31 16:00:20 70 dog 1.8 4 1969-12-31 16:00:15 PREHOOK: query: -- partitioned table create table orc_split_elim_part (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (country string, year int) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@orc_split_elim_part POSTHOOK: query: -- partitioned table create table orc_split_elim_part (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (country string, year int) stored as orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_split_elim_part PREHOOK: query: alter table orc_split_elim_part add partition(country='us', year=2000) PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Output: default@orc_split_elim_part POSTHOOK: query: alter table orc_split_elim_part add partition(country='us', year=2000) POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Output: default@orc_split_elim_part POSTHOOK: Output: default@orc_split_elim_part@country=us/year=2000 PREHOOK: query: alter table orc_split_elim_part add partition(country='us', year=2001) PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Output: default@orc_split_elim_part POSTHOOK: query: alter table orc_split_elim_part add partition(country='us', year=2001) POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Output: default@orc_split_elim_part POSTHOOK: Output: default@orc_split_elim_part@country=us/year=2001 PREHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_split_elim_part partition(country='us', year=2000) PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_split_elim_part partition(country='us', year=2000) POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@orc_split_elim_part@country=us/year=2000 PREHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_split_elim_part partition(country='us', year=2001) PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@orc_split_elim_part@country=us/year=2001 POSTHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_split_elim_part partition(country='us', year=2001) POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@orc_split_elim_part@country=us/year=2001 PREHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 2 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 2 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 2 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 2 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 1 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 1 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 4 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 4 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 4 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 4 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 2 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 2 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 0 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### POSTHOOK: query: -- 0 mapper - no split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### PREHOOK: query: -- 0 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### POSTHOOK: query: -- 0 mapper - split elimination select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here ####