()
| 28 | } |
| 29 | |
| 30 | public void createTableAirline() throws DDFException { |
| 31 | manager.sql("drop table if exists airline", "SparkSQL"); |
| 32 | |
| 33 | manager.sql("create table airline (Year int,Month int,DayofMonth int," |
| 34 | + "DayOfWeek int,DepTime int,CRSDepTime int,ArrTime int," |
| 35 | + "CRSArrTime int,UniqueCarrier string, FlightNum int, " |
| 36 | + "TailNum string, ActualElapsedTime int, CRSElapsedTime int, " |
| 37 | + "AirTime int, ArrDelay int, DepDelay int, Origin string, " |
| 38 | + "Dest string, Distance int, TaxiIn int, TaxiOut int, Cancelled int, " |
| 39 | + "CancellationCode string, Diverted string, CarrierDelay int, " |
| 40 | + "WeatherDelay int, NASDelay int, SecurityDelay int, LateAircraftDelay int ) " |
| 41 | + "ROW FORMAT DELIMITED FIELDS TERMINATED BY ','", "SparkSQL"); |
| 42 | |
| 43 | manager.sql("load data local inpath '../resources/test/airline.csv' into table airline", "SparkSQL"); |
| 44 | |
| 45 | } |
| 46 | |
| 47 | public void createTableAirlineBigInt() throws DDFException { |
| 48 | manager.sql("drop table if exists airline_bigint", "SparkSQL"); |
no test coverage detected