-- Test multi inserting to the same partition

create table source(p int, key int,value string);
insert into source(p, key, value) values (101,42,'string42');

create table stats_part(key int,value string) partitioned by (p int);

from source
insert into stats_part select key, value, p
insert into stats_part select key, value, p;

select p, key, value from stats_part;
desc formatted stats_part;

set hive.compute.query.using.stats=true;
select count(*) from stats_part;

set hive.compute.query.using.stats=false;
select count(*) from stats_part;