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)