Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.16.0
-
None
-
None
-
None
-
Patch, Important
Description
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.