Page History

...

• Default Value: false
• Added In: Hive 0.8.0

Whether to enable automatic use of indexes.

hive.optimize.index.groupby

• Default Value: false
• Added In:

Whether to enable optimization of group-by queries using Aggregate Note:  See Indexing for more configuration properties related to Hive indexes.

hive.optimize.ppd

...

Allow JDO query pushdown for integral partition columns in metastore. Off by default. This improves metastore performance for integral columns, especially if there's a large number of partitions. However, it doesn't work correctly with integral values that are not normalized (e.g. have leading zeroes, like 0012). If metastore direct SQL is enabled and works, this optimization is also irrelevant.

Indexing

Indexing was added in Hive 0.7.0 with HIVE-417, and bitmap indexing was added in Hive 0.8.0 with HIVE-1803.  For more information see Indexing.

hive.index.compact.file.ignore.hdfs

• Default Value: false
• Added In:

...

• Hive 0.7.0 with HIVE-1889

When true the HDFS location stored in the index file will be ignored at runtime. If the data got moved or the name of the cluster got changed, the index data should still be usable.

hive.optimize.index.filter

...

• Default Value:

...

•  false
• Added In: Hive 0.8.0 with HIVE-1644

Whether to enable automatic use of indexes.

hive.optimize.index.filter.compact.minsize

• Default Value: 5368709120
• Added In: Hive 0.8.0 with HIVE-1644

Minimum size (in bytes) of the inputs on which a compact index is automatically used.

...

• Default Value: -1
• Added In: Hive 0.8.0 with HIVE-1644

Maximum size (in bytes) of the inputs on which a compact index is automatically used. A negative number is equivalent to infinity.

...

• Default Value: 10737418240
• Added In: Hive 0.8.0 with HIVE-2096

The maximum number of bytes that a query using the compact index can read. Negative value is equivalent to infinity.

...

• Default Value: 10000000
• Added In: Hive 0.8.0 with HIVE-2096

The maximum number of index entries to read during a query that uses the compact index. Negative value is equivalent to infinity.

hive.index.compact.binary.search

• Default Value: true
• Added In:

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

hive.exec.concatenate.check.index

• Default Value: true
• Added In: Hive 0.8.0 with HIVE-2125

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.groupby

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

hive.index.compact.binary.search

• Default Value: true
• Added In: Hive 0.8.1 with HIVE-2535

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

Statistics

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

...