Hi I followed the steps to add the new built-in-funtion REGEXP_LIKE, but how can i register this function outside of the phoenix jar? Could anyone share the ways to test the user-defined funtion without building the phoenix jar? Please do reply Thanks Ramya.S
________________________________ From: James Taylor [mailto:[email protected]] Sent: Sat 5/31/2014 10:33 AM To: [email protected] Subject: Re: Pattern Matching using Phoenix 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
