Disabling Partition Type Checking

An enhancement in Hive 3 checks the types of partitions. This feature can be disabled by setting a property. For more information, see the ASF Apache Hive Language Manual.

Before Upgrade to CDP

In CDH 5.x, partition values are not type checked.

After Upgrade to CDP

Partition values specified in the partition specification are type checked, converted, and normalized to conform to their column types if the property hive.typecheck.on.insert is set to true (default). The values can be numbers.

Action Required

If type checking of partitions causes problems, disable the feature. To disable partition type checking, set hive.typecheck.on.insert to false. For example:

SET hive.typecheck.on.insert=false;