Filter a string on the basis of a word

Question

I have a pig job where in I need to filter the data by finding a word in it,

Here is the snippet

A = LOAD '/home/user/filename' USING PigStorage(',');
B = FOREACH A GENERATE $27,$38;
C = FILTER B BY ( $1 ==  '*Word*');
STORE C INTO '/home/user/out1' USING PigStorage();

The error is in the 3rd line while finding C, I have also tried using

C = FILTER B BY $1 MATCHES '*WORD*'

Also

C = FILTER B BY $1 MATCHES '\\w+WORD\\w+'

. Any character (may or may not match line terminators) * zero or more times https://docs.oracle.com/javase/1.5.0/docs/api/java/util/regex/Pattern.html — isaikkimuthu, Oct 01 '18 at 18:27

score 16 · Accepted Answer · edited Aug 30 '12 at 15:59

16

MATCHES uses regular expressions. You should do ... MATCHES '.*WORD.*' instead.

These is an example here finding the word 'apache'.

edited Aug 30 '12 at 15:59

user229044

232,980
40
330
338

answered Sep 17 '11 at 02:21

Donald Miner

38,889
8
95
118

that is the correct syntax, but I wonder why do we need to add the `.*` around the word. Why is `MATCHES 'WORD'` not working? – ℕʘʘḆḽḘ Jun 29 '17 at 15:22

Filter a string on the basis of a word

1 Answers1

Linked