MapD Core is an in-memory, column store, SQL relational database that was designed from the ground up to run on GPUs. The parallel processing power of GPU hardware enables the MapD Core database to query billions of rows in milliseconds using standard SQL.
|Query 1||SELECT cab_type, count() FROM trips GROUP BY cab_type;|
|Query 2||SELECT passenger_count, avg(total_amount) FROM trips GROUP BY passenger_count;|
|Query 3||SELECT passenger_count, extract(year from pickup_datetime) AS pickup_year, count() FROM trips GROUP BY passenger_count, pickup_year;|
|Query 4||SELECT passenger_count, extract(year from pickup_datetime) AS pickup_year, cast(trip_distance as int) AS distance, count(*) AS the_count FROM trips GROUP BY passenger_count, pickup_year, distance ORDER BY pickup_year, the_count desc;|