set hive.vectorized.execution.enabled=false;
set hive.fetch.task.conversion=none;

drop table orc_decimal;
drop table staging_n1;
create table orc_decimal (id decimal(18,0)) stored as orc;

create table staging_n1 (id decimal(18,0));

insert into staging_n1 values (34324.0), (100000000.0), (200000000.0), (300000000.0);

insert overwrite table orc_decimal select id from staging_n1;

set hive.vectorized.execution.enabled=true;

explain vectorization expression
select * from orc_decimal where id in ('100000000', '200000000');
select * from orc_decimal where id in ('100000000', '200000000');

drop table orc_decimal;
drop table staging_n1;