0 votes
in Big Data | Hadoop by
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

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
...