Issue:
The Jython evaluator converts fields with null to STRING, regardless of the columns type.
Solution:
In the scripting processors, if a user needs to specify the data type of a field, which contains NULL, the user needs to use following constants (please find commented list also in the script of each scripting processor):
# Available constants:
# They are to assign a type to a field with a value null.
# NULL_BOOLEAN, NULL_CHAR, NULL_BYTE, NULL_SHORT, NULL_INTEGER, NULL_LONG
# NULL_FLOATNULL_DOUBLE, NULL_DATE, NULL_DATETIME, NULL_TIME, NULL_DECIMAL
# NULL_BYTE_ARRAY, NULL_STRING, NULL_LIST, NULL_MAP
Otherwise, if the processor returns null, the filed data format is of STRING type.