Node Error: Too many hive partitions report an error [How to Solve]

Fatal error occurred when node tried to create too many dynamic partitions. The maximum number of dynamic partitions is controlled by hive.exec.max.dynamic.partitions and hive.exec.max.dynamic.partitions.pernode. Maximum was set to 100 partitions per node, number of dynamic partitions on this node: 105

 

Solution:

hive.exec.max.dynamic.partitions=500
hive.exec.max.dynamic.partitions.pernode=500