There are two types of Partitioning: Static Partitioning and Dynamic partitioning.
- By default, Hive default mode of partitioning is a strict mode. As if we have any number of partitions, it will be a load on the name node to manage file space.
- If you prefer a dynamic partition, you need to set properties.
set hive.exec dynamic.partition=true;
- It is advisable to set these properties:-
set hive.exec dynamic.partition.mode=nonstrict;