year_last_day(date)

Returns the date of the last day of the year for a specific date.

q = foreach q generate year_last_day('BillDate') as "Year Last Day";

note: This function always returns December 31. It’s included for uses such as finding the number of days to the year end and for use in a specific locale.