I think you should actually just put the function in Drill itself. System native functions are implemented in the same interface as UDFs, because our mechanism for evaluating them is very efficient (we code generate code blocks by linking together the bodies of the individual functions to evaluate a complete expression).
You can open a JIRA, marking it a feature request. You can open a poll request against the apache github repo, making sure you follow the standard format for your commit message, prefixing with the JIRA number in the format Example: DRILL-XXXX: Feature description This will automatically link the PR to your JIRA. - Jason On Thu, Feb 4, 2016 at 8:44 AM, Nicolas Paris <[email protected]> wrote: > Jason, I have it working, > > Just tell me the way to proceed to PR. > 1. where do I put my maven project ? Witch folder in my drill github fork? > 2. do I need a jira ? how proceed ? > > For now, I only published it on my github account in a separate project > > Thanks > > 2016-02-04 16:52 GMT+01:00 Jason Altekruse <[email protected]>: > > > Awesome, thanks! > > > > On Thu, Feb 4, 2016 at 7:44 AM, Nicolas Paris <[email protected]> > wrote: > > > > > Well I am creating a udf > > > good exercise > > > I hope a PR soon > > > > > > 2016-02-04 16:37 GMT+01:00 Jason Altekruse <[email protected]>: > > > > > > > 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 <[email protected]> > 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 <[email protected] > > > > > > 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:[email protected]] > > > > > > > Sent: Tuesday, February 02, 2016 9:04 PM > > > > > > > To: [email protected] > > > > > > > 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, > > > > > > > > > > > > > > > > > > > > > > > > > > > >
