Question

What is the default maximum dynamic partition that can be created by a mapper/reducer?

Answer 1

By default the number of maximum partition that can be created by a mapper or reducer is set to 100. One can change it by issuing the following command:

SET hive.exec.max.dynamic.partitions.pernode = <value>