Page History

...

• Default Value: false
• Added In: Hive 0.6.0

Whether or not to allow dynamic partitions in DML/DDL.

hive.exec.dynamic.partition.mode

...

In strict mode, the user must specify at least one static partition in case the user accidentally overwrites all partitions. In nonstrict mode all partitions are allowed to be dynamic.

Set to nonstrict to support INSERT ... VALUES, UPDATE, and DELETE transactions (Hive 0.14.0 and later). For a complete list of parameters required for turning on Hive transactions, see hive.txn.manager.

...

• Default Value: 1000
• Added In: Hive 0.6.0

Maximum number of of dynamic partitions allowed  allowed to be created in total.

hive.exec.max.dynamic.partitions.pernode

• Default Value: 100
• Added In: Hive 0.6.0

Maximum number of of dynamic partitions allowed  allowed to be created in each mapper/reducer node.

...

Whether to throw an exception if dynamic partition insert generates empty results.

hive.exim.uri.scheme.whitelist

...