This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
cluster:174 [2018/08/27 18:03] hmeij07 |
cluster:174 [2018/08/27 18:21] hmeij07 |
||
---|---|---|---|
Line 3: | Line 3: | ||
==== SQL on GPU ==== | ==== SQL on GPU ==== | ||
+ | |||
+ | MapD built the first ever open source SQL engine to harness GPU computing for analytics. Designed for maximum performance, | ||
+ | |||
+ | * http:// | ||
** Browser ** | ** Browser ** | ||
- | Log into one of the tails like petal, swallowtail or cottontail2 preferably, and with x11-forwarding enabled | + | Log into one of the tails like petaltail, swallowtail or cottontail2 preferably, and with x11-forwarding enabled |
* http:// | * http:// | ||
Line 19: | Line 23: | ||
- Choose arrdelay. | - Choose arrdelay. | ||
- | 7 million records, amazingly fast. There are pie, bar, stacked bar, bubble etc charts and point maps or chloropleth maps. A SQL editor. | + | 7 million records, amazingly fast I mean like < 50 ms. There are pie, bar, stacked bar, bubble etc charts and point maps or chloropleth maps. A SQL editor. |
+ | {{ : | ||
Line 44: | Line 48: | ||
flights_2008_7M | flights_2008_7M | ||
- | mapdql> SELECT origin_city AS " | + | mapdql> SELECT origin_city AS " |
+ | - AVG(airtime) AS " | ||
+ | - WHERE distance < 175 GROUP BY origin_city, | ||
... | ... | ||
Portland|North Bend|46.12162162162162 | Portland|North Bend|46.12162162162162 |