Page History

...

If this sets to true, Hive will throw error when doing ALTER TABLE tbl_name [partSpec] CONCATENATE on a table/partition that has indexes on it. The reason the user want to set this to true is because it can help user to avoid handling all index drop, recreation, rebuild work. This is very helpful for tables with thousands of partitions.

hive.optimize.index.autoupdate

• Default Value: false
• Added In: Hive 0.8.0 with HIVE-2354

Whether or not to enable automatic rebuilding of indexes when they go stale.
Caution: Rebuilding indexes can be a lengthy and computationally expensive operation; in many cases it may be best to rebuild indexes manually.

hive.optimize.index.groupby

• Default Value: false
• Added In: Hive 0.8.1 with HIVE-1694

...

Whether or not to use a binary search to find the entries in an index table that match the filter, where possible.

hive.optimize.index.autoupdate

• Default Value: false
• Added In: Hive 0.8.0 with HIVE-2354

...

.

Statistics

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

...