day_in_week(date)

Returns an integer representing the day of the week for a specific date. 1 = Sunday, 2 = Monday and so on.

q = foreach q generate day_in_week('OrderDate') as "Day in Week";