Our functions are listed here: http://phoenix.incubator.apache.org/language/functions.html#regexp_replace
We have LIKE, but not REGEXP_LIKE. Maybe you can contribute it - it's pretty easy? There's a step by step guide here: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html Thanks, James On Thu, May 29, 2014 at 10:41 PM, Ramya S <[email protected]> wrote: > Thanks alot... > > But im looking for REGEXP funtion that matches a column value with a > particular pattern. > > For eg: > WHERE (REGEXP_LIKE(patient_phone, '^\([[:digit:]]{3}\) > [[:digit:]]{3}-[[:digit:]]{4}$'))); > > Is that possible with phoenix? > > Ramya.S > > ________________________________ > > From: Andrew [mailto:[email protected]] > Sent: Thu 5/29/2014 7:19 PM > To: [email protected] > Subject: Re: Pattern Matching using Phoenix > > > Yes, please see: > http://phoenix.incubator.apache.org/language/functions.html#regexp_substr > > On 29/05/2014 13:05, Ramya S wrote: > > > > Hi, > > Im using phoenix-2.2.2 on Apache hadoop-1.0.4. > > Does phoenix support REGEXP operator or is there any equivalent > operator for pattern matching using phoenix. > > > Please help to solve the same. > > > > > Thanks & Regards > > Ramya.S > > > >
