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 <[email protected]> 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:[email protected]] > Sent: Sat 5/31/2014 10:33 AM > To: [email protected] > 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 <[email protected]> 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:[email protected]] > Sent: Thu 5/29/2014 7:19 PM > To: [email protected] > 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 > > > > > >
