-- SORT_QUERY_RESULTS;

set hive.vectorized.execution.enabled=false;
set hive.optimize.index.filter=true;
create table test_table_n6(number int) stored as ORC;

-- Two insertions will create two files, with one stripe each
insert into table test_table_n6 VALUES (1);
insert into table test_table_n6 VALUES (2);

-- This should return 2 records
select * from test_table_n6;

-- These should each return 1 record
select * from test_table_n6 where number = 1;
select * from test_table_n6 where number = 2;

-- This should return 2 records
select * from test_table_n6 where number = 1 union all select * from test_table_n6 where number = 2;