Hi All In HIVE, I would like to write a UDF that accepts a sequence of parameters. Due to that the number of parameters is large and the particular function that I am writing is specific to a set of tables (joined in some way in the SQL), I am wondering if there is a way to pass the entire row as a wildcard parameter and then queried for its fields in UDF within this context, as shown in the below example.
select my_function(*) as my_column from t1, t2, etc where [a set of join conditions]. I did some investigation and found there was a JIRA opened for this. https://issues.apache.org/jira/browse/HIVE-1459 This ticket is opened as a follow up to ticket HIVE-287 to support star expansion in general and seems still open. If anyone knows a way to pass the entire row as a context in UDF, that would be very helpful. Regards, Chen
