Limit the maximum number of dynamic partitions in Hive

Question

Hi. I want to limit the maximum number of dynamic partitions that can be created to be 500. How can I change this?

Answer 1

By default, the maximum number of default partitions that can be created is set to 1000. You can set it to 500 as follows:

$ hive --hiveconf hive.exec.max.dynamic.partitions=500

Answer 2

if you are already on hive shell prompt. you just need to type in below command to change this parameter.

set hive.exec.max.dynamic.partitions=500;