How to split a tuple in character '\' in PIG

Question

I'm beginning learn PIG and I want to split a tuple in character '\'. My original tuple is

(192.168.2.227\al0000)

and I need to split it in '\'

(192.168.2.227, al0000)

I tryed to use

B =  FOREACH original GENERATE FLATTEN (STRSPLIT(tuple, '\\u034B'));

but it dont work. What is the proper solution ?

score 2 · Accepted Answer · edited May 23 '17 at 12:14

2

Input :

192.168.2.227\al0000

Pig Script :

A = LOAD 'input.csv' as line;  
B = FOREACH A GENERATE FLATTEN (STRSPLIT(line, '([\\\\])'));
dump B;

Second argument used is a regex to identify '\'

Output :

(192.168.2.227,al0000)

Ref :

edited May 23 '17 at 12:14

Community

answered Sep 30 '15 at 23:22

Murali Rao

score 0 · Answer 2 · answered Sep 30 '15 at 22:34

0

Did you try '\\\\' in place of the strange unicode code point u034B?

answered Sep 30 '15 at 22:34

Yes , I tried, but the PIG shows a ">>" and waits for some input – Marcelo Penteado Sep 30 '15 at 23:06
Hm, strange, the docs say it is a wrapper for Java String split() method. Maybe just two backslashes (e.g. '\\')? Also, it might be that you do not have a "tuple". What is before this in your script? – Victor - Reinstate Monica Sep 30 '15 at 23:14

2 Answers2