• Home
  • Recent Q&A
  • Java
  • Cloud
  • JavaScript
  • Python
  • SQL
  • PHP
  • HTML
  • C++
  • Data Science
  • DBMS
  • Devops
  • Hadoop
  • Machine Learning
in Big Data | Hadoop by
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

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