I have a use-case where I want a UDF to return dynamic number of columns
based on parameter.
Consider a udf function called return_cols which takes two params, fields
and a comma-separated list of output fields eg. select
return_cols(table-field, "foo,bar") from table or select
return_cols(table-field, "foo,bar,baz") from table.
The first call return 2 columns back while the second call returns 3
columns back. I could technically return a map of things but that would
mean I will have to wrap the query and select map.foo, map.bar, map.baz. I
had rather output the data with column headers and let the downstream tools
figure out how to consume it.
Is it possible to output columns headers through a hive genericudf ? I
looked around for example but could not find anything.