1 글 보임 - 1 에서 1 까지 (총 1 중에서)
  • 글쓴이
  • #9508
    허 진경허 진경
    키 마스터

    CREATE EXTERNAL TABLE IF NOT EXISTS airline (Year int, Month int, DayOfMonth int, DayOfWeek int, DepTime int, CRSDepTime int, ArrTime int, CRSArrTime int, UniqueCarrier string, FlightNum int, TailNum string, ActualElapsedTime int, CRSElapsedTime int, AirTime int, ArrDelay int, DepDelay int, Origin string, Dest string, Distance int, TaxiIn int, TaxiOut int, Cancelled int, CancellationCode string, Diverted string, CarrierDelay int, WeatherDelay int, NASDelay int, SecurityDelay int, LateAircraftDelay int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ LOCATION ‘/airline’;

    SELECT year, month, count(month) FROM airline WHERE arrdelay > 0 GROUP BY year, month ORDER BY year, month;

1 글 보임 - 1 에서 1 까지 (총 1 중에서)

답변은 로그인 후 가능합니다. Login here