I'm little bit puzzled about REPLACE when there is backslash involved.
I want to replace all the "dir" in the string with "\\test\sub",
After a lot of try and error, I finally got it done, but I'm not sure why it is the case. Here's my code
A = load 'a.txt' as (name:chararray);
B = foreach A generate REPLACE(name,'dir','\\\\\\\\test\\\\sub');
The thing I'm confused about is why do I need to use "\\\\" in order to generate a "\", can anyone explain the reason? I'm using pig 0.9.1.