Would 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-REGEXColumnSpecification
 work for you in the meantime?


From: Chen Song [mailto:chens_alb...@yahoo.com]
Sent: Monday, October 31, 2011 9:15 AM
To: hive dev list; hive user list
Subject: pass entire row as parameter in hive UDF

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

Reply via email to