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.