Why Are 0 or -1 Displayed in the Hive Verification Results?

Symptom

A big data verification task for Hive was successfully executed. In the verification results, 0 or -1 appeared in the Source and Target columns.

Possible Causes

The calculated value exceeds the range supported by Hive.

During data processing, if Hive encounters a maximum or minimum value that it cannot represent in the standard value format, these extreme values are displayed as Infinity (indicating positive infinity) or -Infinity (indicating negative infinity). These values are not valid numbers. Therefore, exceptions may occur during value conversion or calculation.

During the verification, Hive and Spark process such values in the following ways:

• If the value is Infinity or -Infinity, the value is displayed as -1 by default.
• If the value is Not a Number (NaN), it is displayed as 0 by default.