drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Altekruse <altekruseja...@gmail.com>
Subject Re: REGEX search Operator
Date Thu, 04 Feb 2016 15:37:25 GMT
I didn't realize that we were lacking this functionality. As the
repeated_contains operator handles wildcards it makes sense to add such a
function to drill.

It should be simple to implement, would someone like to open a JIRA and
submit a PR for this?

- Jason

On Tue, Feb 2, 2016 at 8:56 AM, John Omernik <john@omernik.com> wrote:

> 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