根据单词过滤字符串 [英] Filter a string on the basis of a word

问题描述

我有一个养猪工作，需要在其中找到一个单词来过滤数据，

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

这是代码段

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();

找到C时错误在第三行， 我也尝试过使用

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

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

也

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

推荐答案

MATCHES使用正则表达式.您应该改为... MATCHES '.*WORD.*'.

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

这些是此处找到"apache"一词的示例'.

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

这篇关于根据单词过滤字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！