RE: Pattern Matching using Phoenix

[Ramya S]

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: user@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>>