analyze_ship_mode.sql.sql 355 B

12345678910
  1. -- Use filesystem to track stats.
  2. set hive.stats.dbclass=fs;
  3. -- Many tables have some missing partitions, deal with this by ignoring errors.
  4. set hive.cli.errors.ignore=true;
  5. ANALYZE TABLE ship_mode COMPUTE STATISTICS;
  6. ANALYZE TABLE ship_mode COMPUTE STATISTICS FOR COLUMNS
  7. sm_ship_mode_sk, sm_ship_mode_id, sm_type, sm_code, sm_carrier,
  8. sm_contract;