You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Ramya S <ra...@suntecgroup.com> on 2014/06/16 08:50:54 UTC

FW: Pattern Matching using Phoenix

 
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: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 <ra...@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

Re: FW: Pattern Matching using Phoenix

Posted by James Taylor <ja...@apache.org>.
Hi Ramya,
Built-in functions must be included in the phoenix jar. We have an
open JIRA for supporting dynamically loaded built-in functions, but
until HBase has a way to sandbox coprocessor code, it's likely too
risky to support.

If you open a JIRA and provide a patch, we can include it in our next
patch release.

Thanks,
James

On Mon, Jun 16, 2014 at 8:50 AM, Ramya S <ra...@suntecgroup.com> wrote:
>
>
> 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: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 <ra...@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
>
>
>
>
>
>