ql/src/test/queries/clientpositive/vectorization_parquet_ppd_decimal.q

--! qt:dataset:src1
--! qt:dataset:src
set hive.vectorized.execution.enabled=true;
set hive.test.vectorized.execution.enabled.override=enable;
set hive.strict.checks.type.safety=false;

SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
SET mapred.min.split.size=1000;
SET mapred.max.split.size=5000;
set hive.llap.cache.allow.synthetic.fileid=true;

create table newtypestbl_n1(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet;

insert overwrite table newtypestbl_n1
select *
  from (select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 limit 5) u1
        union all
        select * from (select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 5) u2
       ) uniontbl;

-- decimal data types (EQUAL, NOT_EQUAL, LESS_THAN, LESS_THAN_EQUALS, IN, BETWEEN tests)
select * from newtypestbl_n1 where d=0.22;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d=0.22;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d='0.22';

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d='0.22';

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d=cast('0.22' as float);

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d=cast('0.22' as float);

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d!=0.22;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d!=0.22;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d!='0.22';

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d!='0.22';

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d!=cast('0.22' as float);

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d!=cast('0.22' as float);

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<11.22;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<11.22;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<'11.22';

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<'11.22';

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<cast('11.22' as float);

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<cast('11.22' as float);

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<1;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<1;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<=11.22 sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<=11.22 sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<='11.22' sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<='11.22' sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<=cast('11.22' as float) sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<=cast('11.22' as float) sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<=cast('11.22' as decimal);

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<=cast('11.22' as decimal);

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<=11.22BD sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<=11.22BD sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d<=12 sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d<=12 sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in ('0.22', '1.0');

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in ('0.22', '1.0');

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in ('0.22', '11.22') sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in ('0.22', '11.22') sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in ('0.9', '1.0');

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in ('0.9', '1.0');

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in ('0.9', 0.22);

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in ('0.9', 0.22);

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in (0.9, 0.22, 11.22) sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in (0.9, 0.22, 11.22) sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in ('0.9', '0.22', '11.22') sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in ('0.9', '0.22', '11.22') sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d in (cast('0.9' as float), cast('0.22' as float), cast('11.22' as float)) sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d in (cast('0.9' as float), cast('0.22' as float), cast('11.22' as float)) sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d between 0 and 1;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d between 0 and 1;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d between 0 and 1000 sort by c;

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d between 0 and 1000 sort by c;

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d between 0 and '2.0';

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d between 0 and '2.0';

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d between 0 and cast(3 as float);

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d between 0 and cast(3 as float);

set hive.optimize.index.filter=false;
select * from newtypestbl_n1 where d between 1 and cast(30 as char(10));

set hive.optimize.index.filter=true;
select * from newtypestbl_n1 where d between 1 and cast(30 as char(10));