Question

Variable Substitution is disabled by using ___________

(a) set hive.variable.substitute=false;

(b) set hive.variable.substitutevalues=false;

(c) set hive.variable.substitute=true;

(d) all of the mentioned

The question was asked by my college professor while I was bunking the class.

The doubt is from HiveQL topic in division Hive and HBase of Hadoop

Answer 1

Right answer is (a) set hive.variable.substitute=false;

The explanation: Variable substitution is on by default (hive.variable.substitute=true).