This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE trips ( | |
trip_id UInt32, | |
vendor_id String, | |
pickup_datetime DateTime, | |
dropoff_datetime Nullable(DateTime), | |
store_and_fwd_flag Nullable(FixedString(1)), | |
rate_code_id Nullable(UInt8), | |
pickup_longitude Nullable(Float64), | |
pickup_latitude Nullable(Float64), | |
dropoff_longitude Nullable(Float64), | |
dropoff_latitude Nullable(Float64), | |
passenger_count Nullable(UInt8), | |
trip_distance Nullable(Float64), | |
fare_amount Nullable(Float32), | |
extra Nullable(Float32), | |
mta_tax Nullable(Float32), | |
tip_amount Nullable(Float32), | |
tolls_amount Nullable(Float32), | |
ehail_fee Nullable(Float32), | |
improvement_surcharge Nullable(Float32), | |
total_amount Nullable(Float32), | |
payment_type Nullable(String), | |
trip_type Nullable(UInt8), | |
pickup Nullable(String), | |
dropoff Nullable(String), | |
cab_type Nullable(String), | |
precipitation Nullable(Float32), | |
snow_depth Nullable(Int8), | |
snowfall Nullable(Float32), | |
max_temperature Nullable(Int8), | |
min_temperature Nullable(Int8), | |
average_wind_speed Nullable(Float32), | |
pickup_nyct2010_gid Nullable(Int8), | |
pickup_ctlabel Nullable(String), | |
pickup_borocode Nullable(Int8), | |
pickup_boroname Nullable(String), | |
pickup_ct2010 Nullable(String), | |
pickup_boroct2010 Nullable(String), | |
pickup_cdeligibil Nullable(FixedString(1)), | |
pickup_ntacode Nullable(String), | |
pickup_ntaname Nullable(String), | |
pickup_puma Nullable(String), | |
dropoff_nyct2010_gid Nullable(UInt8), | |
dropoff_ctlabel Nullable(String), | |
dropoff_borocode Nullable(UInt8), | |
dropoff_boroname Nullable(String), | |
dropoff_ct2010 Nullable(String), | |
dropoff_boroct2010 Nullable(String), | |
dropoff_cdeligibil Nullable(String), | |
dropoff_ntacode Nullable(String), | |
dropoff_ntaname Nullable(String), | |
dropoff_puma Nullable(String) | |
) ENGINE = Log; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment