I want to export data from HDFS using Sqoop2 with Null values.
I get error messages when I use true (as mentioned below), 'true' or 1 (for true since it is a boolean field) for "Override null value". Furthermore, I am also not sure what I have to put in for the "Null value". In the HDFS file (textfile) the Null value is represented by \N. I tried different values for that, including \N, '\N', NULL, 'NULL', N and 'N' but nothing worked.
From Job configuration
Input directory: /mnt/cloudera/hadoop/user/hive/warehouse/test_tbl Override null value: true Null value: N