MapD Core is an open-source SQL engine architected on GPUs. MapD Core exploits the parallel processing power of GPU hardware to query billions of rows in milliseconds using standard SQL. Because the MapD Platform leverages the full graphics pipeline for server-side visual rendering, its visual analytics are far faster and more responsive than technologies that execute queries on the GPU but then render them on CPUs.
|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;|