S05004

Error Code

S05004

Error Message

The column <xxx> expects type of <Type1>, but the actual type is <Type2>. RefId:S05004

Probable Causes

This error occurs when attempting to write data of Type2 to a column of Type1 in a DFS table, where Type1 and Type2 are incompatible types.

Type1 and Type2 are considered compatible only if one of the following conditions holds:

  • Type1 and Type2 are the same data type, e.g., both INT.
  • Type1 and Type2 belong to the same category, e.g., INT and LONG are both Integral types.
  • Type1 is a Floating type, and Type2 is an Integral type.
  • Type1 is a DECIMAL type, and Type2 is an Integral or Floating type.

Solutions

Check the data types of the input data and the target table, then

  • Modify the table schema.
  • Or explicitly cast the data types of the input data.