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 ?
You can subsitute string in the place of missing value that is null.
try the below parameter in export .