set datanucleus.cache.collections=false;
set hive.stats.autogather=false;
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.merge.mapfiles=false;

create table analyze_t1 like srcpart;


explain
insert overwrite table analyze_t1 partition (ds, hr) select * from srcpart where ds is not null;

insert overwrite table analyze_t1 partition (ds, hr) select * from srcpart where ds is not null;

desc formatted analyze_t1;

explain analyze table analyze_t1 partition (ds, hr) compute statistics;

analyze table analyze_t1 partition (ds, hr) compute statistics;

describe formatted analyze_t1;