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:52:40 GMT
Awesome, thanks!

On Thu, Feb 4, 2016 at 7:44 AM, Nicolas Paris <niparisco@gmail.com> wrote:

> Well I am creating a udf
> good exercise
> I hope a PR soon
>
> 2016-02-04 16:37 GMT+01:00 Jason Altekruse <altekrusejason@gmail.com>:
>
> > 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