3.3. Submit Hive Queries to Tez Service

	Warning
	These instructions are now obsolete and no longer provide a Supported version of Tez. Use the information found in HDP 2.1 regarding Installing and Configuring Tez.

Use the following instructions to submit Hive queries to Tez Service:

On the Tez Service host machine, browse to the Hadoop-Tez configuration directory created here and open the yarn-site.xml file.

Modify the following property:

<property>    
    <name>yarn.resourcemanager.address</name>    
   <value>$Tez_Host_Machine:10030</value>        
    <description>Match the value specified in the tez.ampool.address property.</description>  
</property>

Submit Hive queries to the Tez Service.
You can use either one of the following options:
- Option I: From command line
```
hive -e '$HIVE_QUERY' -hiveconf yarn.resourcemanager.address=$Tez_Host_Machine:10030
```
- Option II:
  1. Edit etc/hive/conf/hive-env.sh and add the following environment variables:
    export HADOOP_CONF_DIR="$HADOOP_TEZ_DIR" export YARN_CONF_DIR="$HADOOP_TEZ_DIR"
    where $HADOOP_TEZ_DIR is the Hadoop configuration directory for Tez created here. For example, etc/hadoop-tez/conf.
  2. From the Hive client, execute the following command:
    hive -e "$HIVE_QUERY"
where $HIVE_QUERY is your Hive query. For example, select count(*) from employee.

Legal notices