Change Hive query execution engine to Spark

[#1]

I am using Hortonworks sandbox HDP 2.6. I want to change hive execution engine to Spark, able to see Tez and MR in the settings but not Spark how should I change it ?

[#2]

@Vinit Mahiwal

Here is the way to do it.

set hive.execution.engine=spark;

and a couple of other settings check this link it's what you need hive on spark