Database Reference
In-Depth Information
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
/user/administrator/flightinfo';
This should take very little time to finish. Once completed, you can run a
query against the table, such as the following:
SELECT COUNT (*) FROM flightinfo;
A successful query will look like
Figure 3.17
.
