clickhouse_create_trips.sql

CREATE TABLE trips (
    hvfhs_license_num String,
    dispatching_base_num Nullable(String),
    originating_base_num Nullable(String),
    request_datetime Nullable(DateTime),
    on_scene_datetime Nullable(DateTime),
    pickup_datetime DateTime,
    dropoff_datetime DateTime,
    PULocationID Nullable(Int64),
    DOLocationID Nullable(Int64),
    trip_miles Nullable(Float64),
    trip_time Nullable(Int64),
    base_passenger_fare Nullable(Float64),
    tolls Nullable(Float64),
    bcf Nullable(Float64),
    sales_tax Nullable(Float64),
    congestion_surcharge Nullable(Float64),
    airport_fee Nullable(Float64),
    tips Nullable(Float64),
    driver_pay Nullable(Float64),
    shared_request_flag Nullable(String),
    shared_match_flag Nullable(String),
    access_a_ride_flag Nullable(String),
    wav_request_flag Nullable(String),
    wav_match_flag Nullable(String)
)
ENGINE = MergeTree
PARTITION BY toYYYYMMDD(pickup_datetime)
ORDER BY pickup_datetime;