--! qt:dataset:src
set hive.stats.column.autogather=false;
set hive.stats.fetch.column.stats=true;
set hive.exec.dynamic.partition=true;
set hive.auto.convert.join=true;
set hive.join.emit.interval=2;
set hive.auto.convert.join.noconditionaltask=true;
set hive.auto.convert.join.noconditionaltask.size=10000;
set hive.auto.convert.sortmerge.join.bigtable.selection.policy = org.apache.hadoop.hive.ql.optimizer.TableSizeBasedBigTableSelectorForAutoSMJ;
set hive.optimize.bucketingsorting=false;

drop table src_multi1_n6;

create table src_multi1_n6 like src;

analyze table src_multi1_n6 compute statistics for columns key;

describe formatted src_multi1_n6;

set hive.stats.column.autogather=true;

insert into table src_multi1_n6 select * from src;

describe formatted src_multi1_n6;


set hive.stats.column.autogather=false;

drop table nzhang_part14_n2;

create table if not exists nzhang_part14_n2 (key string, value string)
  partitioned by (ds string, hr string);

describe formatted nzhang_part14_n2;

insert into table nzhang_part14_n2 partition(ds, hr) 
select key, value, ds, hr from (
  select * from (select 'k1' as key, cast(null as string) as value, '1' as ds, '2' as hr from src limit 2)a 
  union all
  select * from (select 'k2' as key, '' as value, '1' as ds, '3' as hr from src limit 2)b
  union all 
  select * from (select 'k3' as key, ' ' as value, '2' as ds, '1' as hr from src limit 2)c
) T;

desc formatted nzhang_part14_n2 partition(ds='1', hr='3');

analyze table nzhang_part14_n2 partition(ds='1', hr='3') compute statistics for columns value;

desc formatted nzhang_part14_n2 partition(ds='1', hr='3');

desc formatted nzhang_part14_n2 partition(ds='2', hr='1');

set hive.stats.column.autogather=true;

insert into table nzhang_part14_n2 partition(ds, hr)
select key, value, ds, hr from (
  select * from (select 'k1' as key, cast(null as string) as value, '1' as ds, '2' as hr from src limit 2)a
  union all
  select * from (select 'k2' as key, '' as value, '1' as ds, '3' as hr from src limit 2)b
  union all
  select * from (select 'k3' as key, ' ' as value, '2' as ds, '1' as hr from src limit 2)c
) T;

desc formatted nzhang_part14_n2 partition(ds='1', hr='3');

desc formatted nzhang_part14_n2 partition(ds='2', hr='1');