CREATE EXTERNAL TABLE IF NOT EXISTS `default`.`taxidropoff_csv` (
    `dropoff_city` VARCHAR(255),
    `pickup_hour_of_day` INT,
    `dropoff_airport` STRING,
    `dropoff_hour_of_day` INT,
    `dropoff_time_block` STRING,
    `trip_distance` FLOAT,
    `hours_from_midnight_pickup` INT,
    `dropoff_datetime` DATE,
    `dropoff_geocode` STRING,
    `pickup_day_of_week` STRING,
    `dropoff_borough` STRING,
    `passenger_count` INT,
    `pickup_borough` STRING,
    `dropoff_dayhour` STRING,
    `pickup_geocode_geo_city` STRING,
    `Trip_duration_minutes` INT,
    `tip_percentage` INT,
    `tip_amount` INT,
    `mta_tax` FLOAT,
    `total_amount` FLOAT,
    `pickup_geocode` STRING,
    `tolls_amount` INT,
    `fare_amount` FLOAT,
    `Trip_ave_speed` FLOAT,
    `payment_type` STRING
) 
ROW FORMAT DELIMITED
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\n' 
TBLPROPERTIES(
    'skip.header.line.count'='1'
);
LOAD DATA INPATH 'hdfs:///tmp/taxidropoff.csv' INTO TABLE `default`.`taxidropoff_csv`;LOAD DATA INPATH 'hdfs:///tmp/taxidropoff.csv' INTO TABLE `default`.`taxidropoff_csv`;