Configure partitions for transactions

To include INSERT, UPDATE, and DELETE statements in your transaction applications, dynamic partition mode must be set to nonstrict (the default).

Configuring partitioning involves changing the following parameters to meet your needs:
  • hive.exec.max.dynamic.partitions
  • hive.exec.max.dynamic.partitions.pernode

You set hive.exec.dynamic.partition.mode to strict to prevent accidental dynamic partitioning.

  1. In Cloudera Manager > Clusters select the Hive service. 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.