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.