Sqoop Export Handling

[#1]

Hi All,

I have a sqoop export to postresDB with the following data.csv

1,2,abc,\N,xyz

2,3,aaa,\N,xz,

3,3,bbb,\N,\N

Currently all my csv data null columns has "\N" in both strings and non string column.while exporting data to postgresDB i want to handle this "\N" with Null ? please help me on this issue.

Thanks

Anbu

[#2]

Hi,

You can use couple of parameters for strings columns and non string column.

## string columns:- --null-string

## non string columns:- --null-non-string

Link:- https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_null_string_handling

Above is the link will help you to handle these characters.

Regards

Nitish