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 14:45] hmeij07 |
cluster:174 [2018/08/27 18:23] 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 ** | ||
+ | |||
+ | Log into one of the tails like petaltail, swallowtail or cottontail2 preferably, and with x11-forwarding enabled go to port 9092 of node '' | ||
+ | |||
+ | * 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. | ||
+ | |||
+ | {{ : | ||
+ | |||
** Interactive ** | ** Interactive ** | ||
- | https:// | + | * https:// |
+ | * can be scripted too | ||
+ | |||
+ | < | ||
+ | |||
+ | [root@n37 ~]# export MAPD_USER=mapd | ||
+ | [root@n37 ~]# export MAPD_GROUP=mapd | ||
+ | [root@n37 ~]# export MAPD_STORAGE=/ | ||
+ | [root@n37 ~]# export MAPD_PATH=/ | ||
+ | [root@n37 ~]# cd $MAPD_PATH | ||
+ | [root@n37 mapd]# ./ | ||
+ | Password: (HyperInteractive) | ||
+ | User mapd connected to database mapd | ||
+ | mapdql> | ||
mapdql> \t ^flight.* | mapdql> \t ^flight.* | ||
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, | ||
... | ... | ||
- | SELECT origin_city AS " | + | Portland|North Bend|46.12162162162162 |
- | " | + | Medford|North Bend|28 |
- | dest_city; | + | Covington|Huntington|24.98076923076923 |
+ | mapdql> | ||
+ | </ | ||
** Demos ** | ** Demos ** | ||
- | https:// | + | * https:// |
- | + | ||
** Load sample ** | ** Load sample ** | ||
< | < | ||
- | /opt/mapd | + | |
+ | /opt/mapd/ | ||
Enter dataset number to download, or ' | Enter dataset number to download, or ' | ||
# | # |