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
>>>
>>
