DokuWiki

User Tools

Site Tools

Trace:
cluster:174

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
cluster:174 [2018/08/27 17:14]
hmeij07 		cluster:174 [2018/08/28 12:38] (current)
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, the MapD SQL engine dynamically compiles SQL to run across multiple GPUs and CPUs. Massively parallel database servers.
 +
 +  * http://www.mapd.com
  
 ** 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 go to port 9092 of node ''n37'' and create a dashboard. Use the "data" subnet (10.10) eth1. 
 + 
 +  * http://n37-eth1:9092 
 + 
 +  - Click New Dashboard. 
 +  - Click Add Chart. 
 +  - Click SCATTER. 
 +  - Click Add Data Source. 
 +  - Choose the flights_2008_7M table as the data source. 
 +  - Click X Axis +Add Measure. 
 +  - Choose depdelay. (departure delay) 
 +  - Click Y Axis +Add Measure. 
 +  - Choose arrdelay. (arrival delay)
  
-  * http://10.10.102.47:9092+7 million records, amazingly fast. I mean  like < 50 ms (milliseconds). There are pie, bar, stacked bar, bubble etc charts and point maps or chloropleth maps. A SQL editor.  And I do not even observe a blip on gpu utilization. Each of these K20 nodes still has 7 drive bays available which would allow for a large database storage platform if we had a mapd project.
  
 +{{ :cluster:dep-arr-scatterplot.png?nolink&400 |}}
  
  
Line 15: Line 32:
  
   * https://www.mapd.com/docs/latest/3_mapdql.html   * https://www.mapd.com/docs/latest/3_mapdql.html
-  * can be scripted too+  * can be scripted using mapdql
  
 <code> <code>
Line 32: Line 49:
 flights_2008_7M flights_2008_7M
  
-mapdql> SELECT origin_city AS "Origin", dest_city AS "Destination", AVG(airtime) AS "Average Airtime" FROM flights_2008_7M WHERE distance < 175 GROUP BY origin_city, dest_city;+mapdql> SELECT origin_city AS "Origin", dest_city AS "Destination",  
 +- AVG(airtime) AS "Average Airtime" FROM flights_2008_7M  
 +- WHERE distance < 175 GROUP BY origin_city, dest_city;
 ... ...
 Portland|North Bend|46.12162162162162 Portland|North Bend|46.12162162162162
Line 80: Line 99:
 </code> </code>
  
 +  * https://www.mapd.com/docs/latest/4_centos7-yum-gpu-ce-recipe.html
  
 \\ \\
 **[[cluster:0|Back]]** **[[cluster:0|Back]]**
cluster/174.1535390079.txt.gz · Last modified: 2018/08/27 17:14 by hmeij07

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki