Categories

Apr 24 in Big Data | Hadoop

Q:

Types of Partitioning

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;

Related questions

Madanswer
Apr 24 in Big Data | Hadoop
Apr 24 in Big Data | Hadoop
Apr 6 in Big Data | Hadoop
...