WTF NULL HIVE?

README.md

Can anybody tell me what's going on here? Everything I've read says to use "\N" for both STRINGs and non-STRINGs, but Hive is treating them differently. WTF?

data

\\N
\\N

output

hive> SELECT * FROM default.null_test;
OK
NULL	\N

test_table.q

CREATE EXTERNAL TABLE default.null_test (
  int_test INT,
  string_test STRING)
ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\001' ESCAPED BY '\\'
STORED AS TEXTFILE
LOCATION '/user/rbriones/test_null';

Seems like the data in the file should actually be literal \N and not \\N. It's getting in the data file that way because it (seems) impossible to specify \N as an parameter in an Oozie Sqoop job.

Also, non-STRING types seems to work fine since the value doesn't parse to those types and the underlying Java probably just returns null on parse errors...

This issue appears to be a bad combination of --escaped-by '\\' and --null-string '\\N'. Works great when removing --escaped-by