Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: The Cloudera Community will undergo maintenance on Saturday, August 17 at 12:00am PDT. See more info here.

Sqoop Export Handling

Highlighted

Sqoop Export Handling

Explorer

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

1 REPLY 1

Re: Sqoop Export Handling

Rising Star

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