{"id":2706,"date":"2019-07-01T15:29:28","date_gmt":"2019-07-01T07:29:28","guid":{"rendered":"https:\/\/yanjingang.com\/blog\/?p=2706"},"modified":"2019-07-03T18:08:16","modified_gmt":"2019-07-03T10:08:16","slug":"superset%e5%bc%80%e6%ba%90%e6%95%b0%e6%8d%ae%e5%8f%af%e8%a7%86%e5%8c%96%e5%b9%b3%e5%8f%b0","status":"publish","type":"post","link":"https:\/\/yanjingang.com\/blog\/?p=2706","title":{"rendered":"Superset\u2014\u5f00\u6e90\u6570\u636e\u53ef\u89c6\u5316\u5e73\u53f0"},"content":{"rendered":"<p>\u6700\u8fd1\u6709\u4e0d\u5c11\u6570\u636e\u7edf\u8ba1\u5206\u6790\u7684\u4e8b\u60c5\uff0c\u53d1\u73b0\u516c\u53f8\u5185\u7f51\u7684showx\u5e73\u53f0\u771f\u662f\u597d\u7528\uff0c\u53ef\u662f\u8fd9\u4e2a\u7cfb\u7edf\u5e76\u6ca1\u6709\u5f00\u6e90\uff0c\u90a3\u4e48\u6709\u6ca1\u6709\u7c7b\u4f3c\u7684\u5f00\u6e90\u4ea7\u54c1\u5462\uff0c\u627e\u4e86\u4e0b\uff0c\u53d1\u73b0Superset\u8fd9\u4e2a\u9879\u76ee\u8fd8\u662f\u633a\u4e0d\u9519\u7684\uff0c\u8fd9\u91cc\u5927\u6982\u8bb2\u89e3\u4e0b\u4f7f\u7528\u65b9\u6cd5\u548c\u6548\u679c\u3002<\/p>\n<div>\n<div>\n<p><a href=\"https:\/\/airbnb.io\/projects\/superset\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Superset<\/a> \u662f\u4e00\u6b3e\u7531 Airbnb \u5f00\u6e90\u7684\u201c\u73b0\u4ee3\u5316\u7684\u4f01\u4e1a\u7ea7 BI\uff08\u5546\u4e1a\u667a\u80fd\uff09 Web \u5e94\u7528\u7a0b\u5e8f\u201d\uff0c\u5176\u901a\u8fc7\u521b\u5efa\u548c\u5206\u4eab dashboard\uff0c\u4e3a\u6570\u636e\u5206\u6790\u63d0\u4f9b\u4e86\u8f7b\u91cf\u7ea7\u7684\u6570\u636e\u67e5\u8be2\u548c\u53ef\u89c6\u5316\u65b9\u6848\u3002<br \/>\nSuperset \u7684\u524d\u7aef\u4e3b\u8981\u7528\u5230\u4e86 <a href=\"https:\/\/reactjs.org\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">React<\/a> \u548c <a href=\"http:\/\/nvd3.org\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">NVD3\/D3<\/a>\uff0c\u800c\u540e\u7aef\u5219\u57fa\u4e8e Python \u7684 <a href=\"http:\/\/flask.pocoo.org\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Flask<\/a> \u6846\u67b6\u548c <a href=\"http:\/\/pandas.pydata.org\/pandas-docs\/stable\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Pandas<\/a>\u3001<a href=\"http:\/\/www.sqlalchemy.org\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">SQLAlchemy<\/a> \u7b49\u4f9d\u8d56\u5e93\uff0c\u4e3b\u8981\u63d0\u4f9b\u4e86\u8fd9\u51e0\u65b9\u9762\u7684\u529f\u80fd\uff1a<\/p>\n<ul>\n<li>\u96c6\u6210\u6570\u636e\u67e5\u8be2\u529f\u80fd\uff0c\u652f\u6301\u591a\u79cd\u6570\u636e\u5e93\uff0c\u5305\u62ec MySQL\u3001PostgresSQL\u3001Oracle\u3001SQL Server\u3001SQLite\u3001SparkSQL \u7b49\uff0c\u5e76\u6df1\u5ea6\u652f\u6301 <a href=\"http:\/\/druid.io\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Druid<\/a>\u3002<\/li>\n<li>\u901a\u8fc7 NVD3\/D3 \u9884\u5b9a\u4e49\u4e86\u591a\u79cd\u53ef\u89c6\u5316\u56fe\u8868\uff0c\u6ee1\u8db3\u5927\u90e8\u5206\u7684\u6570\u636e\u5c55\u793a\u529f\u80fd\u3002\u5982\u679c\u8fd8\u6709\u5176\u4ed6\u9700\u6c42\uff0c\u4e5f\u53ef\u4ee5\u81ea\u5f00\u53d1\u66f4\u591a\u7684\u56fe\u8868\u7c7b\u578b\uff0c\u6216\u8005\u5d4c\u5165\u5176\u4ed6\u7684 JavaScript \u56fe\u8868\u5e93\uff08\u5982 HighCharts\u3001ECharts\uff09\u3002<\/li>\n<li>\u63d0\u4f9b\u7ec6\u7c92\u5ea6\u5b89\u5168\u6a21\u578b\uff0c\u53ef\u4ee5\u5728\u529f\u80fd\u5c42\u9762\u548c\u6570\u636e\u5c42\u9762\u8fdb\u884c\u8bbf\u95ee\u63a7\u5236\u3002\u652f\u6301\u591a\u79cd\u9274\u6743\u65b9\u5f0f\uff08\u5982\u6570\u636e\u5e93\u3001OpenID\u3001LDAP\u3001OAuth\u3001REMOTE_USER \u7b49\uff09\u3002<\/li>\n<\/ul>\n<p>Superset \u7684\u642d\u5efa\u4e0e\u4f7f\u7528\u975e\u5e38\u7b80\u5355\uff0c\u53ea\u9700\u8981\u4e00\u4e9b Python \u57fa\u7840\uff0c\u4e0b\u9762\u5148\u4ece\u521b\u5efa\u865a\u62df\u73af\u5883\u5f00\u59cb\u3002<\/p>\n<\/div>\n<\/div>\n<p>\u6e90\u4ee3\u7801\uff1ahttps:\/\/github.com\/apache\/incubator-superset<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"\">#1.\u5b89\u88c5\r\n# \u901a\u8fc7 PyPi \u4ed3\u5e93\u5b89\u88c5 superset\r\nsudo yum upgrade python-setuptools\r\nsudo yum install mysql-devel gcc gcc-c++ gcc-devel libffi-devel python-devel python-pip python-wheel openssl-devel libsasl2-devel openldap-devel\r\nsudo pip install superset mysqlclient\r\n\r\n#2.\u521d\u59cb\u5316\r\n#\u521b\u5efa\u521d\u59cb\u8d85\u7ea7\u7528\u6237: admin\/123456\r\nfabmanager create-admin --app superset --username admin --password 123456 --firstname admin --lastname admin --email yanjingang@mail.com\r\n#\u4f7f\u7528\u9ed8\u8ba4 sqllite metadata\uff0c\u4f4d\u4e8e ~\/.superset\/superset.db\uff0c\u5e76\u6839\u636e migrate \u521b\u5efa\u8868\u7ed3\u6784\r\nsuperset db upgrade\r\n#\u52a0\u8f7d Superset\u63d0\u4f9b\u7684\u793a\u4f8b\u6570\u636e\r\nsuperset load_examples\r\n#\u521d\u59cb\u5316 role \u7b49\r\nsuperset init\r\n\r\n#3. \u542f\u52a8\r\nsuperset runserver -d    #-d\u6253\u5f00debug \u6a21\u5f0f\uff1b-p\u6307\u5b9a\u7aef\u53e3\r\n\u6216\r\ngunicorn -D -w 2 -k gevent --timeout 120 -b  0.0.0.0:8088 --limit-request-line 0 --limit-request-field_size 0 superset:app\r\n-D \u540e\u53f0\u8fd0\u884c\r\n-w \u8d1f\u8f7d\u8fdb\u7a0b\u6570\u91cf\uff0c\u901a\u5e38\u63a8\u8350\u7684worker\u6570\u91cf\u662f\uff1a(2 x $num_cores) + 1\r\n-k \u5de5\u4f5c\u8fdb\u7a0b\u7c7b\u578b(gevent\u662f\u4e00\u4e2a\u57fa\u4e8elibev\u7684\u5e76\u53d1\u5e93)\r\n*\u5173\u95ed\uff1apkill gunicorn\r\n\r\n#4.\u8bbf\u95ee\r\nhttp:\/\/localhost:8088\r\nadmin\/123456\r\n\r\n#5.\u521b\u5efa\u6570\u636e\u6e90\r\n\u70b9\u51fb\u201c\u6570\u636e\u6e90 \u2014&gt; \u6570\u636e\u5e93 -&gt; \u6dfb\u52a0\u65b0\u8bb0\u5f55\u201d\r\nSQLAlchemy URI\u683c\u5f0f\u4e3a\uff1adialect:\/\/user:password@host:port\/dbname[?key=value..]\r\n\u793a\u4f8b\uff1amysql:\/\/root:XXXXXXXXXX@127.0.0.1:3306\/test?charset=utf8\r\n\r\n#6.\u6dfb\u52a0\u8868\r\n\u70b9\u51fb\u201c\u6570\u636e\u6e90 \u2014&gt; \u6570\u636e\u8868 -&gt; \u6dfb\u52a0\u65b0\u8bb0\u5f55\u201d\r\n\r\n#7.\u521b\u5efa\u53ef\u89c6\u5316\u5206\u6790\u62a5\u8868\r\n\u70b9\u51fb\u201cCharts-\u6dfb\u52a0\u65b0\u8bb0\u5f55\u201d\uff0c\u9009\u62e9\u6570\u636e\u6e90\u548c\u8868\u7c7b\u578b\u540e\u7f16\u8f91sql\u548c\u8868\u884c\u4e1a\u9009\u9879\u5e76\u8c03\u8bd5\u5373\u53ef\u3002\r\n*\u56fe\u6807\u914d\u7f6e\u65b9\u6cd5\u53ef\u53c2\u8003\u7cfb\u7edf\u5185\u7f6e\u7684\u793a\u4f8b\u62a5\u8868\u3002\r\n\r\n#8.\u5408\u5e76\u591a\u4e2a\u62a5\u8868\u5230\u770b\u677f\r\n\u6709\u65f6\u591a\u4e2a\u62a5\u8868\u4ece\u4e0d\u540c\u7eac\u5ea6\u5206\u6790\u540c\u4e00\u4e2a\u4e8b\u60c5\uff0c\u53ef\u4ee5\u5728\u5efa\u7acb\u62a5\u8868\u65f6\u9009\u62e9\u5efa\u5230\u4e00\u4e2a\u770b\u677f\u4e0a\uff0c\u5c31\u80fd\u5728\u4e00\u4e2a\u9875\u9762\u4e00\u8d77\u770b\u4e86\u3002\r\n\u770b\u677f\u4e0a\u53ef\u4ee5\u589e\u52a0filter_box\u7c7b\u578b\u7684\u62a5\u8868\u505a\u7b5b\u9009\u6761\u4ef6\uff08\u6761\u4ef6\u4e0d\u652f\u6301\u8bbe\u7f6e\u9ed8\u8ba4\u503c\uff09\u3002\r\n\r\n#9.\u6dfb\u52a0\u7528\u6237\/\u89d2\u8272\/\u6743\u9650<\/code><\/pre>\n<div>\n<p>Superset \u672c\u8eab\u63d0\u4f9b\u4e86\u4e00\u7ec4\u57fa\u672c\u89d2\u8272\u548c\u6743\u9650\u63a7\u5236\uff1a<\/p>\n<ul>\n<li><strong>Admin\uff1a<\/strong>\u62e5\u6709\u6240\u6709\u53ef\u80fd\u7684\u6743\u9650\uff0c\u5305\u62ec\u4ece\u5176\u4ed6\u7528\u6237\u6388\u4e88\u6216\u64a4\u6d88\u6743\u9650\u4ee5\u53ca\u66f4\u6539\u5176\u4ed6\u4eba\u7684\u5207\u7247\u548c dashboard\u3002<\/li>\n<li><strong>Alpha\uff1a<\/strong>\u53ef\u4ee5\u8bbf\u95ee\u6240\u6709\u6570\u636e\u6e90\uff0c\u4f46\u4e0d\u80fd\u6388\u4e88\u6216\u64a4\u6d88\u5176\u4ed6\u7528\u6237\u7684\u8bbf\u95ee\u6743\u9650\u3002\u5b83\u4eec\u4e5f\u4ec5\u9650\u4e8e\u6539\u53d8\u5b83\u4eec\u62e5\u6709\u7684\u5bf9\u8c61\u3002\u53ef\u4ee5\u6dfb\u52a0\u548c\u66f4\u6539\u6570\u636e\u6e90\u3002<\/li>\n<li><strong>Gamma\uff1a<\/strong>\u8bbf\u95ee\u53d7\u9650\uff0c\u53ea\u80fd\u4f7f\u7528\u901a\u8fc7\u53e6\u4e00\u4e2a\u4e92\u8865\u89d2\u8272\u83b7\u5f97\u8bbf\u95ee\u6743\u9650\u7684\u6570\u636e\u6e90\u3002\u4ed6\u4eec\u53ea\u80fd\u67e5\u770b\u7531\u4ed6\u4eec\u6709\u6743\u8bbf\u95ee\u7684\u6570\u636e\u6e90\u5236\u4f5c\u7684\u5207\u7247\u548c dashboard\u3002\u65e0\u6cd5\u66f4\u6539\u6216\u6dfb\u52a0\u6570\u636e\u6e90\uff0c\u4f46\u53ef\u4ee5\u53ef\u4ee5\u521b\u5efa\u5207\u7247\u548c dashboard\u3002<\/li>\n<li><strong>sql_lab\uff1a<\/strong>\u88ab\u6388\u4e88\u5bf9 SQL Lab \u7684\u8bbf\u95ee\u6743\u9650\u3002<\/li>\n<li><strong>public\uff1a<\/strong>\u53ef\u4ee5\u901a\u8fc7\u5728 superset\\config.py \u8bbe\u7f6e <code>PUBLIC_ROLE_LIKE_GAMMA = True<\/code>\uff0c\u6388\u4e88\u8be5\u89d2\u8272\u4e0e Gamma \u89d2\u8272\u76f8\u540c\u7684\u6743\u9650\u96c6\u3002<\/li>\n<\/ul>\n<p>\u767b\u5f55\uff1a<\/p>\n<p><a href=\"https:\/\/yanjingang.com\/blog\/?attachment_id=2740\" rel=\"attachment wp-att-2740\"><img loading=\"lazy\" class=\"alignnone size-large wp-image-2740\" src=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-1024x546.png\" alt=\"\" width=\"625\" height=\"333\" srcset=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-1024x546.png 1024w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-300x160.png 300w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-768x409.png 768w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-624x333.png 624w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset.png 1045w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>\u6dfb\u52a0\u6570\u636e\u5e93\uff1a<\/p>\n<p><a href=\"https:\/\/yanjingang.com\/blog\/?attachment_id=2739\" rel=\"attachment wp-att-2739\"><img loading=\"lazy\" class=\"alignnone size-large wp-image-2739\" src=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-datasource.png\" alt=\"\" width=\"625\" height=\"483\" srcset=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-datasource.png 901w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-datasource-300x232.png 300w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-datasource-768x593.png 768w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-datasource-624x482.png 624w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>\u7f16\u8f91\u62a5\u8868\uff1a<\/p>\n<p><a href=\"https:\/\/yanjingang.com\/blog\/?attachment_id=2741\" rel=\"attachment wp-att-2741\"><img loading=\"lazy\" class=\"alignnone size-large wp-image-2741\" src=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-1024x508.png\" alt=\"\" width=\"625\" height=\"310\" srcset=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-1024x508.png 1024w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-300x149.png 300w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-768x381.png 768w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-624x310.png 624w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts.png 1907w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>\u770b\u677f\uff1a<\/p>\n<p><a href=\"https:\/\/yanjingang.com\/blog\/?attachment_id=2737\" rel=\"attachment wp-att-2737\"><img loading=\"lazy\" class=\"alignnone size-large wp-image-2737\" src=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-brand-1-1024x579.png\" alt=\"\" width=\"625\" height=\"353\" srcset=\"https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-brand-1-1024x579.png 1024w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-brand-1-300x170.png 300w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-brand-1-768x434.png 768w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-brand-1-624x353.png 624w, https:\/\/yanjingang.com\/blog\/wp-content\/uploads\/2019\/07\/superset-charts-brand-1.png 1909w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<\/div>\n<p>\u8fd9\u4e2a\u7cfb\u7edf\u4e5f\u6709\u4e9b\u7f3a\u70b9\uff0c\u6bd4\u5982sql\u5de5\u5177\u7bb1\u91cc\u7684\u81ea\u5b9a\u4e49sql\u4e0d\u80fd\u4f5c\u4e3acharts\u7684\u6570\u636e\u6e90\uff0c\u53ea\u80fd\u9009\u62e9\u6570\u636e\u5e93\u91cc\u7684\u6570\u636e\u8868(\u5373\u6570\u636e\u8981\u9884\u5148\u5904\u7406\u597d\uff0c\u4e0d\u662f\u5f88\u7075\u6d3b)\u3002<\/p>\n<p>\u5982\u679c\u89c9\u5f97Superset\u4e0d\u592a\u597d\u7528\uff0c\u53ef\u4ee5\u62ff\u6e90\u7801\u6539\u9020\u4e00\u4e0b\u6216\u8005\u4ee5ECharts\u4e3a\u5c55\u73b0\u7ec4\u4ef6\u81ea\u5df1\u5f00\u53d1\u4e00\u4e2a\u8fd9\u6837\u62a5\u8868\u7cfb\u7edf\u3002\u4e0d\u8fc7\u73b0\u5728\u5f00\u6e90\u7684ECharts\u975e\u5e38\u597d\u7528\uff0c\u5982\u679c\u662f\u7b80\u5355\u7684\u62a5\u8868\u76f4\u63a5\u7528ECharts\u753b\u6210\u672c\u4e5f\u5f88\u4f4e\u3002<\/p>\n<p>yan 19.7.2<\/p>\n<p><span style=\"color: #999999;\">\u53c2\u8003\uff1a<\/span><\/p>\n<p><span style=\"color: #999999;\">http:\/\/superset.apache.org\/installation.html<\/span><\/p>\n<p><span style=\"color: #999999;\">https:\/\/www.sohu.com\/a\/216910767_659643<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u6709\u4e0d\u5c11\u6570\u636e\u7edf\u8ba1\u5206\u6790\u7684\u4e8b\u60c5\uff0c\u53d1\u73b0\u516c\u53f8\u5185\u7f51\u7684showx\u5e73\u53f0\u771f\u662f\u597d\u7528\uff0c\u53ef\u662f\u8fd9\u4e2a\u7cfb\u7edf\u5e76\u6ca1\u6709\u5f00\u6e90\uff0c\u90a3\u4e48\u6709\u6ca1\u6709\u7c7b\u4f3c\u7684\u5f00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[827],"tags":[321,829,830,828],"_links":{"self":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2706"}],"collection":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2706"}],"version-history":[{"count":0,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2706\/revisions"}],"wp:attachment":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}