Setting Hive Hadoop property using Hive Query

Question

I am preparing for the HDPCD exam and I found out that they have a question where you have to set a Hadoop or Hive configuration properties within the Hive query. Can anyone help me out in solving this problem?

Answer 1

You can set Hadoop & Hive conf variable using the below command, but the changes will only be applicable to the query session.

Set -v prints all the Hadoop & Hive configuration variables.

SET mapreduce.job.reduces=XX

Using reset in the conf will reset the default value.