Designed from the ground up to run on GPUs, MapD Core is an in-memory, column store, relational database that can deliver exceptional speed at scale. By taking advantage of the parallel processing power of the hardware, MapD Core can query billions of rows in milliseconds using standard SQL. Think of it as supercomputing for everyone—no GPU experience required.
|Query 1||`select carrier_name, avg(arrdelay) from flights group by carrier_name`|
|Query 2||`select origin_name, dest_name, avg(arrdelay) from flights group by origin_name, dest_name`|
|Query 3||`select date_trunc(month,dep_timestamp) as ym, avg(arrdelay) as del from flights group by ym`|
|Query 4||`select dest_name, extract(month from dep_timestamp) as m, extract(year from dep_timestamp) as y, avg(arrdelay) as del from flights group by dest_name,y,m`|
|Query 5||`select count(*) from flights where origin_name='Lambert-St Louis International' and dest_name = 'Lincoln Municipal'`|