Hive execution engine


When I check the hive view in Ambari, under the optimization section I see that the execution engine shows map_reduce. How do I change it to Tez ?



So from what I am aware . This change might not be able from UI rather going into the /etc/hive-site.xml and then changing the key . But without the admin access this cannot be done.


Hi @dEbKalYan_rOy and @Raghunandan_Sk,

You can change the execution engine in the Hive shell. This change will be valid only for that session. Here is the command to set execution engine to MapReduce

set hive.execution.engine=mr;

Hope this helps.