These are configuration properties, not table properties. Here are their descriptions in the Hive wiki:
- hive.exec.dynamic.partition.mode <https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.exec.dynamic.partition.mode> - hive.exec.max.dynamic.partitions <https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.exec.max.dynamic.partitions> - hive.exec.max.dynamic.partitions.pernode <https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.exec.max.dynamic.partitions.pernode> And there's more information in the Tutorial: Dynamic-Partition Insert <https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-Dynamic-PartitionInsert> . -- Lefty On Mon, Apr 4, 2016 at 5:54 AM, bhanu prasad <mail2bigdatapra...@gmail.com> wrote: > Hi, > > Can anyone explain me the below dynamic partitioning table properties in > detail. > > > > 1.set hive.exec.dynamic.partition.mode=nonstrict; > 2.set hive.exec.max.dynamic.partitions=10000; > 3.set hive.exec.max.dynamic.partitions.pernode=500; > > > Thanks in advance > >
