Managing Apache Hive
Also available as:

Configure partitions for transactions

To include INSERT, UPDATE, and DELETE statements in your transaction applications, you must set your dynamic partition mode to nonstrict.

Default limitations in the following parameters are changed to meet your needs:
  • hive.exec.max.dynamic.partitions
  • hive.exec.max.dynamic.partitions.pernode
  1. Navigate to hive-site.xml, and open it for editing.
  2. Changehive.exec.dynamic.partition.mode to nonstrict.