Page History

...

• Default Value: jdbc:derby (Hive 0.7 to 0.12) or counter fs (Hive 0.13 and later)
• Added In: Hive 0.7 with HIVE-1361

...

Hive 0.13 and later:  The storage that stores temporary Hive statistics. In FS based statistics collection, 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(:.*), hbase, counter and custom (HIVE-46326500).

hive.stats.autogather

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

...

When set to true Hive will answer a few queries like min, max, and count(1) purely using statistics stored in the metastore. For basic statistics collection, set the configuration property hive.stats.autogather to true. For more advanced statistics collection, run ANALYZE TABLE queries.

...