phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Pattern Matching using Phoenix
Date Sat, 31 May 2014 05:03:40 GMT
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