create table over1k_n4(
t tinyint,
si smallint,
i int,
b bigint,
f float,
d double,
bo boolean,
s string,
ts timestamp,
`dec` decimal(4,2),
bin binary)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
STORED AS TEXTFILE;

load data local inpath '../../data/files/over1k' overwrite into table over1k_n4;
load data local inpath '../../data/files/over1k' into table over1k_n4;

analyze table over1k_n4 compute statistics;
analyze table over1k_n4 compute statistics for columns;

set hive.stats.fetch.column.stats=true;
set hive.optimize.point.lookup=false;
explain select count(*) from over1k_n4 where (
(t=1 and si=2)
or (t=2 and si=3)
or (t=3 and si=4) 
or (t=4 and si=5) 
or (t=5 and si=6) 
or (t=6 and si=7) 
or (t=7 and si=8)
or (t=9 and si=10)
or (t=10 and si=11)
or (t=11 and si=12)
or (t=12 and si=13)
or (t=13 and si=14) 
or (t=14 and si=15) 
or (t=15 and si=16) 
or (t=16 and si=17) 
or (t=17 and si=18)
or (t=27 and si=28)
or (t=37 and si=38)
or (t=47 and si=48)
or (t=52 and si=53));

set hive.stats.fetch.column.stats=false;
explain select count(*) from over1k_n4 where (
(t=1 and si=2)
or (t=2 and si=3)
or (t=3 and si=4) 
or (t=4 and si=5) 
or (t=5 and si=6) 
or (t=6 and si=7) 
or (t=7 and si=8)
or (t=9 and si=10)
or (t=10 and si=11)
or (t=11 and si=12)
or (t=12 and si=13)
or (t=13 and si=14) 
or (t=14 and si=15) 
or (t=15 and si=16) 
or (t=16 and si=17) 
or (t=17 and si=18)
or (t=27 and si=28)
or (t=37 and si=38)
or (t=47 and si=48)
or (t=52 and si=53));