NULL related behaviors Several behavior changes are due to the handling of NULLs. ORDER BY clause treatment of NULLsThe default value of hive.default.nulls.last in CDP differs from the default value in CDH, which causes a behavioral difference in the ORDER BY clause, including ORDER BY within a RANK function.Disallow enabling/enforcing NOT NULLHive does not manage the data for external tables and cannot enforce constraints on these tables.Default NULL ordering changeThe default NULL ordering changed from CDH to CDP. A workaround can prevent a possible performance hit.Enforcement of NOT NULL constraintParent topic: Syntax and semantic changes CDH 6.2.1 to CDP 7.0.3.2