…documentation), but finally I ended up with next load statement: …DestCityName ORDER BY 2 DESC LIMIT 10; Years, InfoBright, MonetDB …2005 | 7140596 | | 2006 | 7141922 | | 2007 | 7455458 | | 2008 | 7009728 | +——+———+ And execution time: MonetDB: 6.3s and InfoBright: 0.31s To group all results…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…JOIN dim_date using (date_id) WHERE DepDelay>10 AND Year BETWEEN 2000 AND 2008 GROUP … benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the most striking…. Year BETWEEN 2001 and 2005 GROUP BY dest.CityName ORDER BY 2 DESC; — Q8.2 SELECT dest.CityName, COUNT(…
