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 17:14] 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:// | ||
+ | - Click New Dashboard. | ||
+ | - Click Add Chart. | ||
+ | - Click SCATTER. | ||
+ | - Click Add Data Source. | ||
+ | - Choose the flights_2008_10k table as the data source. | ||
+ | - Click X Axis +Add Measure. | ||
+ | - Choose depdelay. | ||
+ | - Click Y Axis +Add Measure. | ||
+ | - Choose arrdelay. | ||
+ | |||
+ | 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 32: | 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 |