set datanucleus.cache.collections=false; set hive.stats.autogather=true; set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict; -- test analyze table ... compute statistics partialscan create table analyze_srcpart_partial_scan like srcpart; insert overwrite table analyze_srcpart_partial_scan partition (ds, hr) select * from srcpart where ds is not null; analyze table analyze_srcpart_partial_scan PARTITION(ds='2008-04-08',hr=11) compute statistics partialscan;