For reference these are the table names: trips_64mb trips_256mb trips_1024mb CREATE EXTERNAL TABLE trips_64mb ( trip_id INT, vendor_id STRING, pickup_datetime…
Continue Readingsmallint
A Billion Taxi Rides on Amazon EMR running Presto
$ screen $ hive CREATE EXTERNAL TABLE trips_csv ( trip_id INT, vendor_id VARCHAR(3), pickup_datetime TIMESTAMP, dropoff_datetime TIMESTAMP, store_and_fwd_flag VARCHAR(1), rate_code_id…
Continue Reading