可视化Superset
- 安装依赖
sudo yum install -y gcc gcc-c++ libffi-devel python-devel python-pip python-wheel python-setuptools openssl-devel cyrus-sasl-devel openldap-devel
- 更新
pip install --upgrade setuptools pip -i https://pypi.douban.com/simple/
- 安装
conda activate superset
pip install apache-superset -i https://pypi.douban.com/simple/
查看详情
[root@slave1 home]# conda activate superset
(superset) [root@slave1 home]# pip install apache-superset -i https://pypi.douban.com/simple/
Looking in indexes: https://pypi.douban.com/simple/
Collecting apache-superset
Downloading https://mirrors.cloud.tencent.com/pypi/packages/f3/93/e7d906f3cdbcb33a42aa415312cbf08f8dbc5b19c0bff3d11d76fee9b52e/apache-superset-2.1.3.tar.gz (46.9 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 46.9/46.9 MB 8.0 MB/s eta 0:00:00
Preparing metadata (setup.py) ... done
Collecting backoff>=1.8.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/df/73/b6e24bd22e6720ca8ee9a85a0c4a2971af8497d8f3193fa05390cbd46e09/backoff-2.2.1-py3-none-any.whl (15 kB)
Collecting cachelib<0.5,>=0.4.1 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/71/3f/d4dd822234dc9e9f368a7ec355a3ae8e27e8b36e466bb3955128529a101e/cachelib-0.4.1-py3-none-any.whl (14 kB)
Collecting celery<6.0.0,>=5.2.2 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/37/c2/4c8a67a4d98a6fcd55dbdd79b641f945d7f59637c3e885c4abbda3c431f6/celery-5.3.6-py3-none-any.whl (422 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 422.0/422.0 kB 2.9 MB/s eta 0:00:00
Collecting click>=8.0.3 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/00/2e/d53fa4befbf2cfa713304affc7ca780ce4fc1fd8710527771b58311a3229/click-8.1.7-py3-none-any.whl (97 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 97.9/97.9 kB 2.8 MB/s eta 0:00:00
Collecting colorama (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/d1/d6/3965ed04c63042e047cb6a3e6ed1a63a35087b6a609aa3a15ed8ac56c221/colorama-0.4.6-py2.py3-none-any.whl (25 kB)
Collecting croniter>=0.3.28 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/27/86/c1ce37af79385a106aacdd40b6e25ff25b2d888f2e64a05ee4e5b05f5768/croniter-2.0.1-py2.py3-none-any.whl (19 kB)
Collecting cron-descriptor (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/24/a0/455f5a0181cf9a0d2e84d3a66c88de019dce5644ad9680825d1c8a403335/cron_descriptor-1.4.0.tar.gz (29 kB)
Preparing metadata (setup.py) ... done
Collecting cryptography<40,>=39.0.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/26/d2/85480f4e754375c6d8e4a18cc8d2f28ef1984cf2843395c4d1ea396331d3/cryptography-39.0.2-cp36-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.2/4.2 MB 10.3 MB/s eta 0:00:00
Collecting deprecation<2.2.0,>=2.1.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/02/c3/253a89ee03fc9b9682f1541728eb66db7db22148cd94f89ab22528cd1e1b/deprecation-2.1.0-py2.py3-none-any.whl (11 kB)
Collecting flask<3.0.0,>=2.2.5 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/fd/56/26f0be8adc2b4257df20c1c4260ddd0aa396cf8e75d90ab2f7ff99bc34f9/flask-2.3.3-py3-none-any.whl (96 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 96.1/96.1 kB 3.6 MB/s eta 0:00:00
Collecting flask-appbuilder<5.0.0,>=4.3.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/42/06/6124df3315a627bdc297290f6dd920917261a18ba9f29b48ed2b2a5688e4/Flask_AppBuilder-4.3.10-py3-none-any.whl (2.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.2/2.2 MB 8.4 MB/s eta 0:00:00
Collecting flask-caching<1.11,>=1.10.1 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/bd/63/f8fe759cfe4fa8075f77581af5dad632cea8578881c843c679c103c34815/Flask_Caching-1.10.1-py3-none-any.whl (34 kB)
Collecting flask-compress<2.0,>=1.13 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/3f/d2/23fd656d38d4c896fa14371990b9978722c48a30d0edcf6b5f7054775a07/Flask_Compress-1.14-py3-none-any.whl (8.4 kB)
Collecting flask-talisman<2.0,>=1.0.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/77/1c/a15ac936dc3ae4491c5ff089dccdccd72cd3608b15fcf4e2de961f9ee8f3/flask_talisman-1.1.0-py2.py3-none-any.whl (18 kB)
Collecting flask-login==0.6.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/58/a5/1dc6619231e8c35cec506c604135d7a3cbcaa643bdfe9a7983fab2eea8c5/Flask_Login-0.6.0-py3-none-any.whl (16 kB)
Collecting flask-migrate<4.0,>=3.1.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/a8/48/b64a6a2fee01b03f3318cba3aea1c0055ab5f4a933b2d4f5a2d75140c229/Flask_Migrate-3.1.0-py3-none-any.whl (20 kB)
Collecting flask-wtf<1.1,>=1.0.1 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/3a/26/3803ee692eb9a8d21bf7ba1cecd649ce3a55899c65467bdfc1bad13ec50f/Flask_WTF-1.0.1-py3-none-any.whl (12 kB)
Collecting func_timeout (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b3/0d/bf0567477f7281d9a3926c582bfef21bff7498fc0ffd3e9de21811896a0b/func_timeout-4.3.5.tar.gz (44 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 44.3/44.3 kB 7.7 MB/s eta 0:00:00
Preparing metadata (setup.py) ... done
Collecting geopy (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/e5/15/cf2a69ade4b194aa524ac75112d5caac37414b20a3a03e6865dfe0bd1539/geopy-2.4.1-py3-none-any.whl (125 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 125.4/125.4 kB 3.6 MB/s eta 0:00:00
Collecting graphlib-backport (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b0/2a/d77491343f72546943dd79974133a5261b9bc12a80806c34f51a058c0732/graphlib_backport-1.0.3-py3-none-any.whl (5.1 kB)
Collecting hashids<2,>=1.3.1 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/6e/46/ffdf25b1f6dbb1ce588ccb818e983df9e3d30594679f5a08c865a59cead7/hashids-1.3.1-py2.py3-none-any.whl (6.6 kB)
Collecting holidays<0.18,>=0.17.2 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/48/0d/4fee3ddb80bcb08714a0e783e47b552bdfb8e5cb2ed9e4d87ae13d926850/holidays-0.17.2-py3-none-any.whl (187 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 187.5/187.5 kB 4.5 MB/s eta 0:00:00
Collecting humanize (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/aa/2b/2ae0c789fd08d5b44e745726d08a17e6d3d7d09071d05473105edc7615f2/humanize-4.9.0-py3-none-any.whl (126 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 126.8/126.8 kB 4.8 MB/s eta 0:00:00
Collecting isodate (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b6/85/7882d311924cbcfc70b1890780763e36ff0b140c7e51c110fc59a532f087/isodate-0.6.1-py2.py3-none-any.whl (41 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 41.7/41.7 kB 7.9 MB/s eta 0:00:00
Collecting markdown>=3.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/42/f4/f0031854de10a0bc7821ef9fca0b92ca0d7aa6fbfbf504c5473ba825e49c/Markdown-3.5.2-py3-none-any.whl (103 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 103.9/103.9 kB 4.7 MB/s eta 0:00:00
Collecting msgpack<1.1,>=1.0.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/1d/f3/44968c303d70a9d1c5cd68180319851e3bb7396580a4c9f6c58b841b4409/msgpack-1.0.7-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (534 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 534.8/534.8 kB 1.0 MB/s eta 0:00:00
Collecting nh3<0.3,>=0.2.11 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/77/67/e5d91360d1414016326ed0c3e9cf74e38fa60245e0194ba9fe2644648a51/nh3-0.2.15-cp37-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.7 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.7/1.7 MB 5.2 MB/s eta 0:00:00
Collecting numpy==1.23.5 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/c6/4f/63f6f16d3f44a764a3b66c6233e133baf912e198a93e14c39ee991f587d0/numpy-1.23.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (17.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 17.1/17.1 MB 10.5 MB/s eta 0:00:00
Collecting pandas<1.6,>=1.5.3 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/54/a0/c62d63c5c69be9aae07836e4d7e25e7a6f5590be3d8f2d53f43eeec5c475/pandas-1.5.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.2/12.2 MB 10.9 MB/s eta 0:00:00
Collecting parsedatetime (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/9d/a4/3dd804926a42537bf69fb3ebb9fd72a50ba84f807d95df5ae016606c976c/parsedatetime-2.6-py3-none-any.whl (42 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 42.5/42.5 kB 347.8 kB/s eta 0:00:00
Collecting pgsanity (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/45/70/d9ce2d8a93a7b755b09871125768c3237f99147472ec6f3ca3237cd22a4d/pgsanity-0.2.9.tar.gz (7.5 kB)
Preparing metadata (setup.py) ... done
Collecting polyline (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/de/e7/0f263cd536c17419eec617b0927d99aa1e5e0bb04039c1065f65973f626f/polyline-2.0.1-py3-none-any.whl (6.0 kB)
Collecting pyparsing<4,>=3.0.6 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/39/92/8486ede85fcc088f1b3dba4ce92dd29d126fd96b0008ea213167940a2475/pyparsing-3.1.1-py3-none-any.whl (103 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 103.1/103.1 kB 2.7 MB/s eta 0:00:00
Collecting python-dateutil (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/36/7a/87837f39d0296e723bb9b62bbb257d0355c7f6128853c78955f57342a56d/python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 247.7/247.7 kB 6.2 MB/s eta 0:00:00
Collecting python-dotenv (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/44/2f/62ea1c8b593f4e093cc1a7768f0d46112107e790c3e478532329e434f00b/python_dotenv-1.0.0-py3-none-any.whl (19 kB)
Collecting python-geohash (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/9c/e2/1a3507af7c8f91f8a4975d651d4aeb6a846dfdf74713954186ade4205850/python-geohash-0.8.5.tar.gz (17 kB)
Preparing metadata (setup.py) ... done
Collecting pyarrow<11,>=10.0.1 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/89/b4/04ae9d39130d0dc40803eb6fbe84873c247f9c8e8111ac9b2cb30c35b515/pyarrow-10.0.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (36.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 36.0/36.0 MB 9.5 MB/s eta 0:00:00
Collecting pyyaml>=5.4 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/c8/6b/6600ac24725c7388255b2f5add93f91e58a5d7efaf4af244fdbcc11a541b/PyYAML-6.0.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (736 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 736.6/736.6 kB 9.4 MB/s eta 0:00:00
Collecting PyJWT<3.0,>=2.4.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/2b/4f/e04a8067c7c96c364cef7ef73906504e2f40d690811c021e1a1901473a19/PyJWT-2.8.0-py3-none-any.whl (22 kB)
Collecting redis (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/0b/34/a01250ac1fc9bf9161e07956d2d580413106ce02d5591470130a25c599e3/redis-5.0.1-py3-none-any.whl (250 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 250.3/250.3 kB 4.7 MB/s eta 0:00:00
Collecting selenium>=3.141.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/dc/72/96b5afa16908f9abc7c24b70adfd3a46c9740eb728ddfeab28379e38eaf9/selenium-4.16.0-py3-none-any.whl (10.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 10.0/10.0 MB 11.2 MB/s eta 0:00:00
Collecting sshtunnel<0.5,>=0.4.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/58/13/8476c4328dcadfe26f8bd7f3a1a03bf9ddb890a7e7b692f54a179bc525bf/sshtunnel-0.4.0-py2.py3-none-any.whl (24 kB)
Collecting simplejson>=3.15.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/33/5f/b9506e323ea89737b34c97a6eda9d22ad6b771190df93f6eb72657a3b996/simplejson-3.19.2-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (136 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 136.6/136.6 kB 3.6 MB/s eta 0:00:00
Collecting slack_sdk<4,>=3.1.1 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/65/c0/4c7140510a81c0b2b3de86424feb4a056a3772aecde84bd015934d948f23/slack_sdk-3.26.2-py2.py3-none-any.whl (284 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 284.1/284.1 kB 5.7 MB/s eta 0:00:00
Collecting sqlalchemy<2,>=1.4 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/42/f7/bd63a07e48a8eca62063a394238ebafbbccccaed22c92c920cc7f3d41745/SQLAlchemy-1.4.51-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.6/1.6 MB 10.1 MB/s eta 0:00:00
Collecting sqlalchemy-utils<0.39,>=0.38.3 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/e1/90/6ff1829b55cf752994be76bdf5f718db053dcb8d738f9df5b622207a4ab8/SQLAlchemy_Utils-0.38.3-py3-none-any.whl (100 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 100.3/100.3 kB 2.7 MB/s eta 0:00:00
Collecting sqlparse<0.5,>=0.4.4 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/98/5a/66d7c9305baa9f11857f247d4ba761402cea75db6058ff850ed7128957b7/sqlparse-0.4.4-py3-none-any.whl (41 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 41.2/41.2 kB 9.0 MB/s eta 0:00:00
Collecting tabulate<0.9,>=0.8.9 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/92/4e/e5a13fdb3e6f81ce11893523ff289870c87c8f1f289a7369fb0e9840c3bb/tabulate-0.8.10-py3-none-any.whl (29 kB)
Collecting typing-extensions<5,>=4 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b7/f4/6a90020cd2d93349b442bfcb657d0dc91eee65491600b2cb1d388bc98e6b/typing_extensions-4.9.0-py3-none-any.whl (32 kB)
Collecting werkzeug<3,>=2.3.3 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/fd/21/0a674dfe66e9df9072c46269c882e9f901d36d987d8ea50ead033a9c1e01/werkzeug-2.3.8-py3-none-any.whl (242 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 242.3/242.3 kB 5.5 MB/s eta 0:00:00
Collecting wtforms<4,>=2.3.3 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/18/19/c3232f35e24dccfad372e9f341c4f3a1166ae7c66e4e1351a9467c921cc1/wtforms-3.1.2-py3-none-any.whl (145 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 146.0/146.0 kB 4.0 MB/s eta 0:00:00
Collecting wtforms-json (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/24/20/4e88bb8417b2f8d63385da8eaedb0a591fed9e7fe72fd883d119319a6b50/WTForms-JSON-0.3.5.tar.gz (12 kB)
Preparing metadata (setup.py) ... done
Collecting xlsxwriter<3.1,>=3.0.7 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/87/b9/bc9e4fe0c6a2656d0baa40aa324f9c11e07e5bcec51be9e90ee4deebb309/XlsxWriter-3.0.9-py3-none-any.whl (152 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 152.8/152.8 kB 5.8 MB/s eta 0:00:00
Collecting gunicorn>=20.1.0 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/0e/2a/c3a878eccb100ccddf45c50b6b8db8cf3301a6adede6e31d48e8531cab13/gunicorn-21.2.0-py3-none-any.whl (80 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 80.2/80.2 kB 4.8 MB/s eta 0:00:00
Collecting billiard<5.0,>=4.2.0 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/50/8d/6e9fdeeab04d803abc5a715175f87e88893934d5590595eacff23ca12b07/billiard-4.2.0-py3-none-any.whl (86 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 86.7/86.7 kB 2.0 MB/s eta 0:00:00
Collecting click-didyoumean>=0.3.0 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ad/36/4599267417fc78b587b1588e0647a468c60b36c02bb723d450d050738fa8/click_didyoumean-0.3.0-py3-none-any.whl (2.7 kB)
Collecting click-plugins>=1.1.1 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/e9/da/824b92d9942f4e472702488857914bdd50f73021efea15b4cad9aca8ecef/click_plugins-1.1.1-py2.py3-none-any.whl (7.5 kB)
Collecting click-repl>=0.2.0 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/52/40/9d857001228658f0d59e97ebd4c346fe73e138c6de1bce61dc568a57c7f8/click_repl-0.3.0-py3-none-any.whl (10 kB)
Collecting kombu<6.0,>=5.3.4 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/f7/88/daca086d72832c74a7e239558ad484644c8cda0b9ae8a690f247bf13c268/kombu-5.3.5-py3-none-any.whl (200 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 200.0/200.0 kB 524.6 kB/s eta 0:00:00
Collecting tzdata>=2022.7 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/a3/fb/52b62131e21b24ee297e4e95ed41eba29647dad0e0051a92bb66b43c70ff/tzdata-2023.4-py2.py3-none-any.whl (346 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 346.6/346.6 kB 12.7 MB/s eta 0:00:00
Collecting vine<6.0,>=5.1.0 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/03/ff/7c0c86c43b3cbb927e0ccc0255cb4057ceba4799cd44ae95174ce8e8b5b2/vine-5.1.0-py3-none-any.whl (9.6 kB)
Collecting backports.zoneinfo>=0.2.1 (from celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/1a/ab/3e941e3fcf1b7d3ab3d0233194d99d6a0ed6b24f8f956fc81e47edc8c079/backports.zoneinfo-0.2.1-cp38-cp38-manylinux1_x86_64.whl (74 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 74.0/74.0 kB 3.1 MB/s eta 0:00:00
Collecting pytz>2021.1 (from croniter>=0.3.28->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/32/4d/aaf7eff5deb402fd9a24a1449a8119f00d74ae9c2efa79f8ef9994261fc2/pytz-2023.3.post1-py2.py3-none-any.whl (502 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 502.5/502.5 kB 10.8 MB/s eta 0:00:00
Collecting cffi>=1.12 (from cryptography<40,>=39.0.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/f1/c9/326611aa83e16b13b6db4dbb73b5455c668159a003c4c2f0c3bcb2ddabaf/cffi-1.16.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (444 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 444.7/444.7 kB 4.4 MB/s eta 0:00:00
Collecting packaging (from deprecation<2.2.0,>=2.1.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ec/1a/610693ac4ee14fcdf2d9bf3c493370e4f2ef7ae2e19217d7a237ff42367d/packaging-23.2-py3-none-any.whl (53 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 53.0/53.0 kB 7.6 MB/s eta 0:00:00
Collecting Jinja2>=3.1.2 (from flask<3.0.0,>=2.2.5->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/30/6d/6de6be2d02603ab56e72997708809e8a5b0fbfee080735109b40a3564843/Jinja2-3.1.3-py3-none-any.whl (133 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 133.2/133.2 kB 4.9 MB/s eta 0:00:00
Collecting itsdangerous>=2.1.2 (from flask<3.0.0,>=2.2.5->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/68/5f/447e04e828f47465eeab35b5d408b7ebaaaee207f48b7136c5a7267a30ae/itsdangerous-2.1.2-py3-none-any.whl (15 kB)
Collecting blinker>=1.6.2 (from flask<3.0.0,>=2.2.5->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/fa/2a/7f3714cbc6356a0efec525ce7a0613d581072ed6eb53eb7b9754f33db807/blinker-1.7.0-py3-none-any.whl (13 kB)
Collecting importlib-metadata>=3.6.0 (from flask<3.0.0,>=2.2.5->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/c0/8b/d8427f023c081a8303e6ac7209c16e6878f2765d5b59667f3903fbcfd365/importlib_metadata-7.0.1-py3-none-any.whl (23 kB)
Collecting apispec<7,>=6.0.0 (from apispec[yaml]<7,>=6.0.0->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/56/33/7a87f8865f0c532ddb2770b85009151c0dedcced139765173d4009c00a04/apispec-6.4.0-py3-none-any.whl (30 kB)
Collecting email-validator<2,>=1.0.5 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ba/ec/adc595d04e795b04bb0028fc6b067713fdb4a7e8cec44b428f7144fc432e/email_validator-1.3.1-py2.py3-none-any.whl (22 kB)
Collecting flask<3.0.0,>=2.2.5 (from apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/9f/1a/8b6d48162861009d1e017a9740431c78d860809773b66cac220a11aa3310/Flask-2.2.5-py3-none-any.whl (101 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 101.8/101.8 kB 3.4 MB/s eta 0:00:00
Collecting Flask-Babel<3,>=1 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ab/3e/02331179ffab8b79e0383606a028b6a60fb1b4419b84935edd43223406a0/Flask_Babel-2.0.0-py3-none-any.whl (9.3 kB)
Collecting Flask-Limiter<4,>3 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/a2/ff/2dc82d9517172b67c2f5b13884777be9fe644cbfd6c52600076747d2f125/Flask_Limiter-3.5.0-py3-none-any.whl (28 kB)
Collecting Flask-SQLAlchemy<3,>=2.4 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/26/2c/9088b6bd95bca539230bbe9ad446737ed391aab9a83aff403e18dded3e75/Flask_SQLAlchemy-2.5.1-py2.py3-none-any.whl (17 kB)
Collecting Flask-JWT-Extended<5.0.0,>=4.0.0 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/be/f7/b5415a5ec78666408cd9af9e8163e2953374808d222625cff33f64adfd2a/Flask_JWT_Extended-4.6.0-py2.py3-none-any.whl (22 kB)
Collecting jsonschema<5,>=3 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/0f/ed/0058234d8dd2b1fc6beeea8eab945191a05e9d391a63202f49fe23327586/jsonschema-4.20.0-py3-none-any.whl (84 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 84.7/84.7 kB 4.7 MB/s eta 0:00:00
Collecting marshmallow<4,>=3.18.0 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/57/e9/4368d49d3b462da16a3bac976487764a84dd85cef97232c7bd61f5bdedf3/marshmallow-3.20.2-py3-none-any.whl (49 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 49.4/49.4 kB 8.2 MB/s eta 0:00:00
Collecting marshmallow-sqlalchemy<0.27.0,>=0.22.0 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/d1/84/1f4d7393d04f2ae0d4098791d1901a713f45ba70ff6f3c35ff2f7fd81f7b/marshmallow_sqlalchemy-0.26.1-py2.py3-none-any.whl (15 kB)
Collecting prison<1.0.0,>=0.2.1 (from flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/f1/bd/e55e14cd213174100be0353824f2add41e8996c6f32081888897e8ec48b5/prison-0.2.1-py2.py3-none-any.whl (5.8 kB)
Collecting brotli (from flask-compress<2.0,>=1.13->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/e7/41/1c6d15c8d5b55db2c3c249c64c352c8a1bc97f5e5c55183f5930866fc012/Brotli-1.1.0-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl (2.8 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 2.8/2.8 MB 10.7 MB/s eta 0:00:00
Collecting alembic>=0.7 (from flask-migrate<4.0,>=3.1.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/7f/50/9fb3a5c80df6eb6516693270621676980acd6d5a9a7efdbfa273f8d616c7/alembic-1.13.1-py3-none-any.whl (233 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 233.4/233.4 kB 4.4 MB/s eta 0:00:00
Collecting convertdate>=2.3.0 (from holidays<0.18,>=0.17.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/27/65/3deecc820ce91716225ec72b584b48ba9512ed9583ad48619e3dbbbbd714/convertdate-2.4.0-py3-none-any.whl (47 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 47.9/47.9 kB 6.6 MB/s eta 0:00:00
Collecting hijri-converter (from holidays<0.18,>=0.17.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/4a/cf/7bd8c3a8d1b8290cf11398439bcf30b9fb10dfe8247202edeaeea9cbdd5a/hijri_converter-2.3.1-py3-none-any.whl (13 kB)
Collecting korean-lunar-calendar (from holidays<0.18,>=0.17.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/9c/96/30f3fe51b336bb6da4714f4fdad7bbdce8f13af79af2eb75e22908f3f9f4/korean_lunar_calendar-0.3.1-py3-none-any.whl (9.0 kB)
Collecting six>=1.5 (from python-dateutil->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/d9/5a/e7c31adbe875f2abbb91bd84cf2dc52d792b5a01506781dbcf25c91daf11/six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting urllib3<3,>=1.26 (from urllib3[socks]<3,>=1.26->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/96/94/c31f58c7a7f470d5665935262ebd7455c7e4c7782eb525658d3dbf4b9403/urllib3-2.1.0-py3-none-any.whl (104 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 104.6/104.6 kB 2.8 MB/s eta 0:00:00
Collecting trio~=0.17 (from selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/14/fb/9299cf74953f473a15accfdbe2c15218e766bae8c796f2567c83bae03e98/trio-0.24.0-py3-none-any.whl (460 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 460.2/460.2 kB 6.6 MB/s eta 0:00:00
Collecting trio-websocket~=0.9 (from selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/48/be/a9ae5f50cad5b6f85bd2574c2c923730098530096e170c1ce7452394d7aa/trio_websocket-0.11.1-py3-none-any.whl (17 kB)
Collecting certifi>=2021.10.8 (from selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/64/62/428ef076be88fa93716b576e4a01f919d25968913e817077a386fcbe4f42/certifi-2023.11.17-py3-none-any.whl (162 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 162.5/162.5 kB 12.8 MB/s eta 0:00:00
Collecting greenlet!=0.4.17 (from sqlalchemy<2,>=1.4->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/8a/74/498377804f8ebfb1efdfbe33e93cf3b29d77e207e9496f0c10912d5055b4/greenlet-3.0.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (667 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 667.4/667.4 kB 6.7 MB/s eta 0:00:00
Collecting paramiko>=2.7.2 (from sshtunnel<0.5,>=0.4.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ad/50/8792484502c8141c20c996b802fefa8435a9c018a2bb440a06b172782118/paramiko-3.4.0-py3-none-any.whl (225 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 225.9/225.9 kB 5.9 MB/s eta 0:00:00
Collecting MarkupSafe>=2.1.1 (from werkzeug<3,>=2.3.3->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/de/e2/32c14301bb023986dff527a49325b6259cab4ebb4633f69de54af312fc45/MarkupSafe-2.1.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting geographiclib<3,>=1.52 (from geopy->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/9f/5a/a26132406f1f40cf51ea349a5f11b0a46cec02a2031ff82e391c2537247a/geographiclib-2.0-py3-none-any.whl (40 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 40.3/40.3 kB 2.2 MB/s eta 0:00:00
Collecting async-timeout>=4.0.2 (from redis->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/a7/fa/e01228c2938de91d47b307831c62ab9e4001e747789d0b05baf779a6488c/async_timeout-4.0.3-py3-none-any.whl (5.7 kB)
Collecting Mako (from alembic>=0.7->flask-migrate<4.0,>=3.1.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/24/3b/11fe92d68c6a42468ddab0cf03f454419b0788fff4e91ba46b8bebafeffd/Mako-1.3.0-py3-none-any.whl (78 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 78.6/78.6 kB 2.2 MB/s eta 0:00:00
Collecting importlib-resources (from alembic>=0.7->flask-migrate<4.0,>=3.1.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/93/e8/facde510585869b5ec694e8e0363ffe4eba067cb357a8398a55f6a1f8023/importlib_resources-6.1.1-py3-none-any.whl (33 kB)
Collecting pycparser (from cffi>=1.12->cryptography<40,>=39.0.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/62/d5/5f610ebe421e85889f2e55e33b7f9a6795bd982198517d912eb1c76e1a53/pycparser-2.21-py2.py3-none-any.whl (118 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 118.7/118.7 kB 14.4 MB/s eta 0:00:00
Collecting prompt-toolkit>=3.0.36 (from click-repl>=0.2.0->celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ee/fd/ca7bf3869e7caa7a037e23078539467b433a4e01eebd93f77180ab927766/prompt_toolkit-3.0.43-py3-none-any.whl (386 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 386.1/386.1 kB 4.9 MB/s eta 0:00:00
Collecting pymeeus<=1,>=0.3.13 (from convertdate>=2.3.0->holidays<0.18,>=0.17.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/81/76/599896b37e60f43078afd8354b3802eb7ca257a7e7f6253cc21c4c672877/PyMeeus-0.5.12.tar.gz (5.8 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 5.8/5.8 MB 10.0 MB/s eta 0:00:00
Preparing metadata (setup.py) ... done
Collecting dnspython>=1.15.0 (from email-validator<2,>=1.0.5->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/f6/b4/0a9bee52c50f226a3cbfb54263d02bb421c7f2adc136520729c2c689c1e5/dnspython-2.4.2-py3-none-any.whl (300 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 300.4/300.4 kB 4.4 MB/s eta 0:00:00
Collecting idna>=2.0.0 (from email-validator<2,>=1.0.5->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/c2/e7/a82b05cf63a603df6e68d59ae6a68bf5064484a0718ea5033660af4b54a9/idna-3.6-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.6/61.6 kB 4.5 MB/s eta 0:00:00
Collecting Babel>=2.3 (from Flask-Babel<3,>=1->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/0d/35/4196b21041e29a42dc4f05866d0c94fa26c9da88ce12c38c2265e42c82fb/Babel-2.14.0-py3-none-any.whl (11.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 11.0/11.0 MB 10.8 MB/s eta 0:00:00
Collecting limits>=2.8 (from Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/e5/1f/a058c5644b873f7f12849d6d5cf00fcdd81d640a49c54716a55b05d6793e/limits-3.7.0-py3-none-any.whl (43 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 43.1/43.1 kB 4.8 MB/s eta 0:00:00
Collecting ordered-set<5,>4 (from Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/33/55/af02708f230eb77084a299d7b08175cff006dea4f2721074b92cdb0296c0/ordered_set-4.1.0-py3-none-any.whl (7.6 kB)
Collecting rich<14,>=12 (from Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/be/be/1520178fa01eabe014b16e72a952b9f900631142ccd03dc36cf93e30c1ce/rich-13.7.0-py3-none-any.whl (240 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 240.6/240.6 kB 4.5 MB/s eta 0:00:00
Collecting zipp>=0.5 (from importlib-metadata>=3.6.0->flask<3.0.0,>=2.2.5->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/d9/66/48866fc6b158c81cc2bfecc04c480f105c6040e8b077bc54c634b4a67926/zipp-3.17.0-py3-none-any.whl (7.4 kB)
Collecting attrs>=22.2.0 (from jsonschema<5,>=3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/e0/44/827b2a91a5816512fcaf3cc4ebc465ccd5d598c45cefa6703fcf4a79018f/attrs-23.2.0-py3-none-any.whl (60 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 60.8/60.8 kB 12.9 MB/s eta 0:00:00
Collecting jsonschema-specifications>=2023.03.6 (from jsonschema<5,>=3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ee/07/44bd408781594c4d0a027666ef27fab1e441b109dc3b76b4f836f8fd04fe/jsonschema_specifications-2023.12.1-py3-none-any.whl (18 kB)
Collecting pkgutil-resolve-name>=1.3.10 (from jsonschema<5,>=3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/c9/5c/3d4882ba113fd55bdba9326c1e4c62a15e674a2501de4869e6bd6301f87e/pkgutil_resolve_name-1.3.10-py3-none-any.whl (4.7 kB)
Collecting referencing>=0.28.4 (from jsonschema<5,>=3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/14/2a/0a9f649354cd2d40f6c4f16eadabd9727377e3b9bc2ccec6cb630d9a6765/referencing-0.32.1-py3-none-any.whl (26 kB)
Collecting rpds-py>=0.7.1 (from jsonschema<5,>=3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/97/f1/37d7d4ea8af857eeebd4ae7783cdaa661ea714f27a9b2f1054cc3452eda2/rpds_py-0.17.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 9.0 MB/s eta 0:00:00
Collecting amqp<6.0.0,>=5.1.1 (from kombu<6.0,>=5.3.4->celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b3/f0/8e5be5d5e0653d9e1d02b1144efa33ff7d2963dfad07049e02c0fa9b2e8d/amqp-5.2.0-py3-none-any.whl (50 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 50.9/50.9 kB 8.9 MB/s eta 0:00:00
Collecting bcrypt>=3.2 (from paramiko>=2.7.2->sshtunnel<0.5,>=0.4.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/41/ed/e446078ebe94d8ccac7170ff4bab83d8c86458c6fcfc7c5a4b449974fdd6/bcrypt-4.1.2-cp37-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (699 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 699.1/699.1 kB 4.4 MB/s eta 0:00:00
Collecting pynacl>=1.5 (from paramiko>=2.7.2->sshtunnel<0.5,>=0.4.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/66/28/ca86676b69bf9f90e710571b67450508484388bfce09acf8a46f0b8c785f/PyNaCl-1.5.0-cp36-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.1/1.1 MB 7.8 MB/s eta 0:00:00
Collecting sortedcontainers (from trio~=0.17->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/32/46/9cb0e58b2deb7f82b84065f37f3bffeb12413f947f9388e4cac22c4621ce/sortedcontainers-2.4.0-py2.py3-none-any.whl (29 kB)
Collecting outcome (from trio~=0.17->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/55/8b/5ab7257531a5d830fc8000c476e63c935488d74609b50f9384a643ec0a62/outcome-1.3.0.post0-py2.py3-none-any.whl (10 kB)
Collecting sniffio>=1.3.0 (from trio~=0.17->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/c3/a0/5dba8ed157b0136607c7f2151db695885606968d1fae123dc3391e0cfdbf/sniffio-1.3.0-py3-none-any.whl (10 kB)
Collecting exceptiongroup (from trio~=0.17->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b8/9a/5028fd52db10e600f1c4674441b968cf2ea4959085bfb5b99fb1250e5f68/exceptiongroup-1.2.0-py3-none-any.whl (16 kB)
Collecting wsproto>=0.14 (from trio-websocket~=0.9->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/78/58/e860788190eba3bcce367f74d29c4675466ce8dddfba85f7827588416f01/wsproto-1.2.0-py3-none-any.whl (24 kB)
Collecting pysocks!=1.5.7,<2.0,>=1.5.6 (from urllib3[socks]<3,>=1.26->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/8d/59/b4572118e098ac8e46e399a1dd0f2d85403ce8bbaad9ec79373ed6badaf9/PySocks-1.7.1-py3-none-any.whl (16 kB)
Collecting deprecated>=1.2 (from limits>=2.8->Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/20/8d/778b7d51b981a96554f29136cd59ca7880bf58094338085bcf2a979a0e6a/Deprecated-1.2.14-py2.py3-none-any.whl (9.6 kB)
Collecting wcwidth (from prompt-toolkit>=3.0.36->click-repl>=0.2.0->celery<6.0.0,>=5.2.2->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/fd/84/fd2ba7aafacbad3c4201d395674fc6348826569da3c0937e75505ead3528/wcwidth-0.2.13-py2.py3-none-any.whl (34 kB)
Collecting markdown-it-py>=2.2.0 (from rich<14,>=12->Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/42/d7/1ec15b46af6af88f19b8e5ffea08fa375d433c998b8a7639e76935c14f1f/markdown_it_py-3.0.0-py3-none-any.whl (87 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 87.5/87.5 kB 2.8 MB/s eta 0:00:00
Collecting pygments<3.0.0,>=2.13.0 (from rich<14,>=12->Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/97/9c/372fef8377a6e340b1704768d20daaded98bf13282b5327beb2e2fe2c7ef/pygments-2.17.2-py3-none-any.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 5.0 MB/s eta 0:00:00
Collecting h11<1,>=0.9.0 (from wsproto>=0.14->trio-websocket~=0.9->selenium>=3.141.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/95/04/ff642e65ad6b90db43e668d70ffb6736436c7ce41fcc549f4e9472234127/h11-0.14.0-py3-none-any.whl (58 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 58.3/58.3 kB 20.4 MB/s eta 0:00:00
Collecting wrapt<2,>=1.10 (from deprecated>=1.2->limits>=2.8->Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/ef/c6/56e718e2c58a4078518c14d97e531ef1e9e8a5c1ddafdc0d264a92be1a1a/wrapt-1.16.0-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (83 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 83.4/83.4 kB 3.2 MB/s eta 0:00:00
Collecting mdurl~=0.1 (from markdown-it-py>=2.2.0->rich<14,>=12->Flask-Limiter<4,>3->flask-appbuilder<5.0.0,>=4.3.0->apache-superset)
Downloading https://mirrors.cloud.tencent.com/pypi/packages/b3/38/89ba8ad64ae25be8de66a6d463314cf1eb366222074cfda9ee839c56a4b4/mdurl-0.1.2-py3-none-any.whl (10.0 kB)
Building wheels for collected packages: apache-superset, cron-descriptor, func_timeout, pgsanity, python-geohash, wtforms-json, pymeeus
Building wheel for apache-superset (setup.py) ... done
Created wheel for apache-superset: filename=apache_superset-2.1.3-py3-none-any.whl size=48395941 sha256=366fe5ad34abd711fdcea59ffeb4f2f1709b359398dc6829860ffd9133d1f8a1
Stored in directory: /root/.cache/pip/wheels/c4/21/e3/a3534608124f3b5ff015f8efe42c74b7b89492acf279430999
Building wheel for cron-descriptor (setup.py) ... done
Created wheel for cron-descriptor: filename=cron_descriptor-1.4.0-py3-none-any.whl size=49837 sha256=1bec949828ea2335cc06585b88f5258b356ea7b3cc587b5ced38ab368f0e559c
Stored in directory: /root/.cache/pip/wheels/f4/17/3c/5b213322da8ad5544d38b4e7d3f11afa751bd914cae1f75f1c
Building wheel for func_timeout (setup.py) ... done
Created wheel for func_timeout: filename=func_timeout-4.3.5-py3-none-any.whl size=15080 sha256=569918b1b6c48a18cfa984a1ab80943fdc7bf564710ca506428835bb81f937d5
Stored in directory: /root/.cache/pip/wheels/79/19/6c/8cad795e5a907555b21ea4bbb8f92bf699ee4fcac022e7e02e
Building wheel for pgsanity (setup.py) ... done
Created wheel for pgsanity: filename=pgsanity-0.2.9-py3-none-any.whl size=5625 sha256=89e01bdb539a7add97143ece75b8d4c3f46f95436d682abfd46d4b9504399bcb
Stored in directory: /root/.cache/pip/wheels/5c/49/d5/ad04f42bec1dc7c1fd0cc3b08f84f092628d95640dd2edbddc
Building wheel for python-geohash (setup.py) ... done
Created wheel for python-geohash: filename=python_geohash-0.8.5-cp38-cp38-linux_x86_64.whl size=40326 sha256=c24f13c73535eca8b8bb0eb1569c35be432020517d608e6d708ea0231f825cb9
Stored in directory: /root/.cache/pip/wheels/3a/a1/34/3d8cd8d77f399ae98fc334956f2f23cbd9aec816310c996e46
Building wheel for wtforms-json (setup.py) ... done
Created wheel for wtforms-json: filename=WTForms_JSON-0.3.5-py3-none-any.whl size=4772 sha256=e09524d693f1eb749733ef358fd7bf8f60e295818d709859f6aa5793d850269a
Stored in directory: /root/.cache/pip/wheels/f7/c2/61/6d0066767ad29dd71c367f6b101c25b504049836dfcb8bc133
Building wheel for pymeeus (setup.py) ... done
Created wheel for pymeeus: filename=PyMeeus-0.5.12-py3-none-any.whl size=732000 sha256=dfa6b0f5f35dc811496997c685a4e4227a9349ecc831be5bbe6ed0d65feea4cf
Stored in directory: /root/.cache/pip/wheels/36/96/75/4a542c54af01690c68f852b4aff95b97797f9f73e3243da60a
Successfully built apache-superset cron-descriptor func_timeout pgsanity python-geohash wtforms-json pymeeus
Installing collected packages: wcwidth, sortedcontainers, pytz, python-geohash, pymeeus, pgsanity, parsedatetime, nh3, korean-lunar-calendar, func_timeout, flask-talisman, cron-descriptor, brotli, zipp, xlsxwriter, wrapt, vine, urllib3, tzdata, typing-extensions, tabulate, sqlparse, sniffio, slack_sdk, six, simplejson, rpds-py, pyyaml, python-dotenv, pysocks, pyparsing, PyJWT, pygments, pycparser, prompt-toolkit, polyline, pkgutil-resolve-name, packaging, ordered-set, numpy, msgpack, mdurl, MarkupSafe, itsdangerous, idna, humanize, hijri-converter, hashids, h11, greenlet, graphlib-backport, geographiclib, exceptiongroup, dnspython, convertdate, colorama, click, certifi, cachelib, billiard, bcrypt, backports.zoneinfo, backoff, Babel, attrs, async-timeout, wtforms, wsproto, werkzeug, sqlalchemy, referencing, redis, python-dateutil, pyarrow, prison, outcome, marshmallow, markdown-it-py, Mako, Jinja2, isodate, importlib-resources, importlib-metadata, gunicorn, geopy, email-validator, deprecation, deprecated, click-repl, click-plugins, click-didyoumean, cffi, apispec, amqp, wtforms-json, trio, sqlalchemy-utils, rich, pynacl, pandas, marshmallow-sqlalchemy, markdown, limits, kombu, jsonschema-specifications, holidays, flask, cryptography, croniter, alembic, trio-websocket, paramiko, jsonschema, flask-wtf, Flask-SQLAlchemy, flask-login, Flask-Limiter, Flask-JWT-Extended, flask-compress, flask-caching, Flask-Babel, celery, sshtunnel, selenium, flask-migrate, flask-appbuilder, apache-superset
Successfully installed Babel-2.14.0 Flask-Babel-2.0.0 Flask-JWT-Extended-4.6.0 Flask-Limiter-3.5.0 Flask-SQLAlchemy-2.5.1 Jinja2-3.1.3 Mako-1.3.0 MarkupSafe-2.1.3 PyJWT-2.8.0 alembic-1.13.1 amqp-5.2.0 apache-superset-2.1.3 apispec-6.4.0 async-timeout-4.0.3 attrs-23.2.0 backoff-2.2.1 backports.zoneinfo-0.2.1 bcrypt-4.1.2 billiard-4.2.0 brotli-1.1.0 cachelib-0.4.1 celery-5.3.6 certifi-2023.11.17 cffi-1.16.0 click-8.1.7 click-didyoumean-0.3.0 click-plugins-1.1.1 click-repl-0.3.0 colorama-0.4.6 convertdate-2.4.0 cron-descriptor-1.4.0 croniter-2.0.1 cryptography-39.0.2 deprecated-1.2.14 deprecation-2.1.0 dnspython-2.4.2 email-validator-1.3.1 exceptiongroup-1.2.0 flask-2.2.5 flask-appbuilder-4.3.10 flask-caching-1.10.1 flask-compress-1.14 flask-login-0.6.0 flask-migrate-3.1.0 flask-talisman-1.1.0 flask-wtf-1.0.1 func_timeout-4.3.5 geographiclib-2.0 geopy-2.4.1 graphlib-backport-1.0.3 greenlet-3.0.3 gunicorn-21.2.0 h11-0.14.0 hashids-1.3.1 hijri-converter-2.3.1 holidays-0.17.2 humanize-4.9.0 idna-3.6 importlib-metadata-7.0.1 importlib-resources-6.1.1 isodate-0.6.1 itsdangerous-2.1.2 jsonschema-4.20.0 jsonschema-specifications-2023.12.1 kombu-5.3.5 korean-lunar-calendar-0.3.1 limits-3.7.0 markdown-3.5.2 markdown-it-py-3.0.0 marshmallow-3.20.2 marshmallow-sqlalchemy-0.26.1 mdurl-0.1.2 msgpack-1.0.7 nh3-0.2.15 numpy-1.23.5 ordered-set-4.1.0 outcome-1.3.0.post0 packaging-23.2 pandas-1.5.3 paramiko-3.4.0 parsedatetime-2.6 pgsanity-0.2.9 pkgutil-resolve-name-1.3.10 polyline-2.0.1 prison-0.2.1 prompt-toolkit-3.0.43 pyarrow-10.0.1 pycparser-2.21 pygments-2.17.2 pymeeus-0.5.12 pynacl-1.5.0 pyparsing-3.1.1 pysocks-1.7.1 python-dateutil-2.8.2 python-dotenv-1.0.0 python-geohash-0.8.5 pytz-2023.3.post1 pyyaml-6.0.1 redis-5.0.1 referencing-0.32.1 rich-13.7.0 rpds-py-0.17.1 selenium-4.16.0 simplejson-3.19.2 six-1.16.0 slack_sdk-3.26.2 sniffio-1.3.0 sortedcontainers-2.4.0 sqlalchemy-1.4.51 sqlalchemy-utils-0.38.3 sqlparse-0.4.4 sshtunnel-0.4.0 tabulate-0.8.10 trio-0.24.0 trio-websocket-0.11.1 typing-extensions-4.9.0 tzdata-2023.4 urllib3-2.1.0 vine-5.1.0 wcwidth-0.2.13 werkzeug-2.3.8 wrapt-1.16.0 wsproto-1.2.0 wtforms-3.1.2 wtforms-json-0.3.5 xlsxwriter-3.0.9 zipp-3.17.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
- 配置Supetset元数据库
# 登录mysql，创建元数据库
mysql> CREATE DATABASE superset DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
# 创建用户
mysql> create user superset@'%' identified WITH mysql_native_password BY '123456';
mysql> grant all privileges on *.* to superset@'%' with grant option;
mysql> flush privileges;
# 修改配置文件
$ vim /opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/config.py
# 修改如下
# SQLALCHEMY_DATABASE_URI = "sqlite:///" + os.path.join(DATA_DIR, "superset.db")
SQLALCHEMY_DATABASE_URI = 'mysql://superset:123456@slave1:3306/superset?charset=utf8'
# 安装驱动
$ conda install mysqlclient
# 初始化元数据
(superset) [root@slave1 ~]$ export FLASK_APP=superset
(superset) [root@slave1 ~]$ superset db upgrade
查看详情
- 报错
mysql> create user superset@'%' identified WITH mysql_native_password BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- 解决方案
mysql> SHOW VARIABLES LIKE "validate_password%";
+-------------------------------------------------+--------+
| Variable_name | Value |
+-------------------------------------------------+--------+
| validate_password.changed_characters_percentage | 0 |
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 8 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | MEDIUM |
| validate_password.special_char_count | 1 |
+-------------------------------------------------+--------+
8 rows in set (0.01 sec)
mysql> set global validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password.length=6;
Query OK, 0 rows affected (0.01 sec)
mysql> SHOW VARIABLES LIKE "validate_password%";
+-------------------------------------------------+-------+
| Variable_name | Value |
+-------------------------------------------------+-------+
| validate_password.changed_characters_percentage | 0 |
| validate_password.check_user_name | ON |
| validate_password.dictionary_file | |
| validate_password.length | 6 |
| validate_password.mixed_case_count | 1 |
| validate_password.number_count | 1 |
| validate_password.policy | LOW |
| validate_password.special_char_count | 1 |
+-------------------------------------------------+-------+
8 rows in set (0.00 sec)
mysql> create user superset@'%' identified WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to superset@'%' with grant option;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
- 配置
(superset) [root@slave1 ~]# vim /opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/config.py
(superset) [root@slave1 ~]# conda install mysqlclient
Retrieving notices: ...working... done
Channels:
- defaults
Platform: linux-64
Collecting package metadata (repodata.json): done
Solving environment: done
## Package Plan ##
environment location: /opt/onlineedu/miniconda3/envs/superset
added / updated specs:
- mysqlclient
The following packages will be downloaded:
package | build
---------------------------|-----------------
mysql-connector-c-6.1.11 | h24aacaa_2 1.2 MB
mysqlclient-2.0.3 | py38h2531618_1 78 KB
openssl-1.1.1w | h7f8727e_0 3.7 MB
python-3.8.18 | h7a1cb2a_0 25.3 MB
------------------------------------------------------------
Total: 30.3 MB
The following NEW packages will be INSTALLED:
mysql-connector-c pkgs/main/linux-64::mysql-connector-c-6.1.11-h24aacaa_2
mysqlclient pkgs/main/linux-64::mysqlclient-2.0.3-py38h2531618_1
The following packages will be DOWNGRADED:
openssl 3.0.12-h7f8727e_0 --> 1.1.1w-h7f8727e_0
python 3.8.18-h955ad1f_0 --> 3.8.18-h7a1cb2a_0
Proceed ([y]/n)? y
Downloading and Extracting Packages:
Preparing transaction: done
Verifying transaction: done
Executing transaction: done
(superset) [root@slave1 ~]# export FLASK_APP=superset
- 初始化元数据
(superset) [root@slave1 ~]# superset db upgrade
--------------------------------------------------------------------------------
WARNING
--------------------------------------------------------------------------------
A Default SECRET_KEY was detected, please use superset_config.py to override it.
Use a strong complex alphanumeric string and use a tool to help you generate
a sufficiently random sequence, ex: openssl rand -base64 42
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Refusing to start due to insecure SECRET_KEY
- 解决方案
# 进入如下目录
(superset) [root@slave1 ~]# cd /opt/onlineedu/miniconda3/envs/superset/lib
(superset) [root@slave1 lib]# openssl rand -base64 42
07kW6BTf0e5bFvreACqZ0Ui+QgS8zaOA5gpvywL2lJRJ97xvz5EhIxOw
(superset) [root@slave1 lib]# vim superset_config.py
# 配置
(superset) [root@slave1 lib]# vim /etc/profile
# 配置如下
export SUPERSET_CONFIG_PATH=/opt/onlineedu/miniconda3/envs/superset/lib/superset_config.py
# 生效
(superset) [root@slave1 lib]# source /etc/profile
- superset_config.py
# Superset specific config
# SS 相关的配置
# 行数限制 5000 行
ROW_LIMIT = 5000
# 网站服务器端口 8088
SUPERSET_WEBSERVER_PORT = 8088
# Flask App Builder configuration
# Your App secret key will be used for securely signing the session cookie
# and encrypting sensitive information on the database
# Make sure you are changing this key for your deployment with a strong key.
# You can generate a strong key using `openssl rand -base64 42`
# Flask 应用构建器配置
# 应用密钥用来保护会话 cookie 的安全签名
# 并且用来加密数据库中的敏感信息
# 请确保在你的部署环境选择一个强密钥
# 可以使用命令 openssl rand -base64 42 来生成一个强密钥
SECRET_KEY = "07kW6BTf0e5bFvreACqZ0Ui+QgS8zaOA5gpvywL2lJRJ97xvz5EhIxOw"
# The SQLAlchemy connection string to your database backend
# This connection defines the path to the database that stores your
# superset metadata (slices, connections, tables, dashboards, ...).
# Note that the connection information to connect to the datasources
# you want to explore are managed directly in the web UI
# SQLAlchemy 数据库连接信息
# 这个连接信息定义了 SS 元数据库的路径（切片、连接、表、数据面板等等）
# 注意：需要探索的数据源连接及数据库连接直接通过网页界面进行管理
#SQLALCHEMY_DATABASE_URI = 'sqlite:path/to/superset.db'
# Flask-WTF flag for CSRF
# 跨域请求攻击标识
WTF_CSRF_ENABLED = True
# Add endpoints that need to be exempt from CSRF protection
# CSRF 白名单
WTF_CSRF_EXEMPT_LIST = []
# A CSRF token that expires in 1 year
# CSFR 令牌过期时间 1 年
WTF_CSRF_TIME_LIMIT = 60 * 60 * 24 * 365
# Set this API key to enable Mapbox visualizations
# 接口密钥用来启用 Mapbox 可视化
MAPBOX_API_KEY = ''
- 再次测试
(superset) [root@slave1 lib]# superset db upgrade
Loaded your LOCAL configuration at [/opt/onlineedu/miniconda3/envs/superset/lib/superset_config.py]
logging was configured successfully
2024-01-13 19:45:56,779:INFO:superset.utils.logging_configurator:logging was configured successfully
2024-01-13 19:45:56,785:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
2024-01-13 19:45:56,786:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_limiter/extension.py:336: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
warnings.warn(
No PIL installation found
2024-01-13 19:45:57,027:INFO:superset.utils.screenshots:No PIL installation found
Failed to create app
Traceback (most recent call last):
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/app.py", line 37, in create_app
app_initializer.init_app()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 493, in init_app
self.init_app_in_ctx()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 425, in init_app_in_ctx
self.configure_data_sources()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 519, in configure_data_sources
__import__(module_name, fromlist=class_names)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/__init__.py", line 17, in <module>
from . import models, views
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/views.py", line 32, in <module>
from superset.connectors.base.views import DatasourceModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/base/views.py", line 24, in <module>
from superset.views.base import SupersetModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/__init__.py", line 17, in <module>
from . import (
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/access_requests.py", line 24, in <module>
from superset.views.base import DeleteMixin, SupersetModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/base.py", line 67, in <module>
from superset.db_engine_specs.gsheets import GSheetsEngineSpec
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/db_engine_specs/gsheets.py", line 33, in <module>
from superset.databases.schemas import encrypted_field_properties, EncryptedString
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/databases/schemas.py", line 28, in <module>
from marshmallow_enum import EnumField
ModuleNotFoundError: No module named 'marshmallow_enum'
2024-01-13 19:45:57,065:ERROR:superset.app:Failed to create app
Traceback (most recent call last):
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/app.py", line 37, in create_app
app_initializer.init_app()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 493, in init_app
self.init_app_in_ctx()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 425, in init_app_in_ctx
self.configure_data_sources()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 519, in configure_data_sources
__import__(module_name, fromlist=class_names)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/__init__.py", line 17, in <module>
from . import models, views
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/views.py", line 32, in <module>
from superset.connectors.base.views import DatasourceModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/base/views.py", line 24, in <module>
from superset.views.base import SupersetModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/__init__.py", line 17, in <module>
from . import (
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/access_requests.py", line 24, in <module>
from superset.views.base import DeleteMixin, SupersetModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/base.py", line 67, in <module>
from superset.db_engine_specs.gsheets import GSheetsEngineSpec
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/db_engine_specs/gsheets.py", line 33, in <module>
from superset.databases.schemas import encrypted_field_properties, EncryptedString
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/databases/schemas.py", line 28, in <module>
from marshmallow_enum import EnumField
ModuleNotFoundError: No module named 'marshmallow_enum'
Traceback (most recent call last):
File "/opt/onlineedu/miniconda3/envs/superset/bin/superset", line 8, in <module>
sys.exit(superset())
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 1157, in __call__
return self.main(*args, **kwargs)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 1078, in main
rv = self.invoke(ctx)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 1685, in invoke
super().invoke(ctx)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/click/decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 354, in decorator
app = __ctx.ensure_object(ScriptInfo).load_app()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 308, in load_app
app = locate_app(import_name, name)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 235, in locate_app
return find_best_app(module)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 63, in find_best_app
app = app_factory()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/app.py", line 44, in create_app
raise ex
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/app.py", line 37, in create_app
app_initializer.init_app()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 493, in init_app
self.init_app_in_ctx()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 425, in init_app_in_ctx
self.configure_data_sources()
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/initialization/__init__.py", line 519, in configure_data_sources
__import__(module_name, fromlist=class_names)
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/__init__.py", line 17, in <module>
from . import models, views
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/views.py", line 32, in <module>
from superset.connectors.base.views import DatasourceModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/base/views.py", line 24, in <module>
from superset.views.base import SupersetModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/__init__.py", line 17, in <module>
from . import (
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/access_requests.py", line 24, in <module>
from superset.views.base import DeleteMixin, SupersetModelView
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/views/base.py", line 67, in <module>
from superset.db_engine_specs.gsheets import GSheetsEngineSpec
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/db_engine_specs/gsheets.py", line 33, in <module>
from superset.databases.schemas import encrypted_field_properties, EncryptedString
File "/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/superset/databases/schemas.py", line 28, in <module>
from marshmallow_enum import EnumField
ModuleNotFoundError: No module named 'marshmallow_enum'
- 解决方案
(superset) [root@slave1 lib]# pip install marshmallow_enum
Collecting marshmallow_enum
Downloading marshmallow_enum-1.5.1-py2.py3-none-any.whl (4.2 kB)
Requirement already satisfied: marshmallow>=2.0.0 in ./python3.8/site-packages (from marshmallow_enum) (3.20.2)
Requirement already satisfied: packaging>=17.0 in ./python3.8/site-packages (from marshmallow>=2.0.0->marshmallow_enum) (23.2)
Installing collected packages: marshmallow_enum
Successfully installed marshmallow_enum-1.5.1
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
- 再次初始化，成功
(superset) [root@slave1 lib]# superset db upgrade
Loaded your LOCAL configuration at [/opt/onlineedu/miniconda3/envs/superset/lib/superset_config.py]
logging was configured successfully
2024-01-13 19:58:11,195:INFO:superset.utils.logging_configurator:logging was configured successfully
2024-01-13 19:58:11,201:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
2024-01-13 19:58:11,201:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_limiter/extension.py:336: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
warnings.warn(
No PIL installation found
2024-01-13 19:58:11,318:INFO:superset.utils.screenshots:No PIL installation found
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_appbuilder/models/sqla/interface.py:64: SAWarning: relationship 'SqlaTable.slices' will copy column tables.id to column slices.datasource_id, which conflicts with relationship(s): 'Slice.table' (copies tables.id to slices.datasource_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="table"' to the 'SqlaTable.slices' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
for prop in class_mapper(obj).iterate_properties:
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade -> 4e6a06bad7a8, Init
INFO [alembic.runtime.migration] Running upgrade 4e6a06bad7a8 -> 5a7bad26f2a7, empty message
INFO [alembic.runtime.migration] Running upgrade 5a7bad26f2a7 -> 1e2841a4128, empty message
INFO [alembic.runtime.migration] Running upgrade 1e2841a4128 -> 2929af7925ed, TZ offsets in data sources
INFO [alembic.runtime.migration] Running upgrade 2929af7925ed -> 289ce07647b, Add encrypted password field
INFO [alembic.runtime.migration] Running upgrade 289ce07647b -> 1a48a5411020, adding slug to dash
INFO [alembic.runtime.migration] Running upgrade 1a48a5411020 -> 315b3f4da9b0, adding log model
INFO [alembic.runtime.migration] Running upgrade 315b3f4da9b0 -> 55179c7f25c7, sqla_descr
INFO [alembic.runtime.migration] Running upgrade 55179c7f25c7 -> 12d55656cbca, is_featured
INFO [alembic.runtime.migration] Running upgrade 12d55656cbca -> 2591d77e9831, user_id
INFO [alembic.runtime.migration] Running upgrade 2591d77e9831 -> 8e80a26a31db, empty message
INFO [alembic.runtime.migration] Running upgrade 8e80a26a31db -> 7dbf98566af7, empty message
INFO [alembic.runtime.migration] Running upgrade 7dbf98566af7 -> 43df8de3a5f4, empty message
INFO [alembic.runtime.migration] Running upgrade 43df8de3a5f4 -> d827694c7555, css templates
INFO [alembic.runtime.migration] Running upgrade d827694c7555 -> 430039611635, log more
INFO [alembic.runtime.migration] Running upgrade 430039611635 -> 18e88e1cc004, making audit nullable
INFO [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> 836c0bf75904, cache_timeouts
INFO [alembic.runtime.migration] Running upgrade 18e88e1cc004 -> a2d606a761d9, adding favstar model
INFO [alembic.runtime.migration] Running upgrade a2d606a761d9, 836c0bf75904 -> d2424a248d63, empty message
INFO [alembic.runtime.migration] Running upgrade d2424a248d63 -> 763d4b211ec9, fixing audit fk
INFO [alembic.runtime.migration] Running upgrade d2424a248d63 -> 1d2ddd543133, log dt
INFO [alembic.runtime.migration] Running upgrade 1d2ddd543133, 763d4b211ec9 -> fee7b758c130, empty message
INFO [alembic.runtime.migration] Running upgrade fee7b758c130 -> 867bf4f117f9, Adding extra field to Database model
INFO [alembic.runtime.migration] Running upgrade 867bf4f117f9 -> bb51420eaf83, add schema to table model
INFO [alembic.runtime.migration] Running upgrade bb51420eaf83 -> b4456560d4f3, change_table_unique_constraint
INFO [alembic.runtime.migration] Running upgrade b4456560d4f3 -> 4fa88fe24e94, owners_many_to_many
INFO [alembic.runtime.migration] Running upgrade 4fa88fe24e94 -> c3a8f8611885, Materializing permission
INFO [alembic.runtime.migration] Running upgrade c3a8f8611885 -> f0fbf6129e13, Adding verbose_name to tablecolumn
INFO [alembic.runtime.migration] Running upgrade f0fbf6129e13 -> 956a063c52b3, adjusting key length
INFO [alembic.runtime.migration] Running upgrade 956a063c52b3 -> 1226819ee0e3, Fix wrong constraint on table columns
INFO [alembic.runtime.migration] Running upgrade 1226819ee0e3 -> d8bc074f7aad, Add new field 'is_restricted' to SqlMetric and DruidMetric
INFO [alembic.runtime.migration] Running upgrade d8bc074f7aad -> 27ae655e4247, Make creator owners
INFO [alembic.runtime.migration] Running upgrade 27ae655e4247 -> 960c69cb1f5b, add dttm_format related fields in table_columns
INFO [alembic.runtime.migration] Running upgrade 960c69cb1f5b -> f162a1dea4c4, d3format_by_metric
INFO [alembic.runtime.migration] Running upgrade f162a1dea4c4 -> ad82a75afd82, Update models to support storing the queries.
INFO [alembic.runtime.migration] Running upgrade ad82a75afd82 -> 3c3ffe173e4f, add_sql_string_to_table
INFO [alembic.runtime.migration] Running upgrade 3c3ffe173e4f -> 41f6a59a61f2, database options for sql lab
INFO [alembic.runtime.migration] Running upgrade 41f6a59a61f2 -> 4500485bde7d, allow_run_sync_async
INFO [alembic.runtime.migration] Running upgrade 4500485bde7d -> 65903709c321, allow_dml
INFO [alembic.runtime.migration] Running upgrade 41f6a59a61f2 -> 33d996bcc382, update slice model
INFO [alembic.runtime.migration] Running upgrade 33d996bcc382, 65903709c321 -> b347b202819b, empty message
INFO [alembic.runtime.migration] Running upgrade b347b202819b -> 5e4a03ef0bf0, Add access_request table to manage requests to access datastores.
INFO [alembic.runtime.migration] Running upgrade 5e4a03ef0bf0 -> eca4694defa7, sqllab_setting_defaults
INFO [alembic.runtime.migration] Running upgrade eca4694defa7 -> ab3d66c4246e, add_cache_timeout_to_druid_cluster
INFO [alembic.runtime.migration] Running upgrade eca4694defa7 -> 3b626e2a6783, Sync DB with the models.py.
(MySQLdb._exceptions.OperationalError) (1828, "Cannot drop column 'druid_datasource_id': needed in a foreign key constraint 'slices_ibfk_1'")
[SQL: ALTER TABLE slices DROP COLUMN druid_datasource_id]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
INFO [alembic.runtime.migration] Running upgrade 3b626e2a6783, ab3d66c4246e -> ef8843b41dac, empty message
INFO [alembic.runtime.migration] Running upgrade ef8843b41dac -> b46fa1b0b39e, Add json_metadata to the tables table.
INFO [alembic.runtime.migration] Running upgrade b46fa1b0b39e -> 7e3ddad2a00b, results_key to query
INFO [alembic.runtime.migration] Running upgrade 7e3ddad2a00b -> ad4d656d92bc, Add avg() to default metrics
INFO [alembic.runtime.migration] Running upgrade ad4d656d92bc -> c611f2b591b8, dim_spec
INFO [alembic.runtime.migration] Running upgrade c611f2b591b8 -> e46f2d27a08e, materialize perms
INFO [alembic.runtime.migration] Running upgrade e46f2d27a08e -> f1f2d4af5b90, Enable Filter Select
INFO [alembic.runtime.migration] Running upgrade e46f2d27a08e -> 525c854f0005, log_this_plus
INFO [alembic.runtime.migration] Running upgrade 525c854f0005, f1f2d4af5b90 -> 6414e83d82b7, empty message
INFO [alembic.runtime.migration] Running upgrade 6414e83d82b7 -> 1296d28ec131, Adds params to the datasource (druid) table
INFO [alembic.runtime.migration] Running upgrade 1296d28ec131 -> f18570e03440, Add index on the result key to the query table.
INFO [alembic.runtime.migration] Running upgrade f18570e03440 -> bcf3126872fc, Add keyvalue table
INFO [alembic.runtime.migration] Running upgrade f18570e03440 -> db0c65b146bd, update_slice_model_json
INFO [alembic.runtime.migration] Running upgrade db0c65b146bd -> a99f2f7c195a, rewriting url from shortener with new format
INFO [alembic.runtime.migration] Running upgrade a99f2f7c195a, bcf3126872fc -> d6db5a5cdb5d, empty message
INFO [alembic.runtime.migration] Running upgrade d6db5a5cdb5d -> b318dfe5fb6c, adding verbose_name to druid column
INFO [alembic.runtime.migration] Running upgrade d6db5a5cdb5d -> 732f1c06bcbf, add fetch values predicate
INFO [alembic.runtime.migration] Running upgrade 732f1c06bcbf, b318dfe5fb6c -> ea033256294a, empty message
INFO [alembic.runtime.migration] Running upgrade b318dfe5fb6c -> db527d8c4c78, Add verbose name to DruidCluster and Database
INFO [alembic.runtime.migration] Running upgrade db527d8c4c78, ea033256294a -> 979c03af3341, empty message
INFO [alembic.runtime.migration] Running upgrade 979c03af3341 -> a6c18f869a4e, query.start_running_time
INFO [alembic.runtime.migration] Running upgrade a6c18f869a4e -> 2fcdcb35e487, saved_queries
INFO [alembic.runtime.migration] Running upgrade 2fcdcb35e487 -> a65458420354, add_result_backend_time_logging
INFO [alembic.runtime.migration] Running upgrade a65458420354 -> ca69c70ec99b, tracking_url
INFO [alembic.runtime.migration] Running upgrade ca69c70ec99b -> a9c47e2c1547, add impersonate_user to dbs
INFO [alembic.runtime.migration] Running upgrade ca69c70ec99b -> ddd6ebdd853b, annotations
INFO [alembic.runtime.migration] Running upgrade a9c47e2c1547, ddd6ebdd853b -> d39b1e37131d, empty message
INFO [alembic.runtime.migration] Running upgrade ca69c70ec99b -> 19a814813610, Adding metric warning_text
INFO [alembic.runtime.migration] Running upgrade 19a814813610, a9c47e2c1547 -> 472d2f73dfd4, empty message
INFO [alembic.runtime.migration] Running upgrade 472d2f73dfd4, d39b1e37131d -> f959a6652acd, empty message
INFO [alembic.runtime.migration] Running upgrade f959a6652acd -> 4736ec66ce19, empty message
INFO [alembic.runtime.migration] Running upgrade 4736ec66ce19 -> 67a6ac9b727b, update_spatial_params
INFO [alembic.runtime.migration] Running upgrade 67a6ac9b727b -> 21e88bc06c02, migrate_old_annotation_layers
INFO [alembic.runtime.migration] Running upgrade 21e88bc06c02 -> e866bd2d4976, smaller_grid
INFO [alembic.runtime.migration] Running upgrade e866bd2d4976 -> e68c4473c581, allow_multi_schema_metadata_fetch
INFO [alembic.runtime.migration] Running upgrade e68c4473c581 -> f231d82b9b26, empty message
INFO [alembic.runtime.migration] Running upgrade f231d82b9b26 -> bf706ae5eb46, cal_heatmap_metric_to_metrics
INFO [alembic.runtime.migration] Running upgrade f231d82b9b26 -> 30bb17c0dc76, empty message
INFO [alembic.runtime.migration] Running upgrade 30bb17c0dc76, bf706ae5eb46 -> c9495751e314, empty message
INFO [alembic.runtime.migration] Running upgrade f231d82b9b26 -> 130915240929, is_sqllab_view
INFO [alembic.runtime.migration] Running upgrade 130915240929, c9495751e314 -> 5ccf602336a0, empty message
INFO [alembic.runtime.migration] Running upgrade 5ccf602336a0 -> e502db2af7be, add template_params to tables
INFO [alembic.runtime.migration] Running upgrade e502db2af7be -> c5756bec8b47, Time grain SQLA
INFO [alembic.runtime.migration] Running upgrade c5756bec8b47 -> afb7730f6a9c, remove empty filters
INFO [alembic.runtime.migration] Running upgrade afb7730f6a9c -> 80a67c5192fa, single pie chart metric
INFO [alembic.runtime.migration] Running upgrade 80a67c5192fa -> bddc498dd179, adhoc filters
INFO [alembic.runtime.migration] Running upgrade bddc498dd179 -> 4451805bbaa1, remove double percents
INFO [alembic.runtime.migration] Running upgrade bddc498dd179 -> 3dda56f1c4c6, Migrate num_period_compare and period_ratio_type
INFO [alembic.runtime.migration] Running upgrade 3dda56f1c4c6 -> 1d9e835a84f9, empty message
INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> e3970889f38e, empty message
INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> 705732c70154, empty message
INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> fc480c87706c, empty message
INFO [alembic.runtime.migration] Running upgrade fc480c87706c -> bebcf3fed1fe, Migrate dashboard position_json data from V1 to V2
INFO [alembic.runtime.migration] Running upgrade bebcf3fed1fe, 705732c70154 -> ec1f88a35cc6, empty message
INFO [alembic.runtime.migration] Running upgrade 705732c70154, e3970889f38e -> 46ba6aaaac97, empty message
INFO [alembic.runtime.migration] Running upgrade 46ba6aaaac97, ec1f88a35cc6 -> c18bd4186f15, empty message
INFO [alembic.runtime.migration] Running upgrade c18bd4186f15 -> 7fcdcde0761c, Reduce position_json size by remove extra space and component id prefix
INFO [alembic.runtime.migration] Running upgrade 7fcdcde0761c -> 0c5070e96b57, add user attributes table
INFO [alembic.runtime.migration] Running upgrade 0c5070e96b57 -> 1a1d627ebd8e, position_json
INFO [alembic.runtime.migration] Running upgrade 1a1d627ebd8e -> 55e910a74826, add_metadata_column_to_annotation_model.py
INFO [alembic.runtime.migration] Running upgrade 55e910a74826 -> 4ce8df208545, empty message
INFO [alembic.runtime.migration] Running upgrade 4ce8df208545 -> 46f444d8b9b7, remove_coordinator_from_druid_cluster_model.py
INFO [alembic.runtime.migration] Running upgrade 46f444d8b9b7 -> a61b40f9f57f, remove allow_run_sync
INFO [alembic.runtime.migration] Running upgrade a61b40f9f57f -> 6c7537a6004a, models for email reports
INFO [alembic.runtime.migration] Running upgrade 6c7537a6004a -> 3e1b21cd94a4, change_owner_to_m2m_relation_on_datasources.py
INFO [alembic.runtime.migration] Running upgrade 6c7537a6004a -> cefabc8f7d38, Increase size of name column in ab_view_menu
INFO [alembic.runtime.migration] Running upgrade 55e910a74826 -> 0b1f1ab473c0, Add extra column to Query
INFO [alembic.runtime.migration] Running upgrade 0b1f1ab473c0, cefabc8f7d38, 3e1b21cd94a4 -> de021a1ca60d, empty message
INFO [alembic.runtime.migration] Running upgrade de021a1ca60d -> fb13d49b72f9, better_filters
INFO [alembic.runtime.migration] Running upgrade fb13d49b72f9 -> a33a03f16c4a, Add extra column to SavedQuery
INFO [alembic.runtime.migration] Running upgrade 4451805bbaa1, 1d9e835a84f9 -> c829ff0b37d0, empty message
INFO [alembic.runtime.migration] Running upgrade c829ff0b37d0 -> 7467e77870e4, remove_aggs
INFO [alembic.runtime.migration] Running upgrade 7467e77870e4, de021a1ca60d -> fbd55e0f83eb, empty message
INFO [alembic.runtime.migration] Running upgrade fbd55e0f83eb, fb13d49b72f9 -> 8b70aa3d0f87, empty message
INFO [alembic.runtime.migration] Running upgrade 8b70aa3d0f87, a33a03f16c4a -> 18dc26817ad2, empty message
INFO [alembic.runtime.migration] Running upgrade 18dc26817ad2 -> c617da68de7d, form nullable
INFO [alembic.runtime.migration] Running upgrade c617da68de7d -> c82ee8a39623, Add implicit tags
INFO [alembic.runtime.migration] Running upgrade 18dc26817ad2 -> e553e78e90c5, add_druid_auth_py.py
INFO [alembic.runtime.migration] Running upgrade e553e78e90c5, c82ee8a39623 -> 45e7da7cfeba, empty message
INFO [alembic.runtime.migration] Running upgrade 45e7da7cfeba -> 80aa3f04bc82, Add Parent ids in dashboard layout metadata
INFO [alembic.runtime.migration] Running upgrade 80aa3f04bc82 -> d94d33dbe938, form strip
INFO [alembic.runtime.migration] Running upgrade d94d33dbe938 -> 937d04c16b64, update datasources
INFO [alembic.runtime.migration] Running upgrade 937d04c16b64 -> 7f2635b51f5d, update base columns
INFO [alembic.runtime.migration] Running upgrade 7f2635b51f5d -> e9df189e5c7e, update base metrics
INFO [alembic.runtime.migration] Running upgrade e9df189e5c7e -> afc69274c25a, update the sql, select_sql, and executed_sql columns in the
query table in mysql dbs to be long text columns
INFO [alembic.runtime.migration] Running upgrade afc69274c25a -> d7c1a0d6f2da, Remove limit used from query model
INFO [alembic.runtime.migration] Running upgrade d7c1a0d6f2da -> ab8c66efdd01, resample
INFO [alembic.runtime.migration] Running upgrade ab8c66efdd01 -> b4a38aa87893, deprecate database expression
INFO [alembic.runtime.migration] Running upgrade b4a38aa87893 -> d6ffdf31bdd4, Add published column to dashboards
INFO [alembic.runtime.migration] Running upgrade d6ffdf31bdd4 -> 190188938582, Remove duplicated entries in dashboard_slices table and add unique constraint
INFO [alembic.runtime.migration] Running upgrade 190188938582 -> def97f26fdfb, Add index to tagged_object
INFO [alembic.runtime.migration] Running upgrade def97f26fdfb -> 11c737c17cc6, deprecate_restricted_metrics
INFO [alembic.runtime.migration] Running upgrade 11c737c17cc6 -> 258b5280a45e, form strip leading and trailing whitespace
INFO [alembic.runtime.migration] Running upgrade 258b5280a45e -> 1495eb914ad3, time range
INFO [alembic.runtime.migration] Running upgrade 1495eb914ad3 -> b6fa807eac07, make_names_non_nullable
INFO [alembic.runtime.migration] Running upgrade b6fa807eac07 -> cca2f5d568c8, add encrypted_extra to dbs
INFO [alembic.runtime.migration] Running upgrade cca2f5d568c8 -> c2acd2cf3df2, alter type of dbs encrypted_extra
INFO [alembic.runtime.migration] Running upgrade c2acd2cf3df2 -> 78ee127d0d1d, reconvert legacy filters into adhoc
INFO [alembic.runtime.migration] Running upgrade 78ee127d0d1d -> db4b49eb0782, Add tables for SQL Lab state
INFO [alembic.runtime.migration] Running upgrade db4b49eb0782 -> 5afa9079866a, serialize_schema_permissions.py
INFO [alembic.runtime.migration] Running upgrade 5afa9079866a -> 89115a40e8ea, Change table schema description to long text
INFO [alembic.runtime.migration] Running upgrade 89115a40e8ea -> 817e1c9b09d0, add_not_null_to_dbs_sqlalchemy_url
INFO [alembic.runtime.migration] Running upgrade 817e1c9b09d0 -> e96dbf2cfef0, datasource_cluster_fk
INFO [alembic.runtime.migration] Running upgrade e96dbf2cfef0 -> 3325d4caccc8, empty message
INFO [alembic.runtime.migration] Running upgrade 3325d4caccc8 -> 0a6f12f60c73, add_role_level_security
INFO [alembic.runtime.migration] Running upgrade 0a6f12f60c73 -> 72428d1ea401, Add tmp_schema_name to the query object.
INFO [alembic.runtime.migration] Running upgrade 72428d1ea401 -> b5998378c225, add certificate to dbs
INFO [alembic.runtime.migration] Running upgrade b5998378c225 -> f9a30386bd74, cleanup_time_granularity
INFO [alembic.runtime.migration] Running upgrade f9a30386bd74 -> 620241d1153f, update time_grain_sqla
INFO [alembic.runtime.migration] Running upgrade 620241d1153f -> 743a117f0d98, Add slack to the schedule
INFO [alembic.runtime.migration] Running upgrade 743a117f0d98 -> e557699a813e, add_tables_relation_to_row_level_security
INFO [alembic.runtime.migration] Running upgrade e557699a813e -> ea396d202291, Add ctas_method to the Query object
INFO [alembic.runtime.migration] Running upgrade ea396d202291 -> a72cb0ebeb22, deprecate dbs.perm column
INFO [alembic.runtime.migration] Running upgrade a72cb0ebeb22 -> 2f1d15e8a6af, add_alerts
INFO [alembic.runtime.migration] Running upgrade 2f1d15e8a6af -> f2672aa8350a, add_slack_to_alerts
INFO [alembic.runtime.migration] Running upgrade f2672aa8350a -> f120347acb39, Add extra column to tables and metrics
INFO [alembic.runtime.migration] Running upgrade f2672aa8350a -> 978245563a02, Migrate iframe in dashboard to markdown component
INFO [alembic.runtime.migration] Running upgrade 978245563a02, f120347acb39 -> f80a3b88324b, empty message
INFO [alembic.runtime.migration] Running upgrade f80a3b88324b -> 2e5a0ee25ed4, refractor_alerting
INFO [alembic.runtime.migration] Running upgrade f80a3b88324b -> 175ea3592453, Add cache to datasource lookup table.
INFO [alembic.runtime.migration] Running upgrade 175ea3592453, 2e5a0ee25ed4 -> ae19b4ee3692, empty message
INFO [alembic.runtime.migration] Running upgrade ae19b4ee3692 -> e5ef6828ac4e, add rls filter type and grouping key
INFO [alembic.runtime.migration] Running upgrade e5ef6828ac4e -> 3fbbc6e8d654, fix data access permissions for virtual datasets
INFO [alembic.runtime.migration] Running upgrade 3fbbc6e8d654 -> 18532d70ab98, Delete table_name unique constraint in mysql
INFO [alembic.runtime.migration] Running upgrade 18532d70ab98 -> b56500de1855, add_uuid_column_to_import_mixin
Cleaning up slice uuid from dashboard position json.. Done.
INFO [alembic.runtime.migration] Running upgrade b56500de1855 -> af30ca79208f, Collapse alerting models into a single one
INFO [alembic.runtime.migration] Running upgrade af30ca79208f -> 585b0b1a7b18, add exec info to saved queries
INFO [alembic.runtime.migration] Running upgrade 585b0b1a7b18 -> 96e99fb176a0, add_import_mixing_to_saved_query
INFO [alembic.runtime.migration] Running upgrade 96e99fb176a0 -> 49b5a32daba5, add report schedules
INFO [alembic.runtime.migration] Running upgrade 49b5a32daba5 -> a8173232b786, Add path to logs
INFO [alembic.runtime.migration] Running upgrade a8173232b786 -> e38177dbf641, security converge saved queries
INFO [alembic.runtime.migration] Running upgrade e38177dbf641 -> 8ee129739cf9, security converge css templates
INFO [alembic.runtime.migration] Running upgrade 8ee129739cf9 -> 811494c0cc23, Remove path, path_no_int, and ref from logs
INFO [alembic.runtime.migration] Running upgrade 811494c0cc23 -> 5daced1f0e76, reports add working_timeout column
INFO [alembic.runtime.migration] Running upgrade 5daced1f0e76 -> 40f16acf1ba7, security converge reports
INFO [alembic.runtime.migration] Running upgrade 40f16acf1ba7 -> ccb74baaa89b, security converge charts
INFO [alembic.runtime.migration] Running upgrade ccb74baaa89b -> c25cb2c78727, security converge annotations
INFO [alembic.runtime.migration] Running upgrade c25cb2c78727 -> 45731db65d9c, security converge datasets
INFO [alembic.runtime.migration] Running upgrade 45731db65d9c -> 4b84f97828aa, security converge logs
INFO [alembic.runtime.migration] Running upgrade 4b84f97828aa -> 1f6dca87d1a2, security converge dashboards
INFO [alembic.runtime.migration] Running upgrade 1f6dca87d1a2 -> 42b4c9e01447, security converge databases
INFO [alembic.runtime.migration] Running upgrade 42b4c9e01447 -> e37912a26567, security converge queries
INFO [alembic.runtime.migration] Running upgrade e37912a26567 -> ab104a954a8f, reports alter crontab size
INFO [alembic.runtime.migration] Running upgrade ab104a954a8f -> 73fd22e742ab, add_dynamic_plugins.py
INFO [alembic.runtime.migration] Running upgrade 73fd22e742ab -> c878781977c6, alert reports shared uniqueness
INFO [alembic.runtime.migration] Running upgrade c878781977c6 -> 260bf0649a77, migrate [x dateunit] to [x dateunit ago/later]
INFO [alembic.runtime.migration] Running upgrade 260bf0649a77 -> e11ccdd12658, add roles relationship to dashboard
INFO [alembic.runtime.migration] Running upgrade e11ccdd12658 -> 41ce8799acc3, rename pie label type
Updated 0 pie chart labels.
INFO [alembic.runtime.migration] Running upgrade 41ce8799acc3 -> 070c043f2fdb, add granularity to charts where missing
0 slices altered
INFO [alembic.runtime.migration] Running upgrade 070c043f2fdb -> c501b7c653a3, add missing uuid column
Cleaning up slice uuid from dashboard position json.. Done.
INFO [alembic.runtime.migration] Running upgrade c501b7c653a3 -> 1412ec1e5a7b, legacy force directed to echart
INFO [alembic.runtime.migration] Running upgrade 1412ec1e5a7b -> 67da9ef1ef9c, add hide_left_bar to tabstate
INFO [alembic.runtime.migration] Running upgrade 67da9ef1ef9c -> 989bbe479899, rename_filter_configuration_in_dashboard_metadata.py
Updated 0 native filter configurations.
INFO [alembic.runtime.migration] Running upgrade 989bbe479899 -> 301362411006, add_execution_id_to_report_execution_log_model.py
INFO [alembic.runtime.migration] Running upgrade 301362411006 -> 134cea61c5e7, remove dataset health check message
INFO [alembic.runtime.migration] Running upgrade 134cea61c5e7 -> 085f06488938, Country map use lowercase country name
INFO [alembic.runtime.migration] Running upgrade 085f06488938 -> fc3a3a8ff221, migrate filter sets to new format
Updated 0 filter sets with 0 filters.
INFO [alembic.runtime.migration] Running upgrade fc3a3a8ff221 -> 19e978e1b9c3, add_report_format_to_report_schedule_model.py
INFO [alembic.runtime.migration] Running upgrade 19e978e1b9c3 -> d416d0d715cc, add_limiting_factor_column_to_query_model.py
INFO [alembic.runtime.migration] Running upgrade d416d0d715cc -> f1410ed7ec95, migrate native filters to new schema
Upgraded 0 filters and 0 filter sets.
INFO [alembic.runtime.migration] Running upgrade f1410ed7ec95 -> 453530256cea, add_save_form_column_to_db_model
INFO [alembic.runtime.migration] Running upgrade 453530256cea -> 3317e9248280, add_creation_method_to_reports_model
INFO [alembic.runtime.migration] Running upgrade 3317e9248280 -> 030c840e3a1c, Add query context to slices
INFO [alembic.runtime.migration] Running upgrade 030c840e3a1c -> ae1ed299413b, add_timezone_to_report_schedule
INFO [alembic.runtime.migration] Running upgrade ae1ed299413b -> 31b2a1039d4a, drop tables constraint
INFO [alembic.runtime.migration] Running upgrade 31b2a1039d4a -> e323605f370a, fix schemas_allowed_for_csv_upload
INFO [alembic.runtime.migration] Running upgrade e323605f370a -> 143b6f2815da, migrate pivot table v2 heatmaps to new format
Upgraded 0 slices.
INFO [alembic.runtime.migration] Running upgrade 143b6f2815da -> f6196627326f, update chart permissions
INFO [alembic.runtime.migration] Running upgrade f6196627326f -> 6d20ba9ecb33, add_last_saved_at_to_slice_model
INFO [alembic.runtime.migration] Running upgrade 6d20ba9ecb33 -> 07071313dd52, change_fetch_values_predicate_to_text
INFO [alembic.runtime.migration] Running upgrade 07071313dd52 -> 021b81fe4fbb, Add type to native filter configuration
INFO [alembic] [AddTypeToNativeFilter] Starting upgrade
INFO [alembic] [AddTypeToNativeFilter] Done!
INFO [alembic.runtime.migration] Running upgrade 021b81fe4fbb -> 181091c0ef16, add_extra_column_to_columns_model
INFO [alembic.runtime.migration] Running upgrade 181091c0ef16 -> 3ebe0993c770, add filter set model
INFO [alembic.runtime.migration] Running upgrade 3ebe0993c770 -> 60dc453f4e2e, migrate timeseries_limit_metric to legacy_order_by in pivot_table_v2
INFO [alembic.runtime.migration] Running upgrade 60dc453f4e2e -> 32646df09c64, update time grain SQLA
INFO [alembic.runtime.migration] Running upgrade 32646df09c64 -> f9847149153d, add_certifications_columns_to_slice
INFO [alembic.runtime.migration] Running upgrade f9847149153d -> aea15018d53b, add_certifications_columns_to_dashboard
INFO [alembic.runtime.migration] Running upgrade aea15018d53b -> b92d69a6643c, rename_csv_to_file
INFO [alembic.runtime.migration] Running upgrade b92d69a6643c -> 0ca9e5f1dacd, rename to schemas_allowed_for_file_upload in dbs.extra
INFO [alembic.runtime.migration] Running upgrade 0ca9e5f1dacd -> abe27eaf93db, add_extra_config_column_to_alerts
INFO [alembic.runtime.migration] Running upgrade abe27eaf93db -> 3ba29ecbaac5, Change datatype of type in BaseColumn
INFO [alembic.runtime.migration] Running upgrade 3ba29ecbaac5 -> fe23025b9441, rename_big_viz_total_form_data_fields
INFO [alembic.runtime.migration] Running upgrade fe23025b9441 -> 31bb738bd1d2, move_pivot_table_v2_legacy_order_by_to_timeseries_limit_metric
INFO [alembic.runtime.migration] Running upgrade 31bb738bd1d2 -> bb38f40aa3ff, Add force_screenshot to alerts/reports
INFO [alembic.runtime.migration] Running upgrade bb38f40aa3ff -> c53bae8f08dd, add_saved_query_foreign_key_to_tab_state
INFO [alembic.runtime.migration] Running upgrade c53bae8f08dd -> 5fd49410a97a, Add columns for external management
INFO [alembic.runtime.migration] Running upgrade 5fd49410a97a -> 5afbb1a5849b, add_embedded_dashboard_table
INFO [alembic.runtime.migration] Running upgrade 5afbb1a5849b -> b8d3a24d9131, New dataset models
INFO [alembic.runtime.migration] Running upgrade b8d3a24d9131 -> b5a422d8e252, fix query and saved_query null schema
INFO [alembic.runtime.migration] Running upgrade b5a422d8e252 -> ab9a9d86e695, deprecate time_range_endpoints
INFO [alembic.runtime.migration] Running upgrade ab9a9d86e695 -> 7293b0ca7944, change_adhoc_filter_b_from_none_to_empty_array
INFO [alembic.runtime.migration] Running upgrade 7293b0ca7944 -> 6766938c6065, add key-value store
INFO [alembic.runtime.migration] Running upgrade 6766938c6065 -> 58df9d617f14, add_on_saved_query_delete_tab_state_null_constraint"
INFO [alembic.runtime.migration] Running upgrade 58df9d617f14 -> 2ed890b36b94, rm_time_range_endpoints_from_qc
INFO [alembic.runtime.migration] Running upgrade 2ed890b36b94 -> b0d0249074e4, deprecate time_range_endpoints v2
INFO [alembic.runtime.migration] Running upgrade 2ed890b36b94 -> 8b841273bec3, sql_lab_models_database_constraint_updates
INFO [alembic.runtime.migration] Running upgrade 8b841273bec3, b0d0249074e4 -> 9d8a8d575284, merge point
INFO [alembic.runtime.migration] Running upgrade 9d8a8d575284 -> cecc6bf46990, rm_time_range_endpoints_2
INFO [alembic.runtime.migration] Running upgrade cecc6bf46990 -> ad07e4fdbaba, rm_time_range_endpoints_from_qc_3
slices updated with no time_range_endpoints: 0
INFO [alembic.runtime.migration] Running upgrade ad07e4fdbaba -> a9422eeaae74, new_dataset_models_take_2
>> Assign new UUIDs to tables...
>> Drop intermediate columns...
INFO [alembic.runtime.migration] Running upgrade a9422eeaae74 -> cbe71abde154, fix report schedule and execution log
INFO [alembic.runtime.migration] Running upgrade cbe71abde154 -> 6f139c533bea, adding advanced data type to column models
INFO [alembic.runtime.migration] Running upgrade 6f139c533bea -> e786798587de, Delete None permissions
INFO [alembic.runtime.migration] Running upgrade e786798587de -> e09b4ae78457, Resize key_value blob
INFO [alembic.runtime.migration] Running upgrade e09b4ae78457 -> f3afaf1f11f0, add_unique_name_desc_rls
INFO [alembic.runtime.migration] Running upgrade f3afaf1f11f0 -> 7fb8bca906d2, permalink_rename_filterState
INFO [alembic.runtime.migration] Running upgrade 7fb8bca906d2 -> cdcf3d64daf4, Add user_id and dttm composite index to Log model
INFO [alembic.runtime.migration] Running upgrade cdcf3d64daf4 -> c747c78868b6, Migrating legacy TreeMap
INFO [alembic.runtime.migration] Running upgrade c747c78868b6 -> 06e1e70058c7, Migrating legacy Area
INFO [alembic.runtime.migration] Running upgrade 06e1e70058c7 -> a39867932713, query_context_to_mediumtext
INFO [alembic.runtime.migration] Running upgrade a39867932713 -> 409c7b420ab0, add created_by_fk as owner
INFO [alembic.runtime.migration] Running upgrade 409c7b420ab0 -> ffa79af61a56, rename report_schedule.extra to extra_json
INFO [alembic.runtime.migration] Running upgrade ffa79af61a56 -> 6d3c6f9d665d, fix_table_chart_conditional_formatting_colors
INFO [alembic.runtime.migration] Running upgrade 6d3c6f9d665d -> 291f024254b5, drop_column_allow_multi_schema_metadata_fetch
INFO [alembic.runtime.migration] Running upgrade 291f024254b5 -> deb4c9d4a4ef, parameters in saved queries
INFO [alembic.runtime.migration] Running upgrade deb4c9d4a4ef -> 4ce1d9b25135, remove_filter_bar_orientation
INFO [alembic.runtime.migration] Running upgrade 4ce1d9b25135 -> f3c2d8ec8595, create_ssh_tunnel_credentials_tbl
INFO [alembic.runtime.migration] Running upgrade f3c2d8ec8595 -> 9c2a5681ddfd, convert key-value entries to json
- 初始化
superset fab create-admin
superset init
查看详情
(superset) [root@slave1 lib]# superset fab create-admin
Loaded your LOCAL configuration at [/opt/onlineedu/miniconda3/envs/superset/lib/superset_config.py]
logging was configured successfully
2024-01-13 20:03:57,064:INFO:superset.utils.logging_configurator:logging was configured successfully
2024-01-13 20:03:57,070:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
2024-01-13 20:03:57,070:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_limiter/extension.py:336: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
warnings.warn(
No PIL installation found
2024-01-13 20:03:57,183:INFO:superset.utils.screenshots:No PIL installation found
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_appbuilder/models/sqla/interface.py:64: SAWarning: relationship 'SqlaTable.slices' will copy column tables.id to column slices.datasource_id, which conflicts with relationship(s): 'Slice.table' (copies tables.id to slices.datasource_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="table"' to the 'SqlaTable.slices' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
for prop in class_mapper(obj).iterate_properties:
Username [admin]: admin
User first name [admin]: admin
User last name [user]: user
Email [admin@fab.org]: # enter
Password: # 123456
Repeat for confirmation: # 123456
Recognized Database Authentications.
Admin User admin created.
# 初始化superset
(superset) [root@slave1 lib]# superset init
Loaded your LOCAL configuration at [/opt/onlineedu/miniconda3/envs/superset/lib/superset_config.py]
logging was configured successfully
2024-01-13 20:06:55,023:INFO:superset.utils.logging_configurator:logging was configured successfully
2024-01-13 20:06:55,029:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'>
We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
2024-01-13 20:06:55,030:WARNING:superset.initialization:We haven't found any Content Security Policy (CSP) defined in the configurations. Please make sure to configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other external software. Failing to configure CSP have serious security implications. Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more information. You can disable this warning using the CONTENT_SECURITY_POLICY_WARNING key.
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_limiter/extension.py:336: UserWarning: Using the in-memory storage for tracking rate limits as no storage was explicitly specified. This is not recommended for production use. See: https://flask-limiter.readthedocs.io#configuring-a-storage-backend for documentation about configuring the storage backend.
warnings.warn(
No PIL installation found
2024-01-13 20:06:55,193:INFO:superset.utils.screenshots:No PIL installation found
/opt/onlineedu/miniconda3/envs/superset/lib/python3.8/site-packages/flask_appbuilder/models/sqla/interface.py:64: SAWarning: relationship 'SqlaTable.slices' will copy column tables.id to column slices.datasource_id, which conflicts with relationship(s): 'Slice.table' (copies tables.id to slices.datasource_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="table"' to the 'SqlaTable.slices' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
for prop in class_mapper(obj).iterate_properties:
Syncing role definition
2024-01-13 20:06:59,498:INFO:superset.security.manager:Syncing role definition
Syncing Admin perms
2024-01-13 20:06:59,550:INFO:superset.security.manager:Syncing Admin perms
Syncing Alpha perms
2024-01-13 20:06:59,680:INFO:superset.security.manager:Syncing Alpha perms
Syncing Gamma perms
2024-01-13 20:07:00,074:INFO:superset.security.manager:Syncing Gamma perms
Syncing granter perms
2024-01-13 20:07:00,455:INFO:superset.security.manager:Syncing granter perms
Syncing sql_lab perms
2024-01-13 20:07:00,785:INFO:superset.security.manager:Syncing sql_lab perms
Fetching a set of all perms to lookup which ones are missing
2024-01-13 20:07:01,169:INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing
Creating missing datasource permissions.
2024-01-13 20:07:01,290:INFO:superset.security.manager:Creating missing datasource permissions.
Creating missing database permissions.
2024-01-13 20:07:01,294:INFO:superset.security.manager:Creating missing database permissions.
Cleaning faulty perms
2024-01-13 20:07:01,299:INFO:superset.security.manager:Cleaning faulty perms
- 启动
# 安装gunicorn
(superset) [root@slave1 ~]# pip install gunicorn -i https://pypi.douban.com/simple/
# 启动
(superset) [root@slave1 ~]# gunicorn --workers 5 --timeout 120 --bind slave1:8787 "superset.app:create_app()" --daemon
# 停止
(superset) [root@slave1 ~]# ps -ef | awk '/superset/ && !/awk/{print $2}' | xargs kill -9
-
浏览器访问，用户名admin密码123456
-
启停脚本
(superset) [root@slave1 ~]# cd /opt/software/bin
(superset) [root@slave1 bin]# vim superset.sh
- superset.sh
#!/bin/bash
superset_status(){
result=`ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | wc -l`
if [[ $result -eq 0 ]]; then
return 0
else
return 1
fi
}
superset_start(){
source ~/.bashrc
superset_status >/dev/null 2>&1
if [[ $? -eq 0 ]]; then
conda activate superset ; gunicorn --workers 5 --timeout 120 --bind niit-master:8787 --daemon 'superset.app:create_app()'
else
echo "superset正在运行"
fi
}
superset_stop(){
superset_status >/dev/null 2>&1
if [[ $? -eq 0 ]]; then
echo "superset未在运行"
else
ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | xargs kill -9
fi
}
case $1 in
start )
echo "启动Superset"
superset_start
;;
stop )
echo "停止Superset"
superset_stop
;;
restart )
echo "重启Superset"
superset_stop
superset_start
;;
status )
superset_status >/dev/null 2>&1
if [[ $? -eq 0 ]]; then
echo "superset未在运行"
else
echo "superset正在运行"
fi
esac
- 使用
# 修改权限
(superset) [root@slave1 bin]# chmod +x superset.sh
# 启动
(superset) [root@slave1 bin]# sh superset.sh start
启动Superset
superset正在运行
# 查看状态
(superset) [root@slave1 bin]# sh superset.sh status
superset正在运行
# 停止
(superset) [root@slave1 bin]# sh superset.sh stop
停止Superset
# 查看状态
(superset) [root@slave1 bin]# sh superset.sh status
superset未在运行
