validating export schema

[sjordery]

Hi,
I am getting the following error when sending a column from a database table to seq file.

Sequential_File_12: When checking operator: When validating export schema: At field "file_processing_start_time": "null_field" length (0) must match field's fixed width (19)


The mentioned file_processing_time is a column of timestamp data type having length 23.While running the job data is nt getting transferred due the above error.

Can anybody suggest what this error exactly specifying.

[ray.wurlod]

Because the file is defined as fixed width, the Null Field Value must have the same number of characters as a non-null value in that field. In this case, apparently, 19 characters. Nineteen space characters would do. Twenty-three character timestamp would NOT do. A zero-length string (""), which is what you currently have set, will NOT do.

[sjordery]

Hi,

Actually I have not specified any fixed width size.
I have simply loaded the metadata from the database table while defining columns in the sequential file.
But while running the above mentioned error is showing.

[chulett]

Actually I have not specified any fixed width size.

Which is exactly the problem. Reread the error message, it's not that hard to understand, especially in light of Ray's comments.