drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Re: REGEX search Operator
Date Tue, 02 Feb 2016 16:56:16 GMT
I would like to see something like this as well, even if it's an included
UDF like REGEX(field, pattern) using Java's library for regex like Hive
does.  That would be EXTREMELY helpful.





On Tue, Feb 2, 2016 at 6:55 AM, Nicolas Paris <niparisco@gmail.com> wrote:

> > ANSI SQL doesn't define regex operator.
> > Drill neither.
> >
> ​Drill has SQL functions extension like "REPEATED_CONTAINS"​ that looks to
> handle regex. regex operator could be replaced with one new SQL extension ?
> I guess I could create my own functions in java, right ? Maybe push it into
> github then ?
>
>
> > Doesn't it enough 'LIKE' operator?
> >
>
> ​Sadly not, I'am looking for complex pattern matching. ​
>
>
> --
> > Miura, Masahide
> >
> > -----Original Message-----
> > From: Nicolas Paris [mailto:niparisco@gmail.com]
> > Sent: Tuesday, February 02, 2016 9:04 PM
> > To: user@drill.apache.org
> > Subject: REGEX search Operator
> >
> > Hello,
> >
> > I can't find any reference in the documentation about a regex operator.
> >
> > I would like to be able to query this way :
> >
> > SELECT *
> > FROM xxx
> > WHERE  text_field   regexOperator    'regex_pattern';
> >
> > Thanks for helping,
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message