Post 51 | HDPCD | Set Hadoop or Hive Configuration property

Hello, everyone. Welcome to the last technical tutorial in the HDPCD certification series.

It’s funny! This beautiful journey is coming to an end.

In the last tutorial, we saw how to sort the output of a Hive query across multiple reducers.

In this tutorial, we are going to see how to set a Hadoop or Hive configuration property.

Let us begin, then.

It is one of the easiest tutorials in this certification series. Maybe, that is why it is kept, at last, just kidding.

The following commands do depict the usage of the set command which is used for setting Hadoop or Hive configuration property/properties.

Let us see each of these commands one by one.


For doing this, we first check what is the current value of the Hive execution engine.use the SET command in the following way.

set hive.execution.engine;

The above command gives us the default value of the Hive execution engine.

You can see from the above screenshot that the default value of the Hive execution engine is “TEZ”.

Now, if you want to change the Hive execution engine property to MapReduce, you can use the following command.

set hive.execution.engine=mr;

To check whether the above command executed successfully or not, you can run the following command and check the output.

set hive.execution.engine;

The output of the above command shows that MapReduce is the Hive execution engine, as expected.

Few examples showing usage of SET command
Few examples showing usage of SET command

The above screenshot shows that the Hive Execution Engine property was successfully changed to MapReduce from its default value TeZ.

Similarly, we can see that I have changed other properties such as SCRATCH DIRECTORY location and the Hive Header Printer flag.

To give you the gist of this tutorial, I would say it enables you to correctly use the “SET” command.

This concludes the last technical tutorial in the HDPCD certification series.

I hope you guys find these tutorials useful and I would feel privileged if at least one person gets benefited from these tutorials.

Do not forget to let me know if these tutorials came handy to you and were useful for clearing the HDPCD certification. You can contact me using the below form.

The next tutorial is going to be the last tutorial in this certification series, in which I will mention how to register for the exam and what precautions to take on the exam day.

If you liked the content, share it with your friends. Please hit the Like button.

You can check out my LinkedIn profile here. Please like my Facebook page here. Follow me on Twitter here and subscribe to my YouTube channel here for the video tutorials.

Published by milindjagre

I founded my blog four years ago and am currently working as a Data Scientist Analyst at the Ford Motor Company. I graduated from the University of Connecticut pursuing Master of Science in Business Analytics and Project Management. I am working hard and learning a lot of new things in the field of Data Science. I am a strong believer of constant and directional efforts keeping the teamwork at the highest priority. Please reach out to me at for further information. Cheers!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: