Need help in like operator

2013-12-06 Thread Krishnan Narayanan
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

2013-12-06 Thread Raviteja Chirala
You can use 'matches' keyword in Pig to find out LIKE wise words. On Dec 6, 2013, at 2:17 PM, Krishnan Narayanan krishnan.sm...@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