Page History

...

Value can be SPEED or COMPRESSION.

Vectorization

Hive added vectorized query execution in release 0.13.0 (HIVE-4160, HIVE-5283). For more information see the design document Vectorized Query Execution.

hive.vectorized.execution.enabled

• Default Value: xx
• Added In: Hive 0.13.0 with HIVE-####

x

hive.vectorized.execution.reduce.enabled

• Default Value: xx
• Added In: Hive 0.13.0 with HIVE-####

x

hive.vectorized.execution.reduce.groupby.enabled

• Default Value: xx
• Added In: Hive 0.13.0 with HIVE-####

x

hive.vectorized.groupby.checkinterval

• Default Value: xx
• Added In: Hive 0.13.0 with HIVE-####

x

hive.vectorized.groupby.maxentries

• Default Value: xx
• Added In: Hive 0.13.0 with HIVE-####

x

hive.vectorized.groupby.flush.percent

• Default Value: xx
• Added In: Hive 0.13.0 with HIVE-####

x

Vectorization

Hive added vectorized query execution in release 0.13.0 (HIVE-4160, HIVE-5283). For more information see the design document Vectorized Query Execution.

hive.vectorized.execution.enabled

• Default Value: false
• Added In: Hive 0.13.0 with HIVE-5283

This flag should be set to true to enable vectorized mode of query execution. The default value is false.

hive.vectorized.execution.reduce.enabled

• Default Value: true
• Added In: Hive 0.14.0 with HIVE-7405

This flag should be set to true to enable vectorized mode of the reduce-side of query execution. The default value is true.

hive.vectorized.execution.reduce.groupby.enabled

• Default Value: true
• Added In: Hive 0.14.0 with HIVE-8052

This flag should be set to true to enable vectorized mode of the reduce-side GROUP BY query execution. The default value is true.

hive.vectorized.groupby.checkinterval

• Default Value: 100000
• Added In: Hive 0.13.0 with HIVE-5692

Number of entries added to the GROUP BY aggregation hash before a recomputation of average entry size is performed.

hive.vectorized.groupby.maxentries

• Default Value: 1000000
• Added In: Hive 0.13.0 with HIVE-5692

Maximum number of entries in the vector GROUP BY aggregation hashtables. Exceeding this will trigger a flush regardless of memory pressure condition.

hive.vectorized.groupby.flush.percent

• Default Value: 0.1
• Added In: Hive 0.13.0 with HIVE-5692

...