Page History

...

See Statistics in Hive for information about how to collect and use Hive table, partition, and column statistics. 

hive.stats.dbclass

• Default Value: jdbc:derby (Hive 0.7 to 0.12) or fs (Hive 0.13 and later)
• Added In: Hive 0.7 with HIVE-1361
• New Values: counter and custom added in 0.13 with HIVE-4632 and fs added in 0.13 with HIVE-6500

Hive 0.7 to 0.12:  The default database that stores temporary Hive statistics.  Other options are  Options are jdbc:derby, jdbc:mysql, and hbase as defined in StatsSetupConst.java.

Hive 0.13 and later:  The storage that stores temporary Hive statistics. In FS filesystem based statistics collection ("fs"), each task writes statistics it has collected in a file on the filesystem, which will be aggregated after the job has finished. Supported values are fs (filesystem), jdbc(:.*<database>), hbase, counter, and custom (HIVE-6500) as defined in StatsSetupConst.java.

hive.stats.autogather

• Default Value: true
• Added In: Hive 0.7 with HIVE-1361

...