Yeah, sure i will try.... Does the LIKE operator in phoenix support Integer/Double column values to be checked? Thanks Ramya.S
________________________________ From: James Taylor [mailto:jamestay...@apache.org] Sent: Sat 5/31/2014 10:33 AM To: u...@phoenix.incubator.apache.org 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 <ram...@suntecgroup.com> 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:a...@starfishzone.com] Sent: Thu 5/29/2014 7:19 PM To: u...@phoenix.incubator.apache.org 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
<<winmail.dat>>
