Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop Export Handling

Sqoop Export Handling

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

Expert Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here