I have a sqoop import job in which I tell it to use '\\N' for both the --null-string and --null-non-string values. It is importing from an SAP HANA database directly to hive. I noticed that for a particular table I import, there are two columns of type NUMC in SAP that are being converted to string automatically, but instead of having null values it is defaulting to a value of 00000000. Why would sqoop be ignoring the --null-non-string argument? Or am I doing it wrong?
As @Frank Lu indicated, SAP is likely not storing NULL as the value for null values. It may depend on how the table was created. Was it defined using initial values? That changes what can be written into the field. Check out this documentation: