CODEWITHSUNDEEP
apache-pig
Surender Raja
Surender Raja

Reputation: 3599

Pig function to read characters after a separator

This is my input file 

a1,hello.VDF
a2,rim.VIM
a3.dr.VDD

I need output as below 

a1,VDF
a2,VIM
a3,VDD

My script is the following:

myinput = LOAD 'file' USING PigStorage(',') AS(t1:chararray,t2:chararray); foreached= FOREACH myinput GENERATE t1,SUBSTRING(t2,INDEXOF(t2,'.',1),SIZE(t2));

It's throwing some error. Please help

Upvotes: 0

Views: 624

Answers (2)

Rengasamy
Rengasamy

Reputation: 1043

Try this:

output = foreach myinput generate ((t1 matches '(.*)\\.(.*)'?SUBSTRING(t1, 0, 2):t1), (t1 matches '(.*)\\.(.*)'?SUBSTRING(t1, INDEXOF(t1,'.',0)+1, (int)SIZE(t1)):t2));

Upvotes: 0

Lorand Bendig
Lorand Bendig

Reputation: 10650

SIZE returns long, but SUBSTRING takes integers, so you need to do conversion:

foreached = 
  FOREACH myinput GENERATE t1,SUBSTRING(t2,INDEXOF(t2,'.',1)+1,(int)SIZE(t2));

Upvotes: 0

Related Questions