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