ql/src/test/queries/clientpositive/statsfs.q

--! qt:dataset:srcpart
--! qt:dataset:src
set hive.stats.dbclass=fs;

-- stats computation on partitioned table with analyze command

create table t1_n120 (key string, value string) partitioned by (ds string);
load data local inpath '../../data/files/kv1.txt' into table t1_n120 partition (ds = '2010');
load data local inpath '../../data/files/kv1.txt' into table t1_n120 partition (ds = '2011');

analyze table t1_n120 partition (ds) compute statistics;

describe formatted t1_n120 partition (ds='2010');
describe formatted t1_n120 partition (ds='2011');

drop table t1_n120;

-- stats computation on partitioned table with autogather on insert query

create table t1_n120 (key string, value string) partitioned by (ds string);

insert into table t1_n120 partition (ds='2010') select * from src;
insert into table t1_n120 partition (ds='2011') select * from src;

describe formatted t1_n120 partition (ds='2010');
describe formatted t1_n120 partition (ds='2011');

drop table t1_n120;

-- analyze stmt on unpartitioned table

create table t1_n120 (key string, value string); 
load data local inpath '../../data/files/kv1.txt' into table t1_n120; 

analyze table t1_n120 compute statistics;

describe formatted t1_n120 ;

drop table t1_n120;

-- stats computation on unpartitioned table with autogather on insert query

create table t1_n120 (key string, value string); 

insert into table t1_n120  select * from src;

describe formatted t1_n120 ;

drop table t1_n120;

-- stats computation on partitioned table with autogather on insert query with dynamic partitioning


create table t1_n120 (key string, value string) partitioned by (ds string, hr string);

insert into table t1_n120 partition (ds,hr) select * from srcpart;

describe formatted t1_n120 partition (ds='2008-04-08',hr='11');
describe formatted t1_n120 partition (ds='2008-04-09',hr='12');

drop table t1_n120;
set hive.exec.dynamic.partition.mode=strict;