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?
I am not an expert for SAP. My guess is that deep down the NUMC type in SAP is actually not saving as null value if it is empty.
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: