Hortonworks suggested settings Tez/Hive

hive-site.xml

<property>
    <name>hive.vectorized.groupby.flush.percent</name>
    <value>0.1</value>
</property>
<property>
    <name>hive.vectorized.groupby.maxentries</name>
    <value>10240</value>
</property>
<property>
    <name>tez.session.am.dag.submit.timeout.secs</name>
    <value>300</value>
</property>
<property>
    <name>tez.am.container.session.delay-allocation-millis</name>
    <value>300000</value>
</property>
<property>
    <name>tez.am.container.reuse.enabled</name>
    <value>true</value>
</property>
<property>
    <name>hive.server2.tez.initialize.default.sessions</name>
    <value>true</value>
</property>
<property>
    <name>hive.server2.tez.default.queues</name>
    <value>hive1,hive2</value>
</property>
<property>
    <name>hive.server2.tez.sessions.per.default.queue</name>
    <value>1</value>
</property>
<property>
    <name>hive.server2.enable.doAs</name>
    <value>false</value>
</property>
<property>
    <name>hive.vectorized.groupby.flush.percent</name>
    <value>0.1</value>
</property>