Enable vectorization

Query vectorization is disabled by default. As Administrator, you can enable query vectorization using the Cloudera Manager Safety Valve feature to set a Hive property. After you issue a query, Hive examines the query and the data to determine whether vectorization can occur. If not, Hive executes the query with vectorization disabled.

  1. In Cloudera Manager > Clusters select the Hive service. Click Configuration, and search for hive.vectorized.execution.enabled.
  2. Accept the default (enabled), or check HiveServer2 Default Group to enable the property.
  3. Click Save.
  4. Click Actions > Deploy Client Configuration.
  5. Restart Hive.