blob: 2edaefbd547f2fafd0f909eebde419e56de978a5 [file] [log] [blame]
set hive.vectorized.execution.enabled=false;
-- SORT_QUERY_RESULTS
CREATE TABLE parquet_ppd_multifiles (
name string,
`dec` decimal(5,0)
) stored as parquet;
insert into table parquet_ppd_multifiles values('Jim', 3);
insert into table parquet_ppd_multifiles values('Tom', 5);
set hive.optimize.index.filter=false;
select * from parquet_ppd_multifiles where (name = 'Jim' or `dec` = 5);
set hive.optimize.index.filter=true;
select * from parquet_ppd_multifiles where (name = 'Jim' or `dec` = 5);