7. Enabling Tez for Hive Queries

Limitations

This release of Tez does not support the following actions:

  • Index creation

  • Skew joins

To enable Tez for Hive Queries:

  1. Run the following command to copy the hive-exec-*.jar to HDFS at /apps/hive/install/:

    su - $HIVE_USER
    hadoop fs -mkdir /apps/hive/install
    hadoop fs -copyFromLocal /usr/hdp/<hdp_version>/hive/lib/hive-exec-*<hdp version>*.jar /apps/hive/install/
  2. Enable Hive to use Tez DAG APIs. On the Hive client machine, add the following to your Hive script or execute it in the Hive shell:

    set hive.execution.engine=tez;

loading table of contents...