day_in_quarter(date)

Returns an integer representing the day of the quarter for a specific date.
q = foreach q generate day_in_quarter('OrderDate') as "Day in Quarter";