To disable Tez for Hive queries:
On the Hive client machine, add the following to your Hive script or execute it in the Hive shell:
set hive.execution.engine=mr;
Tez will then be disabled for Hive queries.