Migrating Hive Workloads to Cloudera Private CloudPDF version

Enforcement of NOT NULL constraint

Before Upgrade to CDP

Hive did not support the enforcement of NOT NULL.

After Upgrade to CDP

HIVE-16605 supports NOT NULL constraint enforcement on INSERT, MERGE, and UPDATE statements. This capability is configurable by setting the hive.constraint.notnull.enforce property. For more information, see Using constraints.