Handle Exporting nullable field without null handling properties for fix length file

初级会员 注册时间: 2008-07-15 04:52:19 文章: 6 离线

I have used a sequence file stage as the job's output. The file is defined as a fix length file and some of the columns can have null values. When I run the job, it gives me the following warning:

When checking operator: When validating export schema: At field "<field name>": Exporting nullable field without null handling properties

How can I remove the above warning?

1. In Sequential File >format there is property tab null to value u can use that one
2. Use modify stage before Sequential File and handle the null value

初级会员 注册时间: 2008-07-15 04:52:19 文章: 6 离线

I have tried to set the format property null field value to '' but it gives me "Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length.".

For the 2nd solution, do you mean to set the value to '' before entering the sequence file stage?

Thank you so much.

初级会员 注册时间: 2008-10-28 20:38:46 文章: 10 离线

不知道你能否看懂中文，在进行空值处理时，也就是设置空值的替代值时，替代值的长度最好和这个可空字段定义的长度相同。
呵呵，是你要的答案吗？抱歉我E文不是很好，也没太看懂你的问题。