phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramya S" <ram...@suntecgroup.com>
Subject RE: Pattern Matching using Phoenix
Date Fri, 30 May 2014 05:41:03 GMT
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:al@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 
	 


Mime
View raw message