Charles Givre created DRILL-7366:
------------------------------------

             Summary: Improve Null Handling for UDFs with Complex Output
                 Key: DRILL-7366
                 URL: https://issues.apache.org/jira/browse/DRILL-7366
             Project: Apache Drill
          Issue Type: Improvement
    Affects Versions: 1.16.0
            Reporter: Charles Givre
             Fix For: 1.17.0


If there is a UDF which has a complex field (Map or List) as output, Drill does 
not allow the UDF to have nullable input and it creates additional complexity 
when writing these kinds of UDFs. 

I therefore would like to propose that two options be added to the 
FunctionTemplate for null handling:  {{EMPTY_LIST_IF_NULL}}, and 
{{EMPTY_MAP_IF_NULL}} which, would simplify UDF creation.  I'm envisioning that 
if either of these options were selected, and the UDF receives any null value 
as input, the UDF will return either an empty map or list. 



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Reply via email to