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 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'`|