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, for example, HIVE_ON_TEZ-1. Click Configuration, and search for hive-site.xml.
  2. In HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml, click + and add the hive.vectorized.execution.enabled property.
  3. Enter a value of true.
  4. Click Save.
  5. Click Actions > Deploy Client Configuration.
  6. Restart HIVE_ON_TEZ-1.