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 Import split-by-id does not retrieve null values on split-by-id column

Sqoop Import split-by-id does not retrieve null values on split-by-id column

Explorer

Hi,  

   I was doing a sqoop import from mysql and used split-by-id option instead of - m 1.

   But the export only retriving the records which are not null on split-by-id field.

   why is it designed that way ?

 

Thanks

 

1 REPLY 1

Re: Sqoop Import split-by-id does not retrieve null values on split-by-id column

Champion

You can subsitute string in the place of missing value that is null.

 

try the below parameter in export .

 

--input-null-non-string '\\N'
--input-null-string '\\N'