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 Tue, 03 Jun 2014 05:59:01 GMT
 
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:jamestaylor@apache.org]
Sent: Sat 5/31/2014 10:33 AM
To: user@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 <ramyas@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: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