I should add that one of the challenges is that there are SO many undocumented UDFs. I've been trying to start documenting them here: https://github.com/apache/drill/tree/master/contrib/udfs <https://github.com/apache/drill/tree/master/contrib/udfs>
I also wrote a python script that scrapes the Drill source code and finds all the UDFs in the code. I can share if you want. -- C > On Jan 30, 2020, at 1:47 PM, Paul Rogers <[email protected]> wrote: > > Hi Andrew, > > In addition to the resources mentioned, I'd be remiss to not mention the book > "Learning Apache Drill" from O'Reilly which has a chapter on creating UDFs. > (Full disclosure: Charles and I are the authors.) > > Igor's suggestion to look at the Presto list is a great one. You can also > look at Impala, Oracle, Postgres, and MySQL. You can also look a bit further > afield: perhaps Spark, and associated libraries, offer some suggestions. > > Thanks, > - Paul > > > > On Thursday, January 30, 2020, 9:20:02 AM PST, Charles Givre > <[email protected]> wrote: > > Hey Andrew, > Feel free to bounce ideas off of me. I think I have a UDF template here: > https://github.com/cgivre/drillworkshop > <https://github.com/cgivre/drillworkshop>. If you get stuck also let me > know... happy to help. > -- C > > > >> On Jan 30, 2020, at 10:01 AM, Andrew Tate <[email protected]> wrote: >> >> Thanks for the thoughtful response, Igor. I'll delve into those resources 👍 >> >> -Andrew >> >> On Thu, Jan 30, 2020, 00:46 Igor Guzenko <[email protected]> wrote: >> >>> Hello Andrew, >>> >>> I highly appreciate your interest in Drill. A very good place to start your >>> journey is the GitHub wiki[1] created by Paul Rogers. Here is a rich list >>> of existing Jira tickets[2] you can select from or as an alternative way, >>> you could also get the two lists of Presto[3] and Drill[4] functions, >>> compare them and select what is most interesting for you. Welcome to Apache >>> Drill community:) >>> >>> [1] https://github.com/paul-rogers/drill/wiki/UDFs-Background-Information >>> [2] >>> >>> https://issues.apache.org/jira/issues/?jql=project%20%3D%20DRILL%20AND%20issuetype%20in%20(Improvement%2C%20%22New%20Feature%22)%20AND%20resolution%20%3D%20Unresolved%20AND%20component%20%3D%20%22Functions%20-%20Drill%22%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC >>> [3] https://prestosql.io/docs/current/functions/list.html >>> [4] https://drill.apache.org/docs/sql-functions/ >>> >>> Kind regards, >>> Igor >>> >>> On Wed, Jan 29, 2020 at 11:22 PM Andrew Tate <[email protected]> wrote: >>> >>>> Hi Everyone, >>>> >>>> I'd like to contribute some UDFs as a way to help out and get some >>> exposure >>>> to the Drill ecosystem. I have some ideas of my own, but I wanted to hear >>>> if there are suggestions. After all, I'd love my contribution to be >>>> helpful. >>>> >>>> Thanks, >>>> Andrew Tate >>>> >>>
