Hive - Table-Level Statistics (Table/Partition/Column)

> Database > Apache - Hive (HS|Hive Server)

1 - About

Statistics on the data of a table.

Statistics are stored in the Hive Metastore

Advertising

3 - Management

3.1 - Conf

SET hive.stats.autogather=TRUE;
ANALYZE TABLE [db_name.]tablename [PARTITION(partcol1[=val1], partcol2[=val2], ...)]  -- (Note: Fully support qualified table name since Hive 1.2.0, see HIVE-10007.)
  COMPUTE STATISTICS 
  [FOR COLUMNS]          -- (Note: Hive 0.10.0 and later.)
  [CACHE METADATA]       -- (Note: Hive 2.1.0 and later.)
  [NOSCAN];

4 - Documentation / Reference

db/hive/stat.txt · Last modified: 2018/05/28 17:48 by gerardnico