4QN1B3g6

1CREATE EXTERNAL TABLE IF NOT EXISTS nyctaxi.canonicaldata (
2  VendorID INT, 
3  pickup_date TIMESTAMP, 
4  dropoff_date TIMESTAMP, 
5  passenger_count BIGINT, 
6  trip_distance DOUBLE, 
7  pickup_longitude DOUBLE, 
8  pickup_latitude DOUBLE, 
9  RatecodeID BIGINT, 
10  store_and_fwd_flag STRING, 
11  dropoff_longitude DOUBLE, 
12  dropoff_latitude DOUBLE, 
13  payment_type INT, 
14  fare_amount DOUBLE, 
15  extra DOUBLE, 
16  mta_tax DOUBLE, 
17  tip_amount DOUBLE, 
18  tolls_amount DOUBLE, 
19  improvement_surcharge DOUBLE, 
20  total_amount DOUBLE, type STRING ) 
21  STORED AS PARQUET 
22  LOCATION 's3://aws301-myname-data/parquet/' 
23  TBLPROPERTIES ('classification'='parquet')