Airline Performance Data

**Overview**
This dataset contains detailed information on airline flight performance, spanning several years, and includes metrics such as flight delays, carrier identifiers, and aircraft details. The same data is available in three optimized versions to meet the needs of various types of analysis and queries. There are over 1.2 billion rows (1,235,347,780), covering multiple years of flight data.
The three tables contain the same data but using different Delta storage optimization techniques.

1. flights (Z-Ordered by FlightNum)
2. flights_cluster_id (Clustered by ID)
3. flights_cluster_id_flightnum (Clustered by ID and FlightNum)

Columns (Across All Versions):

1. ID: Unique ID for each row
2. Year: The year the flight took place.
3. FlightNum: The flight number.
4. ArrDelay: The arrival delay in minutes (positive values indicate delayed flights).
5. UniqueCarrier: The airline carrier code.
6. TailNum: The aircraft’s tail number, representing the individual plane.

**Use cases**
This data is primarily for use by Databricks Academy to support course delivery.

搜集汇总

背景与挑战

背景概述

该数据集包含多年航班运行性能数据，涵盖12亿条记录，主要指标包括航班延误、承运商代码和飞机详情。提供三种优化版本以适应不同查询需求，主要用于Databricks Academy的教学支持。