KMfJ4p9L

1create external table if not exists taxi_trips(
2VendorID int,
3tpep_pickup_datetime string,
4tpep_dropoff_datetime string,
5Passenger_count int,
6Trip_distance bigint,
7PULocationID string,
8DOLocationID string,
9RateCodeID int,
10Store_and_fwd_flag string,
11Payment_type int,
12Fare_amount bigint,
13Extra float,
14MTA_tax float,
15Improvement_surcharge float,
16Tip_amount float,
17Tolls_amount float,
18Total_amount float,
19)
20ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
21with serdeproperties  ('paths' = '')
22location '/user/varun'
23tblproperties ("skip.header.line.count"="1", "orc.compress"="SNAPPY");