createTableYellowTaxi_2009_2014.q

CREATE EXTERNAL TABLE yellow_taxi_2009_2014 (
    vendorID            VARCHAR(3),
    pickup_datetime     TIMESTAMP,
    dropoff_datetime    TIMESTAMP,
    passenger_count     SMALLINT,
    trip_distance       DECIMAL(6,3),
    pickup_longitude    DECIMAL(9,6),
    pickup_latitude     DECIMAL(9,6),
    ratecodeID          SMALLINT,
    store_and_fwd_flag  VARCHAR(1),
    dropoff_longitude   DECIMAL(9,6),
    dropoff_latitude    DECIMAL(9,6),
    payment_type        VARCHAR(10),
    fare_amount         DECIMAL(6,2),
    extra               DECIMAL(6,2),
    mta_tax             DECIMAL(6,2),
    tip_amount          DECIMAL(6,2),
    tolls_amount        DECIMAL(6,2),
    total_amount        DECIMAL(6,2)
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
LOCATION 's3a://nyctaxidataset/yellow_taxi/yellow_taxi_2009_2014/'
tblproperties("skip.header.line.count"="1");