Airline flight analysis using hive and pig

There are 29 columns in this dataset. Some of them are:

Year: 1987 – 2008 Month: 1 – 12 FlightNum: Flight number Canceled: Was the flight canceled? CancelleationCode: The reason for cancellation.

ANALYSIS: 1.Which month have seen the most number of cancellation due to bad weather?

2.Top 10 route(origin and dest) that has seen maximum diversions? 3.Top 5 visited destination