Command to partition table in Hive

Question

Do we need to run the below commands every time we create partition table?

set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.dynamic.partition=true;
set hive.enforce.bucketing=true;

Answer 1

Yes, You need to mention the below commands everytime you do partitioning:

set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.dynamic.partition=true;

In case you need to do bucketing then you need to write this:

set hive.enforce.bucketing=true;

Else there is no need for this.