hive-testbench/ddl-tpcds/bin_partitioned/analyze_call_center.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 call_center COMPUTE STATISTICS;
ANALYZE TABLE call_center COMPUTE STATISTICS FOR COLUMNS 
	cc_call_center_sk, cc_call_center_id, cc_rec_start_date,
	cc_rec_end_date, cc_closed_date_sk, cc_open_date_sk, cc_name,
	cc_class, cc_employees, cc_sq_ft, cc_hours, cc_manager,
	cc_mkt_id, cc_mkt_class, cc_mkt_desc, cc_market_manager,
	cc_division, cc_division_name, cc_company, cc_company_name,
	cc_street_number, cc_street_name, cc_street_type,
	cc_suite_number, cc_city, cc_county, cc_state, cc_zip,
	cc_country, cc_gmt_offset, cc_tax_percentage;