Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

what is the usecase of Strict mode in Dynamic partitioning in Hive?? When would some one need that mode to do partitioning??

what is the usecase of Strict mode in Dynamic partitioning in Hive?? When would some one need that mode to do partitioning??

Contributor
 
1 REPLY 1

Re: what is the usecase of Strict mode in Dynamic partitioning in Hive?? When would some one need that mode to do partitioning??

Rising Star

The purpose of the default value of 'strict' for hive.exec.dynamic.partition.mode is to prevent a user from accidentally overwriting all the partitions, i.e. to avoid data loss.

Another noteworthy consideration when using dynamic partitions: if we partition by a column with a lot of unique values, Hive will create at least one file per value which can negatively impact performance.