Configure partitions for transactions

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

Change the following parameters to meet your needs:
  • hive.exec.max.dynamic.partitions
  • hive.exec.max.dynamic.partitions.pernode
  1. In Cloudera Manager > Clusters select the Hive service, for example, HIVE_ON_TEZ-1. Click Configuration, and search for hive-site.xml.
  2. In HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml, click + and add the hive.exec.dynamic.partition.mode property.
  3. Set the value to nonstrict.
  4. Save the changes and restart the Hive service.