Skip to content

Instantly share code, notes, and snippets.

@vitillo
Created February 28, 2017 14:51
Show Gist options
  • Save vitillo/d50088d3fcabe3dcc5cec8f8aff98ac8 to your computer and use it in GitHub Desktop.
Save vitillo/d50088d3fcabe3dcc5cec8f8aff98ac8 to your computer and use it in GitHub Desktop.
{"paragraphs":[{"text":"%md\n\n##Welcome to Zeppelin.\n####This is a live tutorial, you can run the code yourself. (Shift-Enter to Run)\n","dateUpdated":"2017-02-28T13:48:48+0000","config":{"tableHide":false,"colWidth":12,"editorMode":"ace/mode/markdown","editorHide":true,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691068_-996268266","id":"20170224-141003_1862458520","result":{"code":"SUCCESS","type":"HTML","msg":"<h2>Welcome to Zeppelin.</h2>\n<h4>This is a live tutorial, you can run the code yourself. (Shift-Enter to Run)</h4>\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:226","dateFinished":"2017-02-28T13:48:49+0000","dateStarted":"2017-02-28T13:48:48+0000","focus":true},{"text":"%md \n\nIn this short tutorial we will load some data from Python and query it from SQL & Scala. Compared to Jupyter, [Zeppelin](https://zeppelin.apache.org/) provides a better integration with Spark, in particular it\n- allows multiple languages (i.e. Python, Scala & SQL) to share the same Spark context within a notebook;\n- comes out of the box with a Spark progress bar;\n- allows the current Spark job to be cancelled;\n- comes with simple plotting tools that are particularly attractive when combined with SQL. \n\nJupyter is still king in other areas, like auto-completion and matplotlib support, for which Zeppelin has only a basic support. Furthermore, neither RTMO nor Github can render Zeppelin notebooks yet. \n","dateUpdated":"2017-02-28T14:03:20+0000","config":{"colWidth":12,"editorMode":"ace/mode/markdown","graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorHide":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691068_-996268266","id":"20170224-141147_107877359","result":{"code":"SUCCESS","type":"HTML","msg":"<p>In this short tutorial we will load some data from Python and query it from SQL &amp; Scala. Compared to Jupyter, <a href=\"https://zeppelin.apache.org/\">Zeppelin</a> provides a better integration with Spark, in particular it</p>\n<ul>\n<li>allows multiple languages (i.e. Python, Scala &amp; SQL) to share the same Spark context within a notebook;</li>\n<li>comes out of the box with a Spark progress bar;</li>\n<li>allows the current Spark job to be cancelled;</li>\n<li>comes with simple plotting tools that are particularly attractive when combined with SQL.</li>\n</ul>\n<p>Jupyter is still king in other areas, like auto-completion and matplotlib support, for which Zeppelin has only a basic support. Furthermore, neither RTMO nor Github can render Zeppelin notebooks yet.</p>\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:227","focus":true,"dateFinished":"2017-02-28T14:03:16+0000","dateStarted":"2017-02-28T14:03:16+0000"},{"text":"%pyspark \n\nfrom moztelemetry import get_pings_properties\nfrom moztelemetry.dataset import Dataset\n\npings = Dataset.from_source(\"telemetry\") \\\n .where(docType='main') \\\n .where(submissionDate=\"20170224\") \\\n .where(appUpdateChannel=\"nightly\") \\\n .records(sc, sample=0.1)\n \nsubset = get_pings_properties(pings, [\"environment/system/os/name\",\n \"payload/simpleMeasurements/firstPaint\"])\n \nsubset.toDF().createOrReplaceTempView(\"nightly_sample\") ","dateUpdated":"2017-02-28T13:55:06+0000","config":{"colWidth":12,"editorMode":"ace/mode/scala","tableHide":false,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691069_-996653015","id":"20170224-135041_118327965","result":{"code":"SUCCESS","type":"TEXT","msg":"Unable to parse whitelist (/home/hadoop/anaconda2/lib/python2.7/site-packages/moztelemetry/histogram-whitelists.json). Assuming all histograms are acceptable.\n/usr/lib/spark/python/pyspark/sql/session.py:336: UserWarning:\n\nUsing RDD of dict to inferSchema is deprecated. Use pyspark.sql.Row instead\n\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:228","dateFinished":"2017-02-28T13:52:22+0000","dateStarted":"2017-02-28T13:51:21+0000","focus":true},{"config":{"colWidth":12,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorMode":"ace/mode/markdown","editorHide":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488290136438_1538793270","id":"20170228-135536_141565591","dateCreated":"2017-02-28T13:55:36+0000","status":"FINISHED","progressUpdateIntervalMs":500,"focus":true,"$$hashKey":"object:1002","text":"%md\nDisplaying matplotlib plots is different than with Jupyter and requires to invoke the `show` function.","dateUpdated":"2017-02-28T13:56:27+0000","dateFinished":"2017-02-28T13:56:24+0000","dateStarted":"2017-02-28T13:56:24+0000","result":{"code":"SUCCESS","type":"HTML","msg":"<p>Displaying matplotlib plots is different than with Jupyter and requires to invoke the <code>show</code> function.</p>\n"}},{"text":"%pyspark\n\nimport matplotlib.pyplot as plt\nimport pandas as pd\nimport numpy as np\n\nfrom moztelemetry.zeppelin import show\n\nfig = plt.figure()\nframe = pd.DataFrame(subset.collect())\nnp.log(frame[\"payload/simpleMeasurements/firstPaint\"]).plot(kind=\"hist\", bins=100)\nshow(plt)","dateUpdated":"2017-02-28T13:56:33+0000","config":{"colWidth":12,"editorMode":"ace/mode/scala","graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691069_-996653015","id":"20170224-145456_1997683137","result":{"code":"SUCCESS","type":"HTML","msg":"<div style='width:600px'><?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\n<!DOCTYPE svg PUBLIC \"-//W3C//DTD SVG 1.1//EN\"\n \"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd\">\n<!-- Created with matplotlib (http://matplotlib.org/) -->\n<svg height=\"432pt\" version=\"1.1\" viewBox=\"0 0 576 432\" width=\"576pt\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\">\n <defs>\n <style type=\"text/css\">\n*{stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:100000;}\n </style>\n </defs>\n <g id=\"figure_1\">\n <g id=\"patch_1\">\n <path d=\"M 0 432 \nL 576 432 \nL 576 0 \nL 0 0 \nz\n\" style=\"fill:#ffffff;\"/>\n </g>\n <g id=\"axes_1\">\n <g id=\"patch_2\">\n <path d=\"M 72 388.8 \nL 518.4 388.8 \nL 518.4 43.2 \nL 72 43.2 \nz\n\" style=\"fill:#ffffff;\"/>\n </g>\n <g id=\"patch_3\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 110.805414 388.8 \nL 114.807203 388.8 \nL 114.807203 388.224 \nL 110.805414 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_4\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 114.807203 388.8 \nL 118.808992 388.8 \nL 118.808992 388.224 \nL 114.807203 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_5\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 118.808992 388.8 \nL 122.810781 388.8 \nL 122.810781 387.648 \nL 118.808992 387.648 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_6\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 122.810781 388.8 \nL 126.81257 388.8 \nL 126.81257 386.496 \nL 122.810781 386.496 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_7\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 126.81257 388.8 \nL 130.814358 388.8 \nL 130.814358 385.92 \nL 126.81257 385.92 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_8\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 130.814358 388.8 \nL 134.816147 388.8 \nL 134.816147 378.432 \nL 130.814358 378.432 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_9\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 134.816147 388.8 \nL 138.817936 388.8 \nL 138.817936 365.76 \nL 134.816147 365.76 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_10\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 138.817936 388.8 \nL 142.819725 388.8 \nL 142.819725 342.144 \nL 138.817936 342.144 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_11\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 142.819725 388.8 \nL 146.821514 388.8 \nL 146.821514 319.104 \nL 142.819725 319.104 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_12\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 146.821514 388.8 \nL 150.823302 388.8 \nL 150.823302 292.032 \nL 146.821514 292.032 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_13\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 150.823302 388.8 \nL 154.825091 388.8 \nL 154.825091 262.08 \nL 150.823302 262.08 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_14\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 154.825091 388.8 \nL 158.82688 388.8 \nL 158.82688 238.464 \nL 154.825091 238.464 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_15\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 158.82688 388.8 \nL 162.828669 388.8 \nL 162.828669 227.52 \nL 158.82688 227.52 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_16\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 162.828669 388.8 \nL 166.830458 388.8 \nL 166.830458 192.96 \nL 162.828669 192.96 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_17\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 166.830458 388.8 \nL 170.832247 388.8 \nL 170.832247 171.648 \nL 166.830458 171.648 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_18\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 170.832247 388.8 \nL 174.834035 388.8 \nL 174.834035 153.216 \nL 170.832247 153.216 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_19\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 174.834035 388.8 \nL 178.835824 388.8 \nL 178.835824 139.968 \nL 174.834035 139.968 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_20\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 178.835824 388.8 \nL 182.837613 388.8 \nL 182.837613 124.992 \nL 178.835824 124.992 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_21\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 182.837613 388.8 \nL 186.839402 388.8 \nL 186.839402 85.248 \nL 182.837613 85.248 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_22\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 186.839402 388.8 \nL 190.841191 388.8 \nL 190.841191 102.528 \nL 186.839402 102.528 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_23\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 190.841191 388.8 \nL 194.84298 388.8 \nL 194.84298 83.52 \nL 190.841191 83.52 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_24\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 194.84298 388.8 \nL 198.844768 388.8 \nL 198.844768 108.288 \nL 194.84298 108.288 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_25\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 198.844768 388.8 \nL 202.846557 388.8 \nL 202.846557 127.872 \nL 198.844768 127.872 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_26\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 202.846557 388.8 \nL 206.848346 388.8 \nL 206.848346 114.048 \nL 202.846557 114.048 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_27\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 206.848346 388.8 \nL 210.850135 388.8 \nL 210.850135 121.536 \nL 206.848346 121.536 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_28\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 210.850135 388.8 \nL 214.851924 388.8 \nL 214.851924 140.544 \nL 210.850135 140.544 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_29\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 214.851924 388.8 \nL 218.853713 388.8 \nL 218.853713 144.576 \nL 214.851924 144.576 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_30\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 218.853713 388.8 \nL 222.855501 388.8 \nL 222.855501 177.984 \nL 218.853713 177.984 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_31\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 222.855501 388.8 \nL 226.85729 388.8 \nL 226.85729 149.76 \nL 222.855501 149.76 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_32\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 226.85729 388.8 \nL 230.859079 388.8 \nL 230.859079 198.144 \nL 226.85729 198.144 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_33\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 230.859079 388.8 \nL 234.860868 388.8 \nL 234.860868 184.32 \nL 230.859079 184.32 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_34\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 234.860868 388.8 \nL 238.862657 388.8 \nL 238.862657 199.872 \nL 234.860868 199.872 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_35\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 238.862657 388.8 \nL 242.864445 388.8 \nL 242.864445 234.432 \nL 238.862657 234.432 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_36\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 242.864445 388.8 \nL 246.866234 388.8 \nL 246.866234 235.008 \nL 242.864445 235.008 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_37\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 246.866234 388.8 \nL 250.868023 388.8 \nL 250.868023 238.464 \nL 246.866234 238.464 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_38\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 250.868023 388.8 \nL 254.869812 388.8 \nL 254.869812 252.288 \nL 250.868023 252.288 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_39\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 254.869812 388.8 \nL 258.871601 388.8 \nL 258.871601 279.36 \nL 254.869812 279.36 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_40\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 258.871601 388.8 \nL 262.87339 388.8 \nL 262.87339 293.76 \nL 258.871601 293.76 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_41\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 262.87339 388.8 \nL 266.875178 388.8 \nL 266.875178 282.816 \nL 262.87339 282.816 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_42\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 266.875178 388.8 \nL 270.876967 388.8 \nL 270.876967 312.192 \nL 266.875178 312.192 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_43\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 270.876967 388.8 \nL 274.878756 388.8 \nL 274.878756 305.28 \nL 270.876967 305.28 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_44\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 274.878756 388.8 \nL 278.880545 388.8 \nL 278.880545 307.584 \nL 274.878756 307.584 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_45\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 278.880545 388.8 \nL 282.882334 388.8 \nL 282.882334 339.264 \nL 278.880545 339.264 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_46\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 282.882334 388.8 \nL 286.884123 388.8 \nL 286.884123 327.168 \nL 282.882334 327.168 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_47\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 286.884123 388.8 \nL 290.885911 388.8 \nL 290.885911 342.144 \nL 286.884123 342.144 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_48\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 290.885911 388.8 \nL 294.8877 388.8 \nL 294.8877 347.328 \nL 290.885911 347.328 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_49\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 294.8877 388.8 \nL 298.889489 388.8 \nL 298.889489 335.808 \nL 294.8877 335.808 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_50\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 298.889489 388.8 \nL 302.891278 388.8 \nL 302.891278 354.816 \nL 298.889489 354.816 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_51\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 302.891278 388.8 \nL 306.893067 388.8 \nL 306.893067 361.728 \nL 302.891278 361.728 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_52\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 306.893067 388.8 \nL 310.894856 388.8 \nL 310.894856 361.728 \nL 306.893067 361.728 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_53\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 310.894856 388.8 \nL 314.896644 388.8 \nL 314.896644 363.456 \nL 310.894856 363.456 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_54\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 314.896644 388.8 \nL 318.898433 388.8 \nL 318.898433 371.52 \nL 314.896644 371.52 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_55\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 318.898433 388.8 \nL 322.900222 388.8 \nL 322.900222 375.552 \nL 318.898433 375.552 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_56\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 322.900222 388.8 \nL 326.902011 388.8 \nL 326.902011 355.392 \nL 322.900222 355.392 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_57\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 326.902011 388.8 \nL 330.9038 388.8 \nL 330.9038 377.856 \nL 326.902011 377.856 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_58\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 330.9038 388.8 \nL 334.905589 388.8 \nL 334.905589 376.704 \nL 330.9038 376.704 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_59\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 334.905589 388.8 \nL 338.907377 388.8 \nL 338.907377 379.008 \nL 334.905589 379.008 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_60\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 338.907377 388.8 \nL 342.909166 388.8 \nL 342.909166 381.312 \nL 338.907377 381.312 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_61\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 342.909166 388.8 \nL 346.910955 388.8 \nL 346.910955 379.584 \nL 342.909166 379.584 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_62\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 346.910955 388.8 \nL 350.912744 388.8 \nL 350.912744 383.616 \nL 346.910955 383.616 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_63\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 350.912744 388.8 \nL 354.914533 388.8 \nL 354.914533 376.128 \nL 350.912744 376.128 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_64\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 354.914533 388.8 \nL 358.916321 388.8 \nL 358.916321 379.008 \nL 354.914533 379.008 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_65\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 358.916321 388.8 \nL 362.91811 388.8 \nL 362.91811 384.768 \nL 358.916321 384.768 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_66\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 362.91811 388.8 \nL 366.919899 388.8 \nL 366.919899 384.768 \nL 362.91811 384.768 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_67\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 366.919899 388.8 \nL 370.921688 388.8 \nL 370.921688 385.344 \nL 366.919899 385.344 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_68\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 370.921688 388.8 \nL 374.923477 388.8 \nL 374.923477 377.28 \nL 370.921688 377.28 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_69\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 374.923477 388.8 \nL 378.925266 388.8 \nL 378.925266 385.92 \nL 374.923477 385.92 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_70\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 378.925266 388.8 \nL 382.927054 388.8 \nL 382.927054 386.496 \nL 378.925266 386.496 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_71\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 382.927054 388.8 \nL 386.928843 388.8 \nL 386.928843 388.224 \nL 382.927054 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_72\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 386.928843 388.8 \nL 390.930632 388.8 \nL 390.930632 387.648 \nL 386.928843 387.648 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_73\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 390.930632 388.8 \nL 394.932421 388.8 \nL 394.932421 388.224 \nL 390.930632 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_74\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 394.932421 388.8 \nL 398.93421 388.8 \nL 398.93421 388.8 \nL 394.932421 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_75\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 398.93421 388.8 \nL 402.935999 388.8 \nL 402.935999 387.072 \nL 398.93421 387.072 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_76\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 402.935999 388.8 \nL 406.937787 388.8 \nL 406.937787 387.072 \nL 402.935999 387.072 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_77\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 406.937787 388.8 \nL 410.939576 388.8 \nL 410.939576 385.344 \nL 406.937787 385.344 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_78\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 410.939576 388.8 \nL 414.941365 388.8 \nL 414.941365 386.496 \nL 410.939576 386.496 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_79\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 414.941365 388.8 \nL 418.943154 388.8 \nL 418.943154 388.224 \nL 414.941365 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_80\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 418.943154 388.8 \nL 422.944943 388.8 \nL 422.944943 388.224 \nL 418.943154 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_81\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 422.944943 388.8 \nL 426.946732 388.8 \nL 426.946732 387.072 \nL 422.944943 387.072 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_82\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 426.946732 388.8 \nL 430.94852 388.8 \nL 430.94852 388.8 \nL 426.946732 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_83\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 430.94852 388.8 \nL 434.950309 388.8 \nL 434.950309 388.224 \nL 430.94852 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_84\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 434.950309 388.8 \nL 438.952098 388.8 \nL 438.952098 388.8 \nL 434.950309 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_85\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 438.952098 388.8 \nL 442.953887 388.8 \nL 442.953887 386.496 \nL 438.952098 386.496 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_86\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 442.953887 388.8 \nL 446.955676 388.8 \nL 446.955676 388.8 \nL 442.953887 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_87\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 446.955676 388.8 \nL 450.957464 388.8 \nL 450.957464 388.8 \nL 446.955676 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_88\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 450.957464 388.8 \nL 454.959253 388.8 \nL 454.959253 388.8 \nL 450.957464 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_89\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 454.959253 388.8 \nL 458.961042 388.8 \nL 458.961042 388.8 \nL 454.959253 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_90\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 458.961042 388.8 \nL 462.962831 388.8 \nL 462.962831 388.8 \nL 458.961042 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_91\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 462.962831 388.8 \nL 466.96462 388.8 \nL 466.96462 388.8 \nL 462.962831 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_92\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 466.96462 388.8 \nL 470.966409 388.8 \nL 470.966409 388.8 \nL 466.96462 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_93\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 470.966409 388.8 \nL 474.968197 388.8 \nL 474.968197 388.224 \nL 470.966409 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_94\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 474.968197 388.8 \nL 478.969986 388.8 \nL 478.969986 388.8 \nL 474.968197 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_95\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 478.969986 388.8 \nL 482.971775 388.8 \nL 482.971775 388.224 \nL 478.969986 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_96\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 482.971775 388.8 \nL 486.973564 388.8 \nL 486.973564 388.8 \nL 482.971775 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_97\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 486.973564 388.8 \nL 490.975353 388.8 \nL 490.975353 388.8 \nL 486.973564 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_98\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 490.975353 388.8 \nL 494.977142 388.8 \nL 494.977142 388.8 \nL 490.975353 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_99\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 494.977142 388.8 \nL 498.97893 388.8 \nL 498.97893 388.8 \nL 494.977142 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_100\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 498.97893 388.8 \nL 502.980719 388.8 \nL 502.980719 388.8 \nL 498.97893 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_101\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 502.980719 388.8 \nL 506.982508 388.8 \nL 506.982508 388.8 \nL 502.980719 388.8 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_102\">\n <path clip-path=\"url(#p9e575f5172)\" d=\"M 506.982508 388.8 \nL 510.984297 388.8 \nL 510.984297 388.224 \nL 506.982508 388.224 \nz\n\" style=\"fill:#0000ff;stroke:#000000;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_103\">\n <path d=\"M 72 43.2 \nL 518.4 43.2 \n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_104\">\n <path d=\"M 518.4 388.8 \nL 518.4 43.2 \n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_105\">\n <path d=\"M 72 388.8 \nL 518.4 388.8 \n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"patch_106\">\n <path d=\"M 72 388.8 \nL 72 43.2 \n\" style=\"fill:none;stroke:#000000;stroke-linecap:square;stroke-linejoin:miter;\"/>\n </g>\n <g id=\"matplotlib.axis_1\">\n <g id=\"xtick_1\">\n <g id=\"line2d_1\">\n <defs>\n <path d=\"M 0 0 \nL 0 -4 \n\" id=\"md0a95268ce\" style=\"stroke:#000000;stroke-width:0.5;\"/>\n </defs>\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"116.64\" xlink:href=\"#md0a95268ce\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"line2d_2\">\n <defs>\n <path d=\"M 0 0 \nL 0 4 \n\" id=\"mc23bd74d36\" style=\"stroke:#000000;stroke-width:0.5;\"/>\n </defs>\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"116.64\" xlink:href=\"#mc23bd74d36\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"text_1\">\n <!-- 6 -->\n <defs>\n <path d=\"M 33.015625 40.375 \nQ 26.375 40.375 22.484375 35.828125 \nQ 18.609375 31.296875 18.609375 23.390625 \nQ 18.609375 15.53125 22.484375 10.953125 \nQ 26.375 6.390625 33.015625 6.390625 \nQ 39.65625 6.390625 43.53125 10.953125 \nQ 47.40625 15.53125 47.40625 23.390625 \nQ 47.40625 31.296875 43.53125 35.828125 \nQ 39.65625 40.375 33.015625 40.375 \nM 52.59375 71.296875 \nL 52.59375 62.3125 \nQ 48.875 64.0625 45.09375 64.984375 \nQ 41.3125 65.921875 37.59375 65.921875 \nQ 27.828125 65.921875 22.671875 59.328125 \nQ 17.53125 52.734375 16.796875 39.40625 \nQ 19.671875 43.65625 24.015625 45.921875 \nQ 28.375 48.1875 33.59375 48.1875 \nQ 44.578125 48.1875 50.953125 41.515625 \nQ 57.328125 34.859375 57.328125 23.390625 \nQ 57.328125 12.15625 50.6875 5.359375 \nQ 44.046875 -1.421875 33.015625 -1.421875 \nQ 20.359375 -1.421875 13.671875 8.265625 \nQ 6.984375 17.96875 6.984375 36.375 \nQ 6.984375 53.65625 15.1875 63.9375 \nQ 23.390625 74.21875 37.203125 74.21875 \nQ 40.921875 74.21875 44.703125 73.484375 \nQ 48.484375 72.75 52.59375 71.296875 \n\" id=\"BitstreamVeraSans-Roman-36\"/>\n </defs>\n <g transform=\"translate(112.8225 401.918125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-36\"/>\n </g>\n </g>\n </g>\n <g id=\"xtick_2\">\n <g id=\"line2d_3\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"205.92\" xlink:href=\"#md0a95268ce\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"line2d_4\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"205.92\" xlink:href=\"#mc23bd74d36\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"text_2\">\n <!-- 8 -->\n <defs>\n <path d=\"M 31.78125 34.625 \nQ 24.75 34.625 20.71875 30.859375 \nQ 16.703125 27.09375 16.703125 20.515625 \nQ 16.703125 13.921875 20.71875 10.15625 \nQ 24.75 6.390625 31.78125 6.390625 \nQ 38.8125 6.390625 42.859375 10.171875 \nQ 46.921875 13.96875 46.921875 20.515625 \nQ 46.921875 27.09375 42.890625 30.859375 \nQ 38.875 34.625 31.78125 34.625 \nM 21.921875 38.8125 \nQ 15.578125 40.375 12.03125 44.71875 \nQ 8.5 49.078125 8.5 55.328125 \nQ 8.5 64.0625 14.71875 69.140625 \nQ 20.953125 74.21875 31.78125 74.21875 \nQ 42.671875 74.21875 48.875 69.140625 \nQ 55.078125 64.0625 55.078125 55.328125 \nQ 55.078125 49.078125 51.53125 44.71875 \nQ 48 40.375 41.703125 38.8125 \nQ 48.828125 37.15625 52.796875 32.3125 \nQ 56.78125 27.484375 56.78125 20.515625 \nQ 56.78125 9.90625 50.3125 4.234375 \nQ 43.84375 -1.421875 31.78125 -1.421875 \nQ 19.734375 -1.421875 13.25 4.234375 \nQ 6.78125 9.90625 6.78125 20.515625 \nQ 6.78125 27.484375 10.78125 32.3125 \nQ 14.796875 37.15625 21.921875 38.8125 \nM 18.3125 54.390625 \nQ 18.3125 48.734375 21.84375 45.5625 \nQ 25.390625 42.390625 31.78125 42.390625 \nQ 38.140625 42.390625 41.71875 45.5625 \nQ 45.3125 48.734375 45.3125 54.390625 \nQ 45.3125 60.0625 41.71875 63.234375 \nQ 38.140625 66.40625 31.78125 66.40625 \nQ 25.390625 66.40625 21.84375 63.234375 \nQ 18.3125 60.0625 18.3125 54.390625 \n\" id=\"BitstreamVeraSans-Roman-38\"/>\n </defs>\n <g transform=\"translate(202.1025 401.918125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-38\"/>\n </g>\n </g>\n </g>\n <g id=\"xtick_3\">\n <g id=\"line2d_5\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"295.2\" xlink:href=\"#md0a95268ce\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"line2d_6\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"295.2\" xlink:href=\"#mc23bd74d36\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"text_3\">\n <!-- 10 -->\n <defs>\n <path d=\"M 31.78125 66.40625 \nQ 24.171875 66.40625 20.328125 58.90625 \nQ 16.5 51.421875 16.5 36.375 \nQ 16.5 21.390625 20.328125 13.890625 \nQ 24.171875 6.390625 31.78125 6.390625 \nQ 39.453125 6.390625 43.28125 13.890625 \nQ 47.125 21.390625 47.125 36.375 \nQ 47.125 51.421875 43.28125 58.90625 \nQ 39.453125 66.40625 31.78125 66.40625 \nM 31.78125 74.21875 \nQ 44.046875 74.21875 50.515625 64.515625 \nQ 56.984375 54.828125 56.984375 36.375 \nQ 56.984375 17.96875 50.515625 8.265625 \nQ 44.046875 -1.421875 31.78125 -1.421875 \nQ 19.53125 -1.421875 13.0625 8.265625 \nQ 6.59375 17.96875 6.59375 36.375 \nQ 6.59375 54.828125 13.0625 64.515625 \nQ 19.53125 74.21875 31.78125 74.21875 \n\" id=\"BitstreamVeraSans-Roman-30\"/>\n <path d=\"M 12.40625 8.296875 \nL 28.515625 8.296875 \nL 28.515625 63.921875 \nL 10.984375 60.40625 \nL 10.984375 69.390625 \nL 28.421875 72.90625 \nL 38.28125 72.90625 \nL 38.28125 8.296875 \nL 54.390625 8.296875 \nL 54.390625 0 \nL 12.40625 0 \nz\n\" id=\"BitstreamVeraSans-Roman-31\"/>\n </defs>\n <g transform=\"translate(287.565 401.918125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-31\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"xtick_4\">\n <g id=\"line2d_7\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"384.48\" xlink:href=\"#md0a95268ce\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"line2d_8\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"384.48\" xlink:href=\"#mc23bd74d36\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"text_4\">\n <!-- 12 -->\n <defs>\n <path d=\"M 19.1875 8.296875 \nL 53.609375 8.296875 \nL 53.609375 0 \nL 7.328125 0 \nL 7.328125 8.296875 \nQ 12.9375 14.109375 22.625 23.890625 \nQ 32.328125 33.6875 34.8125 36.53125 \nQ 39.546875 41.84375 41.421875 45.53125 \nQ 43.3125 49.21875 43.3125 52.78125 \nQ 43.3125 58.59375 39.234375 62.25 \nQ 35.15625 65.921875 28.609375 65.921875 \nQ 23.96875 65.921875 18.8125 64.3125 \nQ 13.671875 62.703125 7.8125 59.421875 \nL 7.8125 69.390625 \nQ 13.765625 71.78125 18.9375 73 \nQ 24.125 74.21875 28.421875 74.21875 \nQ 39.75 74.21875 46.484375 68.546875 \nQ 53.21875 62.890625 53.21875 53.421875 \nQ 53.21875 48.921875 51.53125 44.890625 \nQ 49.859375 40.875 45.40625 35.40625 \nQ 44.1875 33.984375 37.640625 27.21875 \nQ 31.109375 20.453125 19.1875 8.296875 \n\" id=\"BitstreamVeraSans-Roman-32\"/>\n </defs>\n <g transform=\"translate(376.845 401.918125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-31\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-32\"/>\n </g>\n </g>\n </g>\n <g id=\"xtick_5\">\n <g id=\"line2d_9\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"473.76\" xlink:href=\"#md0a95268ce\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"line2d_10\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"473.76\" xlink:href=\"#mc23bd74d36\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"text_5\">\n <!-- 14 -->\n <defs>\n <path d=\"M 37.796875 64.3125 \nL 12.890625 25.390625 \nL 37.796875 25.390625 \nz\nM 35.203125 72.90625 \nL 47.609375 72.90625 \nL 47.609375 25.390625 \nL 58.015625 25.390625 \nL 58.015625 17.1875 \nL 47.609375 17.1875 \nL 47.609375 0 \nL 37.796875 0 \nL 37.796875 17.1875 \nL 4.890625 17.1875 \nL 4.890625 26.703125 \nz\n\" id=\"BitstreamVeraSans-Roman-34\"/>\n </defs>\n <g transform=\"translate(466.125 401.918125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-31\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-34\"/>\n </g>\n </g>\n </g>\n </g>\n <g id=\"matplotlib.axis_2\">\n <g id=\"ytick_1\">\n <g id=\"line2d_11\">\n <defs>\n <path d=\"M 0 0 \nL 4 0 \n\" id=\"md3a28625eb\" style=\"stroke:#000000;stroke-width:0.5;\"/>\n </defs>\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"line2d_12\">\n <defs>\n <path d=\"M 0 0 \nL -4 0 \n\" id=\"mafd1f72965\" style=\"stroke:#000000;stroke-width:0.5;\"/>\n </defs>\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"388.8\"/>\n </g>\n </g>\n <g id=\"text_6\">\n <!-- 0 -->\n <g transform=\"translate(60.365 392.11125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"ytick_2\">\n <g id=\"line2d_13\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"331.2\"/>\n </g>\n </g>\n <g id=\"line2d_14\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"331.2\"/>\n </g>\n </g>\n <g id=\"text_7\">\n <!-- 100 -->\n <g transform=\"translate(45.095 334.51125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-31\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n <use x=\"127.24609375\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"ytick_3\">\n <g id=\"line2d_15\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"273.6\"/>\n </g>\n </g>\n <g id=\"line2d_16\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"273.6\"/>\n </g>\n </g>\n <g id=\"text_8\">\n <!-- 200 -->\n <g transform=\"translate(45.095 276.91125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-32\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n <use x=\"127.24609375\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"ytick_4\">\n <g id=\"line2d_17\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"216.0\"/>\n </g>\n </g>\n <g id=\"line2d_18\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"216.0\"/>\n </g>\n </g>\n <g id=\"text_9\">\n <!-- 300 -->\n <defs>\n <path d=\"M 40.578125 39.3125 \nQ 47.65625 37.796875 51.625 33 \nQ 55.609375 28.21875 55.609375 21.1875 \nQ 55.609375 10.40625 48.1875 4.484375 \nQ 40.765625 -1.421875 27.09375 -1.421875 \nQ 22.515625 -1.421875 17.65625 -0.515625 \nQ 12.796875 0.390625 7.625 2.203125 \nL 7.625 11.71875 \nQ 11.71875 9.328125 16.59375 8.109375 \nQ 21.484375 6.890625 26.8125 6.890625 \nQ 36.078125 6.890625 40.9375 10.546875 \nQ 45.796875 14.203125 45.796875 21.1875 \nQ 45.796875 27.640625 41.28125 31.265625 \nQ 36.765625 34.90625 28.71875 34.90625 \nL 20.21875 34.90625 \nL 20.21875 43.015625 \nL 29.109375 43.015625 \nQ 36.375 43.015625 40.234375 45.921875 \nQ 44.09375 48.828125 44.09375 54.296875 \nQ 44.09375 59.90625 40.109375 62.90625 \nQ 36.140625 65.921875 28.71875 65.921875 \nQ 24.65625 65.921875 20.015625 65.03125 \nQ 15.375 64.15625 9.8125 62.3125 \nL 9.8125 71.09375 \nQ 15.4375 72.65625 20.34375 73.4375 \nQ 25.25 74.21875 29.59375 74.21875 \nQ 40.828125 74.21875 47.359375 69.109375 \nQ 53.90625 64.015625 53.90625 55.328125 \nQ 53.90625 49.265625 50.4375 45.09375 \nQ 46.96875 40.921875 40.578125 39.3125 \n\" id=\"BitstreamVeraSans-Roman-33\"/>\n </defs>\n <g transform=\"translate(45.095 219.31125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-33\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n <use x=\"127.24609375\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"ytick_5\">\n <g id=\"line2d_19\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"158.4\"/>\n </g>\n </g>\n <g id=\"line2d_20\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"158.4\"/>\n </g>\n </g>\n <g id=\"text_10\">\n <!-- 400 -->\n <g transform=\"translate(45.095 161.71125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-34\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n <use x=\"127.24609375\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"ytick_6\">\n <g id=\"line2d_21\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"100.8\"/>\n </g>\n </g>\n <g id=\"line2d_22\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"100.8\"/>\n </g>\n </g>\n <g id=\"text_11\">\n <!-- 500 -->\n <defs>\n <path d=\"M 10.796875 72.90625 \nL 49.515625 72.90625 \nL 49.515625 64.59375 \nL 19.828125 64.59375 \nL 19.828125 46.734375 \nQ 21.96875 47.46875 24.109375 47.828125 \nQ 26.265625 48.1875 28.421875 48.1875 \nQ 40.625 48.1875 47.75 41.5 \nQ 54.890625 34.8125 54.890625 23.390625 \nQ 54.890625 11.625 47.5625 5.09375 \nQ 40.234375 -1.421875 26.90625 -1.421875 \nQ 22.3125 -1.421875 17.546875 -0.640625 \nQ 12.796875 0.140625 7.71875 1.703125 \nL 7.71875 11.625 \nQ 12.109375 9.234375 16.796875 8.0625 \nQ 21.484375 6.890625 26.703125 6.890625 \nQ 35.15625 6.890625 40.078125 11.328125 \nQ 45.015625 15.765625 45.015625 23.390625 \nQ 45.015625 31 40.078125 35.4375 \nQ 35.15625 39.890625 26.703125 39.890625 \nQ 22.75 39.890625 18.8125 39.015625 \nQ 14.890625 38.140625 10.796875 36.28125 \nz\n\" id=\"BitstreamVeraSans-Roman-35\"/>\n </defs>\n <g transform=\"translate(45.095 104.11125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-35\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n <use x=\"127.24609375\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"ytick_7\">\n <g id=\"line2d_23\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"72.0\" xlink:href=\"#md3a28625eb\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"line2d_24\">\n <g>\n <use style=\"stroke:#000000;stroke-width:0.5;\" x=\"518.4\" xlink:href=\"#mafd1f72965\" y=\"43.2\"/>\n </g>\n </g>\n <g id=\"text_12\">\n <!-- 600 -->\n <g transform=\"translate(45.095 46.51125)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-36\"/>\n <use x=\"63.623046875\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n <use x=\"127.24609375\" xlink:href=\"#BitstreamVeraSans-Roman-30\"/>\n </g>\n </g>\n </g>\n <g id=\"text_13\">\n <!-- Frequency -->\n <defs>\n <path d=\"M 54.890625 33.015625 \nL 54.890625 0 \nL 45.90625 0 \nL 45.90625 32.71875 \nQ 45.90625 40.484375 42.875 44.328125 \nQ 39.84375 48.1875 33.796875 48.1875 \nQ 26.515625 48.1875 22.3125 43.546875 \nQ 18.109375 38.921875 18.109375 30.90625 \nL 18.109375 0 \nL 9.078125 0 \nL 9.078125 54.6875 \nL 18.109375 54.6875 \nL 18.109375 46.1875 \nQ 21.34375 51.125 25.703125 53.5625 \nQ 30.078125 56 35.796875 56 \nQ 45.21875 56 50.046875 50.171875 \nQ 54.890625 44.34375 54.890625 33.015625 \n\" id=\"BitstreamVeraSans-Roman-6e\"/>\n <path d=\"M 9.8125 72.90625 \nL 51.703125 72.90625 \nL 51.703125 64.59375 \nL 19.671875 64.59375 \nL 19.671875 43.109375 \nL 48.578125 43.109375 \nL 48.578125 34.8125 \nL 19.671875 34.8125 \nL 19.671875 0 \nL 9.8125 0 \nz\n\" id=\"BitstreamVeraSans-Roman-46\"/>\n <path d=\"M 32.171875 -5.078125 \nQ 28.375 -14.84375 24.75 -17.8125 \nQ 21.140625 -20.796875 15.09375 -20.796875 \nL 7.90625 -20.796875 \nL 7.90625 -13.28125 \nL 13.1875 -13.28125 \nQ 16.890625 -13.28125 18.9375 -11.515625 \nQ 21 -9.765625 23.484375 -3.21875 \nL 25.09375 0.875 \nL 2.984375 54.6875 \nL 12.5 54.6875 \nL 29.59375 11.921875 \nL 46.6875 54.6875 \nL 56.203125 54.6875 \nz\n\" id=\"BitstreamVeraSans-Roman-79\"/>\n <path d=\"M 56.203125 29.59375 \nL 56.203125 25.203125 \nL 14.890625 25.203125 \nQ 15.484375 15.921875 20.484375 11.0625 \nQ 25.484375 6.203125 34.421875 6.203125 \nQ 39.59375 6.203125 44.453125 7.46875 \nQ 49.3125 8.734375 54.109375 11.28125 \nL 54.109375 2.78125 \nQ 49.265625 0.734375 44.1875 -0.34375 \nQ 39.109375 -1.421875 33.890625 -1.421875 \nQ 20.796875 -1.421875 13.15625 6.1875 \nQ 5.515625 13.8125 5.515625 26.8125 \nQ 5.515625 40.234375 12.765625 48.109375 \nQ 20.015625 56 32.328125 56 \nQ 43.359375 56 49.78125 48.890625 \nQ 56.203125 41.796875 56.203125 29.59375 \nM 47.21875 32.234375 \nQ 47.125 39.59375 43.09375 43.984375 \nQ 39.0625 48.390625 32.421875 48.390625 \nQ 24.90625 48.390625 20.390625 44.140625 \nQ 15.875 39.890625 15.1875 32.171875 \nz\n\" id=\"BitstreamVeraSans-Roman-65\"/>\n <path d=\"M 8.5 21.578125 \nL 8.5 54.6875 \nL 17.484375 54.6875 \nL 17.484375 21.921875 \nQ 17.484375 14.15625 20.5 10.265625 \nQ 23.53125 6.390625 29.59375 6.390625 \nQ 36.859375 6.390625 41.078125 11.03125 \nQ 45.3125 15.671875 45.3125 23.6875 \nL 45.3125 54.6875 \nL 54.296875 54.6875 \nL 54.296875 0 \nL 45.3125 0 \nL 45.3125 8.40625 \nQ 42.046875 3.421875 37.71875 1 \nQ 33.40625 -1.421875 27.6875 -1.421875 \nQ 18.265625 -1.421875 13.375 4.4375 \nQ 8.5 10.296875 8.5 21.578125 \n\" id=\"BitstreamVeraSans-Roman-75\"/>\n <path d=\"M 41.109375 46.296875 \nQ 39.59375 47.171875 37.8125 47.578125 \nQ 36.03125 48 33.890625 48 \nQ 26.265625 48 22.1875 43.046875 \nQ 18.109375 38.09375 18.109375 28.8125 \nL 18.109375 0 \nL 9.078125 0 \nL 9.078125 54.6875 \nL 18.109375 54.6875 \nL 18.109375 46.1875 \nQ 20.953125 51.171875 25.484375 53.578125 \nQ 30.03125 56 36.53125 56 \nQ 37.453125 56 38.578125 55.875 \nQ 39.703125 55.765625 41.0625 55.515625 \nz\n\" id=\"BitstreamVeraSans-Roman-72\"/>\n <path d=\"M 48.78125 52.59375 \nL 48.78125 44.1875 \nQ 44.96875 46.296875 41.140625 47.34375 \nQ 37.3125 48.390625 33.40625 48.390625 \nQ 24.65625 48.390625 19.8125 42.84375 \nQ 14.984375 37.3125 14.984375 27.296875 \nQ 14.984375 17.28125 19.8125 11.734375 \nQ 24.65625 6.203125 33.40625 6.203125 \nQ 37.3125 6.203125 41.140625 7.25 \nQ 44.96875 8.296875 48.78125 10.40625 \nL 48.78125 2.09375 \nQ 45.015625 0.34375 40.984375 -0.53125 \nQ 36.96875 -1.421875 32.421875 -1.421875 \nQ 20.0625 -1.421875 12.78125 6.34375 \nQ 5.515625 14.109375 5.515625 27.296875 \nQ 5.515625 40.671875 12.859375 48.328125 \nQ 20.21875 56 33.015625 56 \nQ 37.15625 56 41.109375 55.140625 \nQ 45.0625 54.296875 48.78125 52.59375 \n\" id=\"BitstreamVeraSans-Roman-63\"/>\n <path d=\"M 14.796875 27.296875 \nQ 14.796875 17.390625 18.875 11.75 \nQ 22.953125 6.109375 30.078125 6.109375 \nQ 37.203125 6.109375 41.296875 11.75 \nQ 45.40625 17.390625 45.40625 27.296875 \nQ 45.40625 37.203125 41.296875 42.84375 \nQ 37.203125 48.484375 30.078125 48.484375 \nQ 22.953125 48.484375 18.875 42.84375 \nQ 14.796875 37.203125 14.796875 27.296875 \nM 45.40625 8.203125 \nQ 42.578125 3.328125 38.25 0.953125 \nQ 33.9375 -1.421875 27.875 -1.421875 \nQ 17.96875 -1.421875 11.734375 6.484375 \nQ 5.515625 14.40625 5.515625 27.296875 \nQ 5.515625 40.1875 11.734375 48.09375 \nQ 17.96875 56 27.875 56 \nQ 33.9375 56 38.25 53.625 \nQ 42.578125 51.265625 45.40625 46.390625 \nL 45.40625 54.6875 \nL 54.390625 54.6875 \nL 54.390625 -20.796875 \nL 45.40625 -20.796875 \nz\n\" id=\"BitstreamVeraSans-Roman-71\"/>\n </defs>\n <g transform=\"translate(37.599375 247.5571875)rotate(-90.0)scale(0.12 -0.12)\">\n <use xlink:href=\"#BitstreamVeraSans-Roman-46\"/>\n <use x=\"57.41015625\" xlink:href=\"#BitstreamVeraSans-Roman-72\"/>\n <use x=\"98.4921875\" xlink:href=\"#BitstreamVeraSans-Roman-65\"/>\n <use x=\"160.015625\" xlink:href=\"#BitstreamVeraSans-Roman-71\"/>\n <use x=\"223.4921875\" xlink:href=\"#BitstreamVeraSans-Roman-75\"/>\n <use x=\"286.87109375\" xlink:href=\"#BitstreamVeraSans-Roman-65\"/>\n <use x=\"348.39453125\" xlink:href=\"#BitstreamVeraSans-Roman-6e\"/>\n <use x=\"411.7734375\" xlink:href=\"#BitstreamVeraSans-Roman-63\"/>\n <use x=\"466.75390625\" xlink:href=\"#BitstreamVeraSans-Roman-79\"/>\n </g>\n </g>\n </g>\n </g>\n </g>\n <defs>\n <clipPath id=\"p9e575f5172\">\n <rect height=\"345.6\" width=\"446.4\" x=\"72.0\" y=\"43.2\"/>\n </clipPath>\n </defs>\n</svg>\n</div>\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:229","dateFinished":"2017-02-28T13:57:03+0000","dateStarted":"2017-02-28T13:56:33+0000","focus":true},{"text":"%md\n\nAs the SparkContext is shared between different interpreters once a temporary view has been registered it can be accessed by SparkSQL and Scala. A visualization toolbox will appear automatically when running a SparkSQL query.","dateUpdated":"2017-02-28T14:00:46+0000","config":{"colWidth":12,"editorMode":"ace/mode/markdown","graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorHide":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691071_-995883517","id":"20170224-143145_1378628353","result":{"code":"SUCCESS","type":"HTML","msg":"<p>As the SparkContext is shared between different interpreters once a temporary view has been registered it can be accessed by SparkSQL and Scala. A visualization toolbox will appear automatically when running a SparkSQL query.</p>\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:230","dateFinished":"2017-02-28T14:00:43+0000","dateStarted":"2017-02-28T14:00:43+0000","focus":true},{"text":"%sql \n\nselect `environment/system/os/name`, count(*)\nfrom nightly_sample\ngroup by 1","dateUpdated":"2017-02-28T14:00:47+0000","config":{"colWidth":12,"editorMode":"ace/mode/scala","graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"keys":[{"name":"environment/system/os/name","index":0,"aggr":"sum"}],"values":[{"name":"count(1)","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"environment/system/os/name","index":0,"aggr":"sum"}}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691071_-995883517","id":"20170224-135047_511050306","result":{"code":"SUCCESS","type":"TABLE","msg":"environment/system/os/name\tcount(1)\nLinux\t924\nDarwin\t482\nWindows_NT\t10855\n","comment":"","msgTable":[[{"key":"count(1)","value":"Linux"},{"key":"count(1)","value":"924"}],[{"value":"Darwin"},{"value":"482"}],[{"value":"Windows_NT"},{"value":"10855"}]],"columnNames":[{"name":"environment/system/os/name","index":0,"aggr":"sum"},{"name":"count(1)","index":1,"aggr":"sum"}],"rows":[["Linux","924"],["Darwin","482"],["Windows_NT","10855"]]},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:231","dateFinished":"2017-02-28T14:01:19+0000","dateStarted":"2017-02-28T14:00:47+0000","focus":true},{"text":"sqlContext\n .sql(\"select * from nightly_sample\")\n .groupBy(\"environment/system/os/name\")\n .count()\n .collect()","dateUpdated":"2017-02-28T14:01:29+0000","config":{"colWidth":12,"editorMode":"ace/mode/scala","graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691071_-995883517","id":"20170224-135639_2049260364","result":{"code":"SUCCESS","type":"TEXT","msg":"\nres0: Array[org.apache.spark.sql.Row] = Array([Linux,924], [Darwin,482], [Windows_NT,10855])\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:232","focus":true,"dateFinished":"2017-02-28T14:01:52+0000","dateStarted":"2017-02-28T14:01:29+0000"},{"text":"%md \n\nJust as we can access temporary views any other table registered within the Hive metastore can be access as well, like the *longitudinal* one.","dateUpdated":"2017-02-28T14:02:19+0000","config":{"colWidth":12,"editorMode":"ace/mode/markdown","graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true,"editorHide":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691072_-1010119226","id":"20170224-143309_1430894078","result":{"code":"SUCCESS","type":"HTML","msg":"<p>Just as we can access temporary views any other table registered within the Hive metastore can be access as well, like the <em>longitudinal</em> one.</p>\n"},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:233","dateFinished":"2017-02-28T14:02:15+0000","dateStarted":"2017-02-28T14:02:15+0000","focus":true},{"text":"%sql\nwith submissions as (\n select explode(build) as build\n from longitudinal\n where build is not null\n), grouped as (\n select build.architecture as arch, count(*) as total\n from submissions\n group by 1\n)\nselect arch, 100 * total / sum(total) over () as percentage\nfrom grouped\norder by 2 desc\nlimit 2","dateUpdated":"2017-02-28T14:02:39+0000","config":{"colWidth":12,"editorMode":"ace/mode/sql","graph":{"mode":"table","height":300,"optionOpen":false,"keys":[{"name":"arch","index":0,"aggr":"sum"}],"values":[{"name":"percentage","index":1,"aggr":"sum"}],"groups":[],"scatter":{"xAxis":{"name":"arch","index":0,"aggr":"sum"},"yAxis":null}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691072_-1010119226","id":"20170224-142611_475781068","result":{"code":"SUCCESS","type":"TABLE","msg":"arch\tpercentage\nx86\t91.96796532613196\nx86-64\t8.02839171660672\n","comment":"","msgTable":[[{"key":"percentage","value":"x86"},{"key":"percentage","value":"91.96796532613196"}],[{"value":"x86-64"},{"value":"8.02839171660672"}]],"columnNames":[{"name":"arch","index":0,"aggr":"sum"},{"name":"percentage","index":1,"aggr":"sum"}],"rows":[["x86","91.96796532613196"],["x86-64","8.02839171660672"]]},"dateCreated":"2017-02-28T13:48:11+0000","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:234","dateFinished":"2017-02-28T14:04:23+0000","dateStarted":"2017-02-28T14:02:39+0000","focus":true},{"text":"","dateUpdated":"2017-02-28T13:48:11+0000","config":{"colWidth":12,"graph":{"mode":"table","height":300,"optionOpen":false,"keys":[],"values":[],"groups":[],"scatter":{}},"enabled":true},"settings":{"params":{},"forms":{}},"jobName":"paragraph_1488289691072_-1010119226","id":"20170224-142502_226596480","dateCreated":"2017-02-28T13:48:11+0000","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:235"}],"name":"Tutorial","id":"2CCE7549C","angularObjects":{"2BRWU4WXC:shared_process":[],"2AJXGMUUJ:shared_process":[],"2ANGGHHMQ:shared_process":[],"2AKK3QQXU:shared_process":[]},"config":{"looknfeel":"default"},"info":{}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment