Hi, 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'); dump B; 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. Thanks. Dan