You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by Krishnan Narayanan <kr...@gmail.com> on 2013/12/06 23:17:50 UTC

Need help in "like" operator

Hi All

How to write the below query to pig, can i use REGEX_EXTRACT_ALL ?

select * from temp where column1 like ( '%abc%' or '%def% or '%aacc%');

Help much appreciated with example.

Thanks
Krishnan

Re: Need help in "like" operator

Posted by Raviteja Chirala <ra...@gmail.com>.

You can use 'matches' keyword in Pig to find out LIKE wise words.  

On Dec 6, 2013, at 2:17 PM, Krishnan Narayanan <kr...@gmail.com> wrote:

> Hi All
> 
> How to write the below query to pig, can i use REGEX_EXTRACT_ALL ?
> 
> select * from temp where column1 like ( '%abc%' or '%def% or '%aacc%');
> 
> Help much appreciated with example.
> 
> Thanks
> Krishnan