DDL

CREATE TABLE OTP ( `Year` string ,
`Quarter` string ,
`Month` string ,
`DayofMonth` string ,
`DayOfWeek` string ,
`FlightDate` string ,
`UniqueCarrier` string ,
`AirlineID` string ,
`Carrier` string ,
`TailNum` string ,
`FlightNum` string ,
`OriginAirportID` string ,
`OriginAirportSeqID` string ,
`OriginCityMarketID` string ,
`Origin` string ,
`OriginCityName` string ,
`OriginState` string ,
`OriginStateFips` string ,
`OriginStateName` string ,
`OriginWac` string ,
`DestAirportID` string ,
`DestAirportSeqID` string ,
`DestCityMarketID` string ,
`Dest` string ,
`DestCityName` string ,
`DestState` string ,
`DestStateFips` string ,
`DestStateName` string ,
`DestWac` string ,
`CRSDepTime` string ,
`DepTime` string ,
`DepDelay` string ,
`DepDelayMinutes` string ,
`DepDel15` string ,
`DepartureDelayGroups` string ,
`DepTimeBlk` string ,
`TaxiOut` string ,
`WheelsOff` string ,
`WheelsOn` string ,
`TaxiIn` string ,
`CRSArrTime` string ,
`ArrTime` string ,
`ArrDelay` string ,
`ArrDelayMinutes` string ,
`ArrDel15` string ,
`ArrivalDelayGroups` string ,
`ArrTimeBlk` string ,
`Cancelled` string ,
`CancellationCode` string ,
`Diverted` string ,
`CRSElapsedTime` string ,
`ActualElapsedTime` string ,
`AirTime` string ,
`Flights` string ,
`Distance` string ,
`DistanceGroup` string ,
`CarrierDelay` string ,
`WeatherDelay` string ,
`NASDelay` string ,
`SecurityDelay` string ,
`LateAircraftDelay` string ,
`FirstDepTime` string ,
`TotalAddGTime` string ,
`LongestAddGTime` string ,
`DivAirportLandings` string ,
`DivReachedDest` string ,
`DivActualElapsedTime` string ,
`DivArrDelay` string ,
`DivDistance` string ,
`Div1Airport` string ,
`Div1AirportID` string ,
`Div1AirportSeqID` string ,
`Div1WheelsOn` string ,
`Div1TotalGTime` string ,
`Div1LongestGTime` string ,
`Div1WheelsOff` string ,
`Div1TailNum` string ,
`Div2Airport` string ,
`Div2AirportID` string ,
`Div2AirportSeqID` string ,
`Div2WheelsOn` string ,
`Div2TotalGTime` string ,
`Div2LongestGTime` string ,
`Div2WheelsOff` string ,
`Div2TailNum` string ,
`Div3Airport` string ,
`Div3AirportID` string ,
`Div3AirportSeqID` string ,
`Div3WheelsOn` string ,
`Div3TotalGTime` string ,
`Div3LongestGTime` string ,
`Div3WheelsOff` string ,
`Div3TailNum` string ,
`Div4Airport` string ,
`Div4AirportID` string ,
`Div4AirportSeqID` string ,
`Div4WheelsOn` string ,
`Div4TotalGTime` string ,
`Div4LongestGTime` string ,
`Div4WheelsOff` string ,
`Div4TailNum` string ,
`Div5Airport` string ,
`Div5AirportID` string ,
`Div5AirportSeqID` string ,
`Div5WheelsOn` string ,
`Div5TotalGTime` string ,
`Div5LongestGTime` string ,
`Div5WheelsOff` string ,
`Div5TailNum` string 
 ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ",";