Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> REPLACE with backslash

Copy link to this message
REPLACE with backslash

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.