There are three types of execution engines, they are

1. Mr (Map Reduce job)

We can use this MR mode if we need executions to be processed under map reduce jobs. If we select this option for this property, the below commands will be applicable while preparing query

set hive.execution.engine = mr;

set mapred.job.queue.name = default;

1. Tez

Tez is an extensible framework for building high performance batch and interactive data processing applications, coordinated by YARN in Apache Hadoop. If we select this option for this property, the below commands will be applicable while preparing query

set hive.execution.engine = tez;

set tez.queue.name = default;

• Spark

We can use this mode if we need hive executions to be process under spark engine. If we select this option for this property, the below commands will be applicable while preparing query

set hive.execution.engine = Spark;

set spark.yarn.queue= default;