hive-testbench/ddl-tpcds/bin_partitioned/analyze_time_dim.sql.sql

-- Use filesystem to track stats.
set hive.stats.dbclass=fs;
-- Many tables have some missing partitions, deal with this by ignoring errors.
set hive.cli.errors.ignore=true;

ANALYZE TABLE time_dim COMPUTE STATISTICS;
ANALYZE TABLE time_dim COMPUTE STATISTICS FOR COLUMNS 
	t_time_sk, t_time_id, t_time, t_hour, t_minute, t_second,
	t_am_pm, t_shift, t_sub_shift, t_meal_time;