https://community.cloudera.com/t5/Support-Questions/Cannot-modify-hive-exec-max-dynamic-partitions-pernode-at/m-p/173814#M136077 <P>I've seen <A href="http://hadooptutorial.info/partitioning-in-hive/">several</A> different <A href="http://stackoverflow.com/questions/29726078/hive-fatal-error-when-trying-to-create-dynamic-partitions">examples</A> online of people setting this property in Hive at runtime, but I am not able to through beeline. I've even set up the whitelist in Ambari for this property, but I'm still unable to set it. </P><PRE>hive.security.authorization.sqlstd.confwhitelist=hive.exec.max.dynamic.partitions,hive.exec.max.dynamic.partitions.pernode</PRE><P>But when I try this in beeline:</P><PRE>0: jdbc:hive2://whqlhdpm004:10000/hive&gt; set hive.exec.max.dynamic.partitions.pernode=1000;</PRE><P>I get the following error: </P><P>Error: Error while processing statement: Cannot modify hive.exec.max.dynamic.partitions.pernode at runtime. It is not in list of params that are allowed to be modified at runtime (state=42000,code=1)</P> Wed, 28 Dec 2016 23:23:42 GMT barret_miller 2016-12-28T23:23:42Z