Tableau is great but customers have different use cases and some of them like to take risk and tried different open source reporting tools. From my customers i heard about Metabase and Apache Superset, i’m curious so i decided to try both of them, and with most open source projects, it is not as simple as it seems to be, which is not surprising at all.
Superset is now one of the project incubating under Apache foundation. This represent how important this project can be, now and in the future.
This post is about installing Apache Superset in Centos 7.x and the solution for some errors that will show up when you just follow the official installation guide, eg. wrong library dependency.
I’m using Centos 7.3.x and Superset needs Python 3.6.x or newer. Debian, Ubuntu, and Mac OSX are also supported OS. Windows isn’t officially supported but still possible to install by using get-pip.py
Install Python 3.6.x in Centos 7.x
[iniciam@centos7 ~]$ python --version Python 2.7.5 [iniciam@centos7 ~]$ python3 --version bash: python3: command not found… Similar command is: 'python' [iniciam@centos7 ~]$ sudo yum install -y https://centos7.iuscommunity.org/ius-release.rpm Loaded plugins: fastestmirror, langpacks ius-release.rpm | 8.2 kB 00:00:00 Examining /var/tmp/yum-root-ky_IXj/ius-release.rpm: ius-release-2-1.el7.ius.noarch Marking /var/tmp/yum-root-ky_IXj/ius-release.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package ius-release.noarch 0:2-1.el7.ius will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================== Package Arch Version Repository Size Installing: ius-release noarch 2-1.el7.ius /ius-release 4.5 k Transaction Summary Install 1 Package Total size: 4.5 k Installed size: 4.5 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : ius-release-2-1.el7.ius.noarch 1/1 Verifying : ius-release-2-1.el7.ius.noarch 1/1 Installed: ius-release.noarch 0:2-1.el7.ius Complete! [iniciam@centos7 ~]$ sudo yum update Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile base: mirror.vodien.com epel: my.fedora.ipserverone.com extras: mirror.vodien.com updates: mirror.vodien.com ius | 1.3 kB 00:00:00 ius/x86_64/primary | 140 kB 00:00:00 ius 671/671 No packages marked for update [iniciam@centos7 ~]$ sudo yum install -y python36u python36u-libs python36u-devel python36u-pip Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile base: mirror.vodien.com epel: mirrors.aliyun.com extras: mirror.vodien.com updates: mirror.vodien.com Resolving Dependencies --> Running transaction check ---> Package python36u.x86_64 0:3.6.8-1.el7.ius will be installed ---> Package python36u-devel.x86_64 0:3.6.8-1.el7.ius will be installed ---> Package python36u-libs.x86_64 0:3.6.8-1.el7.ius will be installed ---> Package python36u-pip.noarch 0:9.0.1-1.ius.el7 will be installed --> Processing Dependency: python36u-setuptools for package: python36u-pip-9.0.1-1.ius.el7.noarch --> Running transaction check ---> Package python36u-setuptools.noarch 0:39.0.1-1.ius.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================== Package Arch Version Repository Size Installing: python36u x86_64 3.6.8-1.el7.ius ius 58 k python36u-devel x86_64 3.6.8-1.el7.ius ius 841 k python36u-libs x86_64 3.6.8-1.el7.ius ius 8.9 M python36u-pip noarch 9.0.1-1.ius.el7 ius 1.8 M Installing for dependencies: python36u-setuptools noarch 39.0.1-1.ius.el7 ius 643 k Transaction Summary Install 4 Packages (+1 Dependent package) Total download size: 12 M Installed size: 55 M Downloading packages: warning: /var/cache/yum/x86_64/7/ius/packages/python36u-3.6.8-1.el7.ius.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 4b274df2: NOKEY Public key for python36u-3.6.8-1.el7.ius.x86_64.rpm is not installed (1/5): python36u-3.6.8-1.el7.ius.x86_64.rpm | 58 kB 00:00:00 (2/5): python36u-devel-3.6.8-1.el7.ius.x86_64.rpm | 841 kB 00:00:00 (3/5): python36u-pip-9.0.1-1.ius.el7.noarch.rpm | 1.8 MB 00:00:00 (4/5): python36u-setuptools-39.0.1-1.ius.el7.noarch.rpm | 643 kB 00:00:00 (5/5): python36u-libs-3.6.8-1.el7.ius.x86_64.rpm | 8.9 MB 00:00:01 Total 8.8 MB/s | 12 MB 00:00:01 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-IUS-7 Importing GPG key 0x4B274DF2: Userid : "IUS (7) dev@ius.io" Fingerprint: c958 7a09 a11f d706 4f0c a0f4 e558 0725 4b27 4df2 Package : ius-release-2-1.el7.ius.noarch (installed) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-IUS-7 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : python36u-libs-3.6.8-1.el7.ius.x86_64 1/5 Installing : python36u-3.6.8-1.el7.ius.x86_64 2/5 Installing : python36u-setuptools-39.0.1-1.ius.el7.noarch 3/5 Installing : python36u-pip-9.0.1-1.ius.el7.noarch 4/5 Installing : python36u-devel-3.6.8-1.el7.ius.x86_64 5/5 Verifying : python36u-3.6.8-1.el7.ius.x86_64 1/5 Verifying : python36u-devel-3.6.8-1.el7.ius.x86_64 2/5 Verifying : python36u-libs-3.6.8-1.el7.ius.x86_64 3/5 Verifying : python36u-setuptools-39.0.1-1.ius.el7.noarch 4/5 Verifying : python36u-pip-9.0.1-1.ius.el7.noarch 5/5 Installed: python36u.x86_64 0:3.6.8-1.el7.ius python36u-devel.x86_64 0:3.6.8-1.el7.ius python36u-libs.x86_64 0:3.6.8-1.el7.ius python36u-pip.noarch 0:9.0.1-1.ius.el7 Dependency Installed: python36u-setuptools.noarch 0:39.0.1-1.ius.el7 Complete! [iniciam@centos7 ~]$ python3.6 -V Python 3.6.8
use alternatives to make python 3.6 as default python
[iniciam@centos7 ~]$ python3.6 -V Python 3.6.8 [iniciam@centos7 ~]$ sudo alternatives --install /usr/bin/python python /usr/bin/python2 50 [sudo] password for iniciam: [iniciam@centos7 ~]$ sudo alternatives --install /usr/bin/python python /usr/bin/python3.6 60 [iniciam@centos7 ~]$ sudo alternatives --config python There are 2 programs which provide 'python'. Selection Command 1 /usr/bin/python2 *+ 2 /usr/bin/python3.6 Enter to keep the current selection[+], or type selection number: [iniciam@centos7 ~]$ python -V Python 3.6.8
Install python virtual environment using pip
[iniciam@centos7 ~]$ sudo python -m pip install virtualenv Collecting virtualenv Using cached https://files.pythonhosted.org/packages/db/9e/df208b2baad146fe3fbe750eacadd6e49bcf2f2c3c1117b7192a7b28aec4/virtualenv-16.7.2-py2.py3-none-any.whl Installing collected packages: virtualenv Successfully installed virtualenv-16.7.2 You are using pip version 9.0.1, however version 19.2.1 is available. You should consider upgrading via the 'pip install --upgrade pip' command. [iniciam@centos7 ~]$ sudo python3.6 -m pip -V pip 9.0.1 from /usr/lib/python3.6/site-packages (python 3.6)
Create virtual environment & activate it
[iniciam@centos7 ~]$ python -V Python 3.6.8 [iniciam@centos7 ~]$ python -m venv venv [iniciam@centos7 ~]$ . venv/bin/activate (venv) [iniciam@centos7 ~]$ python -V Python 3.6.8
install tools inside the virtual environment
(venv) [iniciam@centos7 ~]$ sudo pip3.6 install --upgrade setuptools pip
Cache entry deserialization failed, entry ignored
Collecting setuptools
Using cached https://files.pythonhosted.org/packages/ec/51/f45cea425fd5cb0b0380f5b0f048ebc1da5b417e48d304838c02d6288a1e/setuptools-41.0.1-py2.py3-none-any.whl
Cache entry deserialization failed, entry ignored
Collecting pip
Using cached https://files.pythonhosted.org/packages/62/ca/94d32a6516ed197a491d17d46595ce58a83cbb2fca280414e57cd86b84dc/pip-19.2.1-py2.py3-none-any.whl
Installing collected packages: setuptools, pip
Found existing installation: setuptools 39.0.1
Uninstalling setuptools-39.0.1:
Successfully uninstalled setuptools-39.0.1
Found existing installation: pip 9.0.1
Uninstalling pip-9.0.1:
Successfully uninstalled pip-9.0.1
Successfully installed pip-19.2.1 setuptools-41.0.1
install apache superset inside venv using pip3.6
(venv) [iniciam@centos7 ~]$ sudo pip3.6 install superset
Collecting superset
Using cached https://files.pythonhosted.org/packages/da/48/583551048b9e045eed47dbd93c3210fa1e02193e4fad226033a19754525c/superset-0.28.1.tar.gz
Collecting bleach (from superset)
Downloading https://files.pythonhosted.org/packages/ab/05/27e1466475e816d3001efb6e0a85a819be17411420494a1e602c36f8299d/bleach-3.1.0-py2.py3-none-any.whl (157kB)
|████████████████████████████████| 163kB 761kB/s
Collecting boto3==1.4.7 (from superset)
Downloading https://files.pythonhosted.org/packages/e0/7c/ed4ddcaa65dadba5992fba71b0cd221181f189dd87ac975d25d33c190a61/boto3-1.4.7-py2.py3-none-any.whl (128kB)
|████████████████████████████████| 133kB 48.3MB/s
Collecting botocore<1.8.0,>=1.7.0 (from superset)
Downloading https://files.pythonhosted.org/packages/78/07/88ef02fca320ff8f61a5c8f46739f72e715f8745c9ddbf59fc5dba43db1a/botocore-1.7.48-py2.py3-none-any.whl (3.7MB)
|████████████████████████████████| 3.7MB 1.3MB/s
Collecting celery>=4.2.0 (from superset)
Downloading https://files.pythonhosted.org/packages/5c/a1/a3dd9d8bfa09156ec2cba37f90accf35c0f4ecc3980d96cb4fb99e56504b/celery-4.3.0-py2.py3-none-any.whl (413kB)
|████████████████████████████████| 419kB 2.4MB/s
Collecting click==6.7 (from superset)
Downloading https://files.pythonhosted.org/packages/34/c1/8806f99713ddb993c5366c362b2f908f18269f8d792aff1abfd700775a77/click-6.7-py2.py3-none-any.whl (71kB)
|████████████████████████████████| 71kB 26.9MB/s
Collecting colorama==0.3.9 (from superset)
Downloading https://files.pythonhosted.org/packages/db/c8/7dcf9dbcb22429512708fe3a547f8b6101c0d02137acbd892505aee57adf/colorama-0.3.9-py2.py3-none-any.whl
Collecting contextlib2 (from superset)
Downloading https://files.pythonhosted.org/packages/a2/71/8273a7eeed0aff6a854237ab5453bc9aa67deb49df4832801c21f0ff3782/contextlib2-0.5.5-py2.py3-none-any.whl
Collecting cryptography (from superset)
Downloading https://files.pythonhosted.org/packages/97/18/c6557f63a6abde34707196fb2cad1c6dc0dbff25a200d5044922496668a4/cryptography-2.7-cp34-abi3-manylinux1_x86_64.whl (2.3MB)
|████████████████████████████████| 2.3MB 2.2MB/s
Collecting flask<1.0.0 (from superset) Downloading https://files.pythonhosted.org/packages/2e/48/f1936dadac2326b3d73f2fe0a964a87d16be16eb9d7fc56f09c1bea3d17c/Flask-0.12.4-py2.py3-none-any.whl (81kB) |████████████████████████████████| 81kB 31.8MB/s Collecting flask-appbuilder>=1.12.1 (from superset)
Downloading https://files.pythonhosted.org/packages/f8/ae/031eccd71b9f4acc075b8968a0c421ac0b977c08d291971760c7fcdc3627/Flask-AppBuilder-2.1.7.tar.gz (1.6MB)
|████████████████████████████████| 1.6MB 2.4MB/s
Collecting flask-caching (from superset)
Downloading https://files.pythonhosted.org/packages/bd/4e/c701bdcd566f26187398cf058ad2ca14c8b2f50b17a17f9076794ae2f8db/Flask_Caching-1.7.2-py2.py3-none-any.whl
Collecting flask-compress (from superset)
Downloading https://files.pythonhosted.org/packages/0e/2a/378bd072928f6d92fd8c417d66b00c757dc361c0405a46a0134de6fd323d/Flask-Compress-1.4.0.tar.gz
Collecting flask-migrate (from superset)
Downloading https://files.pythonhosted.org/packages/4b/22/d20a105f13c58fe590ef38ac59d5cabc1a917549ea8f90b0ca7b4e84f6be/Flask_Migrate-2.5.2-py2.py3-none-any.whl
Collecting flask-wtf (from superset)
Downloading https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting flower (from superset)
Downloading https://files.pythonhosted.org/packages/36/15/ed670b1f1fe14727f1564c9d98d7a917352ce8a0d88e87256be3c1e1190e/flower-0.9.3.tar.gz (1.3MB)
|████████████████████████████████| 1.3MB 2.0MB/s
Collecting future<0.17,>=0.16.0 (from superset)
Downloading https://files.pythonhosted.org/packages/00/2b/8d082ddfed935f3608cc61140df6dcbf0edea1bc3ab52fb6c29ae3e81e85/future-0.16.0.tar.gz (824kB)
|████████████████████████████████| 829kB 1.9MB/s
Collecting geopy (from superset)
Downloading https://files.pythonhosted.org/packages/80/93/d384479da0ead712bdaf697a8399c13a9a89bd856ada5a27d462fb45e47b/geopy-1.20.0-py2.py3-none-any.whl (100kB)
|████████████████████████████████| 102kB 1.9MB/s
Collecting gunicorn (from superset)
Downloading https://files.pythonhosted.org/packages/8c/da/b8dd8deb741bff556db53902d4706774c8e1e67265f69528c14c003644e6/gunicorn-19.9.0-py2.py3-none-any.whl (112kB)
|████████████████████████████████| 122kB 1.8MB/s
Collecting humanize (from superset)
Downloading https://files.pythonhosted.org/packages/8c/e0/e512e4ac6d091fc990bbe13f9e0378f34cf6eecd1c6c268c9e598dcf5bb9/humanize-0.5.1.tar.gz
Collecting idna (from superset)
Downloading https://files.pythonhosted.org/packages/14/2c/cd551d81dbe15200be1cf41cd03869a46fe7226e7450af7a6545bfc474c9/idna-2.8-py2.py3-none-any.whl (58kB)
|████████████████████████████████| 61kB 27.8MB/s
Collecting isodate (from superset)
Downloading https://files.pythonhosted.org/packages/9b/9f/b36f7774ff5ea8e428fdcfc4bb332c39ee5b9362ddd3d40d9516a55221b2/isodate-0.6.0-py2.py3-none-any.whl (45kB)
|████████████████████████████████| 51kB 27.2MB/s
Collecting markdown>=3.0 (from superset)
Downloading https://files.pythonhosted.org/packages/c0/4e/fd492e91abdc2d2fcb70ef453064d980688762079397f779758e055f6575/Markdown-3.1.1-py2.py3-none-any.whl (87kB)
|████████████████████████████████| 92kB 2.2MB/s
Collecting pandas>=0.18.0 (from superset)
Downloading https://files.pythonhosted.org/packages/1d/9a/7eb9952f4b4d73fbd75ad1d5d6112f407e695957444cb695cbb3cdab918a/pandas-0.25.0-cp36-cp36m-manylinux1_x86_64.whl (10.5MB)
|████████████████████████████████| 10.5MB 2.2MB/s
Collecting parsedatetime (from superset)
Downloading https://files.pythonhosted.org/packages/e3/b3/02385db13f1f25f04ad7895f35e9fe3960a4b9d53112775a6f7d63f264b6/parsedatetime-2.4.tar.gz (58kB)
|████████████████████████████████| 61kB 28.4MB/s
Collecting pathlib2 (from superset)
Downloading https://files.pythonhosted.org/packages/67/c6/4dbf5dfdbe1140cadf765c3896acc098578626c35721bc7d3eb35f6a8fc1/pathlib2-2.3.4-py2.py3-none-any.whl
Collecting polyline (from superset)
Downloading https://files.pythonhosted.org/packages/0c/4a/67edcfd960ff64221782531c867d862acc6a4e85b382a291bcb820dcde72/polyline-1.4.0-py2.py3-none-any.whl
Collecting pydruid>=0.4.3 (from superset)
Downloading https://files.pythonhosted.org/packages/aa/c6/63dcf39f8c030d954b54d6277f9f45d8e5cb2f80e0c3c2bf1634963b35f1/pydruid-0.5.6.tar.gz (4.5MB)
|████████████████████████████████| 4.5MB 1.2MB/s
Collecting pyhive>=0.4.0 (from superset)
Downloading https://files.pythonhosted.org/packages/4e/26/de91125c0d9e8947d48f387f4d1f2e7a22aa92a30771ad02f63a5653361b/PyHive-0.6.1.tar.gz (41kB)
|████████████████████████████████| 51kB 15.0MB/s
Collecting python-dateutil (from superset)
Downloading https://files.pythonhosted.org/packages/41/17/c62faccbfbd163c7f57f3844689e3a78bae1f403648a6afb1d0866d87fbb/python_dateutil-2.8.0-py2.py3-none-any.whl (226kB)
|████████████████████████████████| 235kB 2.4MB/s
Collecting python-geohash (from superset)
Downloading https://files.pythonhosted.org/packages/9c/e2/1a3507af7c8f91f8a4975d651d4aeb6a846dfdf74713954186ade4205850/python-geohash-0.8.5.tar.gz
Collecting pyyaml>=3.11 (from superset)
Downloading https://files.pythonhosted.org/packages/a3/65/837fefac7475963d1eccf4aa684c23b95aa6c1d033a2c5965ccb11e22623/PyYAML-5.1.1.tar.gz (274kB)
|████████████████████████████████| 276kB 2.6MB/s
Collecting requests (from superset)
Downloading https://files.pythonhosted.org/packages/51/bd/23c926cd341ea6b7dd0b2a00aba99ae0f828be89d72b2190f27c11d4b7fb/requests-2.22.0-py2.py3-none-any.whl (57kB)
|████████████████████████████████| 61kB 19.2MB/s
Collecting simplejson>=3.15.0 (from superset)
Downloading https://files.pythonhosted.org/packages/e3/24/c35fb1c1c315fc0fffe61ea00d3f88e85469004713dab488dee4f35b0aff/simplejson-3.16.0.tar.gz (81kB)
|████████████████████████████████| 81kB 2.0MB/s
Collecting sqlalchemy (from superset)
Downloading https://files.pythonhosted.org/packages/55/98/56b7155bab287cd0c78dee26258835db36e91f2efef41f125ed6f6f1f334/SQLAlchemy-1.3.6.tar.gz (5.9MB)
|████████████████████████████████| 5.9MB 1.4MB/s
Collecting sqlalchemy-utils (from superset)
Downloading https://files.pythonhosted.org/packages/de/6f/ace335ff63f9c07acc31e02c6a9859f2bf3b56a3902679c62034ec10db50/SQLAlchemy-Utils-0.34.1.tar.gz (128kB)
|████████████████████████████████| 133kB 1.8MB/s
Collecting sqlparse (from superset)
Downloading https://files.pythonhosted.org/packages/ef/53/900f7d2a54557c6a37886585a91336520e5539e3ae2423ff1102daf4f3a7/sqlparse-0.3.0-py2.py3-none-any.whl
Collecting tableschema (from superset)
Downloading https://files.pythonhosted.org/packages/71/8e/0788131b048fbb8b19dc94e60d40797f397c1feae905d3e27e3171a0520e/tableschema-1.6.0-py2.py3-none-any.whl (56kB)
|████████████████████████████████| 61kB 19.9MB/s
Collecting thrift>=0.9.3 (from superset)
Downloading https://files.pythonhosted.org/packages/c6/b4/510617906f8e0c5660e7d96fbc5585113f83ad547a3989b80297ac72a74c/thrift-0.11.0.tar.gz (52kB)
|████████████████████████████████| 61kB 21.9MB/s
Collecting thrift-sasl>=0.2.1 (from superset)
Downloading https://files.pythonhosted.org/packages/50/fe/89cbc910809e3757c762f56ee190ca39e0f28b7ea451835232c0c988d706/thrift_sasl-0.3.0.tar.gz
Collecting unicodecsv (from superset)
Downloading https://files.pythonhosted.org/packages/6f/a4/691ab63b17505a26096608cc309960b5a6bdf39e4ba1a793d5f9b1a53270/unicodecsv-0.14.1.tar.gz
Collecting unidecode>=0.04.21 (from superset)
Downloading https://files.pythonhosted.org/packages/d0/42/d9edfed04228bacea2d824904cae367ee9efd05e6cce7ceaaedd0b0ad964/Unidecode-1.1.1-py2.py3-none-any.whl (238kB)
|████████████████████████████████| 245kB 2.3MB/s
Collecting webencodings (from bleach->superset)
Downloading https://files.pythonhosted.org/packages/f4/24/2a3e3df732393fed8b3ebf2ec078f05546de641fe1b667ee316ec1dcf3b7/webencodings-0.5.1-py2.py3-none-any.whl
Collecting six>=1.9.0 (from bleach->superset)
Downloading https://files.pythonhosted.org/packages/73/fb/00a976f728d0d1fecfe898238ce23f502a721c0ac0ecfedb80e0d88c64e9/six-1.12.0-py2.py3-none-any.whl
Collecting jmespath<1.0.0,>=0.7.1 (from boto3==1.4.7->superset)
Downloading https://files.pythonhosted.org/packages/83/94/7179c3832a6d45b266ddb2aac329e101367fbdb11f425f13771d27f225bb/jmespath-0.9.4-py2.py3-none-any.whl
Collecting s3transfer<0.2.0,>=0.1.10 (from boto3==1.4.7->superset)
Downloading https://files.pythonhosted.org/packages/d7/14/2a0004d487464d120c9fb85313a75cd3d71a7506955be458eebfe19a6b1d/s3transfer-0.1.13-py2.py3-none-any.whl (59kB)
|████████████████████████████████| 61kB 17.2MB/s
Collecting docutils>=0.10 (from botocore<1.8.0,>=1.7.0->superset)
Downloading https://files.pythonhosted.org/packages/22/cd/a6aa959dca619918ccb55023b4cb151949c64d4d5d55b3f4ffd7eee0c6e8/docutils-0.15.2-py3-none-any.whl (547kB)
|████████████████████████████████| 552kB 2.5MB/s
Collecting pytz>dev (from celery>=4.2.0->superset)
Downloading https://files.pythonhosted.org/packages/3d/73/fe30c2daaaa0713420d0382b16fbb761409f532c56bdcc514bf7b6262bb6/pytz-2019.1-py2.py3-none-any.whl (510kB)
|████████████████████████████████| 512kB 2.4MB/s
Collecting kombu<5.0,>=4.4.0 (from celery>=4.2.0->superset)
Downloading https://files.pythonhosted.org/packages/8f/f6/a60d03e6179166134aab2ee15603641eeb91c6ac9344018209d3ef13fb7c/kombu-4.6.3-py2.py3-none-any.whl (181kB)
|████████████████████████████████| 184kB 2.3MB/s
Collecting vine>=1.3.0 (from celery>=4.2.0->superset)
Downloading https://files.pythonhosted.org/packages/7f/60/82c03047396126c8331ceb64da1dc52d4f1317209f32e8fe286d0c07365a/vine-1.3.0-py2.py3-none-any.whl
Collecting billiard<4.0,>=3.6.0 (from celery>=4.2.0->superset)
Downloading https://files.pythonhosted.org/packages/3c/a0/5a01bed569cf1af8fcdd4294590acb980a2788d1594f4ccd678b6fea8644/billiard-3.6.0.0.tar.gz (151kB)
|████████████████████████████████| 153kB 2.1MB/s
Collecting cffi!=1.11.3,>=1.8 (from cryptography->superset)
Downloading https://files.pythonhosted.org/packages/5f/bf/6aa1925384c23ffeb579e97a5569eb9abce41b6310b329352b8252cee1c3/cffi-1.12.3-cp36-cp36m-manylinux1_x86_64.whl (430kB)
|████████████████████████████████| 440kB 2.4MB/s
Collecting asn1crypto>=0.21.0 (from cryptography->superset)
Downloading https://files.pythonhosted.org/packages/ea/cd/35485615f45f30a510576f1a56d1e0a7ad7bd8ab5ed7cdc600ef7cd06222/asn1crypto-0.24.0-py2.py3-none-any.whl (101kB)
|████████████████████████████████| 102kB 2.5MB/s
Collecting Jinja2>=2.4 (from flask<1.0.0->superset)
Downloading https://files.pythonhosted.org/packages/1d/e7/fd8b501e7a6dfe492a433deb7b9d833d39ca74916fa8bc63dd1a4947a671/Jinja2-2.10.1-py2.py3-none-any.whl (124kB)
|████████████████████████████████| 133kB 1.9MB/s
Collecting itsdangerous>=0.21 (from flask<1.0.0->superset)
Downloading https://files.pythonhosted.org/packages/76/ae/44b03b253d6fade317f32c24d100b3b35c2239807046a4c953c7b89fa49e/itsdangerous-1.1.0-py2.py3-none-any.whl
Collecting Werkzeug>=0.7 (from flask<1.0.0->superset)
Downloading https://files.pythonhosted.org/packages/d1/ab/d3bed6b92042622d24decc7aadc8877badf18aeca1571045840ad4956d3f/Werkzeug-0.15.5-py2.py3-none-any.whl (328kB)
|████████████████████████████████| 337kB 2.2MB/s
Collecting apispec[yaml]<2,>=1.1.1 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/38/7a/20500edb2e77b8a6f6b677ed6a7b6d97b696fcc477374d36d83883462863/apispec-1.3.3-py2.py3-none-any.whl
Collecting Flask-Babel<1,>=0.11.1 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/82/b0/986b29938d4e8be7deb552ebfd1ef16c311276a59bcae10dec567a5b3d20/Flask-Babel-0.12.2.tar.gz (44kB)
|████████████████████████████████| 51kB 22.7MB/s
Collecting Flask-Login<0.5,>=0.3 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/c1/ff/bd9a4d2d81bf0c07d9e53e8cd3d675c56553719bbefd372df69bf1b3c1e4/Flask-Login-0.4.1.tar.gz
Collecting Flask-OpenID<2,>=1.2.5 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/d1/a2/9d1fba3287a65f81b9d1c09c4f7cb16f8ea4988b1bc97ffea0d60983338f/Flask-OpenID-1.2.5.tar.gz (43kB)
|████████████████████████████████| 51kB 18.8MB/s
Collecting Flask-SQLAlchemy<3,>=2.4 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/08/ca/582442cad71504a1514a2f053006c8bb128844133d6076a4df17117545fa/Flask_SQLAlchemy-2.4.0-py2.py3-none-any.whl
Collecting Flask-JWT-Extended<4,>=3.18 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/e4/ef/1b2fd06319ed5d46d35feda170126ecc622bdb136c6fa637e46fcae05d36/Flask-JWT-Extended-3.20.0.tar.gz
Collecting jsonschema<4,>=3.0.1 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/aa/69/df679dfbdd051568b53c38ec8152a3ab6bc533434fc7ed11ab034bf5e82f/jsonschema-3.0.1-py2.py3-none-any.whl (54kB)
|████████████████████████████████| 61kB 20.7MB/s
Collecting marshmallow<2.20,>=2.18.0 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/77/0b/ee5a4d0b7bc88bb3b59a25fb40e1811810c039f7faa1e87dcdcbcb1fdc33/marshmallow-2.19.5-py2.py3-none-any.whl (50kB)
|████████████████████████████████| 51kB 22.0MB/s
Collecting marshmallow-enum<2,>=1.4.1 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/8b/c7/9e12f3947830d9d3c51747b6801767a33e5945596c1bcb9def2c2d365ae8/marshmallow_enum-1.4.1-py2.py3-none-any.whl
Collecting marshmallow-sqlalchemy<1,>=0.16.1 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/63/b2/73d041a32d3e859c95d3c5ed3f5fca66b5877efaee247015679b9a146546/marshmallow_sqlalchemy-0.17.0-py2.py3-none-any.whl
Collecting prison<1.0.0,>=0.1.2 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/d4/50/7b3c8e694ebe7e1f0ee07e7603c3bcee4db90bc055e6f86c0f66f321ddbb/prison-0.1.2-py2.py3-none-any.whl
Collecting PyJWT>=1.7.1 (from flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/87/8b/6a9f14b5f781697e51259d81657e6048fd31a113229cf346880bb7545565/PyJWT-1.7.1-py2.py3-none-any.whl
Collecting alembic>=0.7 (from flask-migrate->superset)
Downloading https://files.pythonhosted.org/packages/7b/8b/0c98c378d93165d9809193f274c3c6e2151120d955b752419c7d43e4d857/alembic-1.0.11.tar.gz (1.0MB)
|████████████████████████████████| 1.0MB 1.9MB/s
Collecting WTForms (from flask-wtf->superset)
Downloading https://files.pythonhosted.org/packages/9f/c8/dac5dce9908df1d9d48ec0e26e2a250839fa36ea2c602cc4f85ccfeb5c65/WTForms-2.2.1-py2.py3-none-any.whl (166kB)
|████████████████████████████████| 174kB 2.6MB/s
Collecting tornado<6.0.0,>=4.2.0 (from flower->superset)
Downloading https://files.pythonhosted.org/packages/e6/78/6e7b5af12c12bdf38ca9bfe863fcaf53dc10430a312d0324e76c1e5ca426/tornado-5.1.1.tar.gz (516kB)
|████████████████████████████████| 522kB 2.3MB/s
Collecting babel<3.0.0,>=1.0 (from flower->superset)
Downloading https://files.pythonhosted.org/packages/2c/60/f2af68eb046c5de5b1fe6dd4743bf42c074f7141fe7b2737d3061533b093/Babel-2.7.0-py2.py3-none-any.whl (8.4MB)
|████████████████████████████████| 8.4MB 1.3MB/s
Collecting geographiclib<2,>=1.49 (from geopy->superset)
Downloading https://files.pythonhosted.org/packages/5b/ac/4f348828091490d77899bc74e92238e2b55c59392f21948f296e94e50e2b/geographiclib-1.49.tar.gz
Requirement already satisfied: setuptools>=36 in /usr/lib/python3.6/site-packages (from markdown>=3.0->superset) (41.0.1)
Collecting numpy>=1.13.3 (from pandas>=0.18.0->superset)
Downloading https://files.pythonhosted.org/packages/19/b9/bda9781f0a74b90ebd2e046fde1196182900bd4a8e1ea503d3ffebc50e7c/numpy-1.17.0-cp36-cp36m-manylinux1_x86_64.whl (20.4MB)
|████████████████████████████████| 20.4MB 2.2MB/s
Collecting urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 (from requests->superset)
Downloading https://files.pythonhosted.org/packages/e6/60/247f23a7121ae632d62811ba7f273d0e58972d75e58a94d329d51550a47d/urllib3-1.25.3-py2.py3-none-any.whl (150kB)
|████████████████████████████████| 153kB 2.6MB/s
Collecting certifi>=2017.4.17 (from requests->superset)
Downloading https://files.pythonhosted.org/packages/69/1b/b853c7a9d4f6a6d00749e94eb6f3a041e342a885b87340b79c1ef73e3a78/certifi-2019.6.16-py2.py3-none-any.whl (157kB)
|████████████████████████████████| 163kB 2.0MB/s
Collecting chardet<3.1.0,>=3.0.2 (from requests->superset)
Downloading https://files.pythonhosted.org/packages/bc/a9/01ffebfb562e4274b6487b4bb1ddec7ca55ec7510b22e4c51f14098443b8/chardet-3.0.4-py2.py3-none-any.whl (133kB)
|████████████████████████████████| 143kB 2.2MB/s
Collecting tabulator>=1.20 (from tableschema->superset)
Downloading https://files.pythonhosted.org/packages/b1/98/6e841eb1c98cb4e80bca46b2f24c85e1727757ef2adbcc08a6d45c83e3bb/tabulator-1.23.0-py2.py3-none-any.whl (52kB)
|████████████████████████████████| 61kB 17.4MB/s
Collecting rfc3986>=1.1.0 (from tableschema->superset)
Downloading https://files.pythonhosted.org/packages/00/8d/9d56bfe43997f1864fe0891be69bc239ded98e69c9f56eb9eaa5b1789660/rfc3986-1.3.2-py2.py3-none-any.whl
Collecting sasl>=0.2.1 (from thrift-sasl>=0.2.1->superset)
Downloading https://files.pythonhosted.org/packages/8e/2c/45dae93d666aea8492678499e0999269b4e55f1829b1e4de5b8204706ad9/sasl-0.2.1.tar.gz
Collecting amqp<3.0,>=2.5.0 (from kombu<5.0,>=4.4.0->celery>=4.2.0->superset)
Downloading https://files.pythonhosted.org/packages/45/91/877ea2d1c3234dbb32e818d281615232468ff8a4a783a8fc264862b9f77b/amqp-2.5.0-py2.py3-none-any.whl (49kB)
|████████████████████████████████| 51kB 16.3MB/s
Collecting pycparser (from cffi!=1.11.3,>=1.8->cryptography->superset)
Downloading https://files.pythonhosted.org/packages/68/9e/49196946aee219aead1290e00d1e7fdeab8567783e83e1b9ab5585e6206a/pycparser-2.19.tar.gz (158kB)
|████████████████████████████████| 163kB 2.4MB/s
Collecting MarkupSafe>=0.23 (from Jinja2>=2.4->flask<1.0.0->superset)
Downloading https://files.pythonhosted.org/packages/b2/5f/23e0023be6bb885d00ffbefad2942bc51a620328ee910f64abe5a8d18dd1/MarkupSafe-1.1.1-cp36-cp36m-manylinux1_x86_64.whl
Collecting python3-openid>=2.0 (from Flask-OpenID<2,>=1.2.5->flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/bd/de/52c5699f52dcee3037db587196dcaf63ffedf5fbeba3183afe9b21a3a89f/python3_openid-3.1.0-py3-none-any.whl (130kB)
|████████████████████████████████| 133kB 2.5MB/s
Collecting pyrsistent>=0.14.0 (from jsonschema<4,>=3.0.1->flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/b9/66/b2638d96a2d128b168d0dba60fdc77b7800a9b4a5340cefcc5fc4eae6295/pyrsistent-0.15.4.tar.gz (107kB)
|████████████████████████████████| 112kB 2.6MB/s
Collecting attrs>=17.4.0 (from jsonschema<4,>=3.0.1->flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/23/96/d828354fa2dbdf216eaa7b7de0db692f12c234f7ef888cc14980ef40d1d2/attrs-19.1.0-py2.py3-none-any.whl
Collecting Mako (from alembic>=0.7->flask-migrate->superset)
Downloading https://files.pythonhosted.org/packages/1b/a5/023aba3d69aacef6bfc13797bdc3dd03c6fb4ae2dcd2fde7dffc37233924/Mako-1.0.14.tar.gz (462kB)
|████████████████████████████████| 471kB 2.6MB/s
Collecting python-editor>=0.3 (from alembic>=0.7->flask-migrate->superset)
Downloading https://files.pythonhosted.org/packages/c6/d3/201fc3abe391bbae6606e6f1d598c15d367033332bd54352b12f35513717/python_editor-1.0.4-py3-none-any.whl
Collecting linear-tsv>=1.0 (from tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/82/e5/03207a0f11e1d60df85b97b61704ed701b725a7c2feaf83f7bfbd0c2d83e/linear-tsv-1.1.0.tar.gz
Collecting cchardet>=1.0 (from tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/4f/a5/d073e7a0e992275d9b87e08cc3151c0ec27c718b78e6c943d264e5bd71d3/cchardet-2.1.4-cp36-cp36m-manylinux1_x86_64.whl (204kB)
|████████████████████████████████| 204kB 1.9MB/s
Collecting openpyxl<2.5,>=2.4 (from tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/77/26/0bd1a39776f53b4f28e5bb1d26b3fcd99068584a7e1ddca4e09c0d5fd592/openpyxl-2.4.11.tar.gz (158kB)
|████████████████████████████████| 163kB 2.5MB/s
Collecting jsonlines>=1.1 (from tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/4f/9a/ab96291470e305504aa4b7a2e0ec132e930da89eb3ca7a82fbe03167c131/jsonlines-1.2.0-py2.py3-none-any.whl
Collecting xlrd>=1.0 (from tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/b0/16/63576a1a001752e34bf8ea62e367997530dc553b689356b9879339cf45a4/xlrd-1.2.0-py2.py3-none-any.whl (103kB)
|████████████████████████████████| 112kB 2.3MB/s
Collecting ijson>=2.0 (from tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/4f/dc/9fa0f204490229f9d4e40169ede79e1d6a29c432ff9061055aab3b517873/ijson-2.4-cp36-cp36m-manylinux1_x86_64.whl (59kB)
|████████████████████████████████| 61kB 25.4MB/s
Collecting defusedxml (from python3-openid>=2.0->Flask-OpenID<2,>=1.2.5->flask-appbuilder>=1.12.1->superset)
Downloading https://files.pythonhosted.org/packages/06/74/9b387472866358ebc08732de3da6dc48e44b0aacd2ddaa5cb85ab7e986a2/defusedxml-0.6.0-py2.py3-none-any.whl
Collecting jdcal (from openpyxl<2.5,>=2.4->tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/f0/da/572cbc0bc582390480bbd7c4e93d14dc46079778ed915b505dc494b37c57/jdcal-1.4.1-py2.py3-none-any.whl
Collecting et_xmlfile (from openpyxl<2.5,>=2.4->tabulator>=1.20->tableschema->superset)
Downloading https://files.pythonhosted.org/packages/22/28/a99c42aea746e18382ad9fb36f64c1c1f04216f41797f2f0fa567da11388/et_xmlfile-1.0.1.tar.gz
Installing collected packages: webencodings, six, bleach, jmespath, python-dateutil, docutils, botocore, s3transfer, boto3, pytz, vine, amqp, kombu, billiard, celery, click, colorama, contextlib2, pycparser, cffi, asn1crypto, cryptography, MarkupSafe, Jinja2, itsdangerous, Werkzeug, flask, pyyaml, apispec, babel, Flask-Babel, Flask-Login, defusedxml, python3-openid, Flask-OpenID, sqlalchemy, Flask-SQLAlchemy, WTForms, flask-wtf, PyJWT, Flask-JWT-Extended, pyrsistent, attrs, jsonschema, marshmallow, marshmallow-enum, marshmallow-sqlalchemy, prison, sqlalchemy-utils, flask-appbuilder, flask-caching, flask-compress, Mako, python-editor, alembic, flask-migrate, tornado, flower, future, geographiclib, geopy, gunicorn, humanize, idna, isodate, markdown, numpy, pandas, parsedatetime, pathlib2, polyline, urllib3, certifi, chardet, requests, pydruid, pyhive, python-geohash, simplejson, sqlparse, linear-tsv, cchardet, jdcal, et-xmlfile, openpyxl, unicodecsv, jsonlines, xlrd, ijson, tabulator, rfc3986, tableschema, thrift, sasl, thrift-sasl, unidecode, superset
Running setup.py install for billiard … done
Running setup.py install for pycparser … done
Running setup.py install for pyyaml … done
Running setup.py install for Flask-Babel … done
Running setup.py install for Flask-Login … done
Running setup.py install for Flask-OpenID … done
Running setup.py install for sqlalchemy … done
Running setup.py install for Flask-JWT-Extended … done
Running setup.py install for pyrsistent … done
Running setup.py install for sqlalchemy-utils … done
Running setup.py install for flask-appbuilder … done
Running setup.py install for flask-compress … done
Running setup.py install for Mako … done
Running setup.py install for alembic … done
Running setup.py install for tornado … done
Running setup.py install for flower … done
Running setup.py install for future … done
Running setup.py install for geographiclib … done
Running setup.py install for humanize … done
Running setup.py install for parsedatetime … done
Running setup.py install for pydruid … done
Running setup.py install for pyhive … done
Running setup.py install for python-geohash … done
Running setup.py install for simplejson … done
Running setup.py install for linear-tsv … done
Running setup.py install for et-xmlfile … done
Running setup.py install for openpyxl … done
Running setup.py install for unicodecsv … done
Running setup.py install for thrift … done
Running setup.py install for sasl … done
Running setup.py install for thrift-sasl … done
Running setup.py install for superset … done
Successfully installed Flask-Babel-0.12.2 Flask-JWT-Extended-3.20.0 Flask-Login-0.4.1 Flask-OpenID-1.2.5 Flask-SQLAlchemy-2.4.0 Jinja2-2.10.1 Mako-1.0.14 MarkupSafe-1.1.1 PyJWT-1.7.1 WTForms-2.2.1 Werkzeug-0.15.5 alembic-1.0.11 amqp-2.5.0 apispec-1.3.3 asn1crypto-0.24.0 attrs-19.1.0 babel-2.7.0 billiard-3.6.0.0 bleach-3.1.0 boto3-1.4.7 botocore-1.7.48 cchardet-2.1.4 celery-4.3.0 certifi-2019.6.16 cffi-1.12.3 chardet-3.0.4 click-6.7 colorama-0.3.9 contextlib2-0.5.5 cryptography-2.7 defusedxml-0.6.0 docutils-0.15.2 et-xmlfile-1.0.1 flask-0.12.4 flask-appbuilder-2.1.7 flask-caching-1.7.2 flask-compress-1.4.0 flask-migrate-2.5.2 flask-wtf-0.14.2 flower-0.9.3 future-0.16.0 geographiclib-1.49 geopy-1.20.0 gunicorn-19.9.0 humanize-0.5.1 idna-2.8 ijson-2.4 isodate-0.6.0 itsdangerous-1.1.0 jdcal-1.4.1 jmespath-0.9.4 jsonlines-1.2.0 jsonschema-3.0.1 kombu-4.6.3 linear-tsv-1.1.0 markdown-3.1.1 marshmallow-2.19.5 marshmallow-enum-1.4.1 marshmallow-sqlalchemy-0.17.0 numpy-1.17.0 openpyxl-2.4.11 pandas-0.25.0 parsedatetime-2.4 pathlib2-2.3.4 polyline-1.4.0 prison-0.1.2 pycparser-2.19 pydruid-0.5.6 pyhive-0.6.1 pyrsistent-0.15.4 python-dateutil-2.8.0 python-editor-1.0.4 python-geohash-0.8.5 python3-openid-3.1.0 pytz-2019.1 pyyaml-5.1.1 requests-2.22.0 rfc3986-1.3.2 s3transfer-0.1.13 sasl-0.2.1 simplejson-3.16.0 six-1.12.0 sqlalchemy-1.3.6 sqlalchemy-utils-0.34.1 sqlparse-0.3.0 superset-0.28.1 tableschema-1.6.0 tabulator-1.23.0 thrift-0.11.0 thrift-sasl-0.3.0 tornado-5.1.1 unicodecsv-0.14.1 unidecode-1.1.1 urllib3-1.25.3 vine-1.3.0 webencodings-0.5.1 xlrd-1.2.0
Run superset db upgrade (which will throw an error)
(venv) [iniciam@centos7 ~]$ sudo superset db upgrade
Traceback (most recent call last):
File "/bin/superset", line 6, in
from superset.cli import create_app
File "/usr/lib/python3.6/site-packages/superset/init__.py", line 196, in ConnectorRegistry.register_sources(module_datasource_map) File "/usr/lib/python3.6/site-packages/superset/connectors/connector_registry.py", line 14, in register_sources module_obj = _import_(module_name, fromlist=class_names) File "/usr/lib/python3.6/site-packages/superset/connectors/sqla/_init_.py", line 2, in from . import views # noqa File "/usr/lib/python3.6/site-packages/superset/connectors/sqla/views.py", line 13, in from superset.connectors.base.views import DatasourceModelView File "/usr/lib/python3.6/site-packages/superset/connectors/base/views.py", line 5, in from superset.views.base import SupersetModelView File "/usr/lib/python3.6/site-packages/superset/views/__init.py", line 2, in
from . import core # noqa
File "/usr/lib/python3.6/site-packages/superset/views/core.py", line 30, in
from superset import (
File "/usr/lib/python3.6/site-packages/superset/sql_lab.py", line 14, in
from superset import app, dataframe, db, results_backend, security_manager
File "/usr/lib/python3.6/site-packages/superset/dataframe.py", line 14, in
from pandas.core.common import _maybe_box_datetimelike
ImportError: cannot import name '_maybe_box_datetimelike'
Superset 0.28.1 is not compatible with pandas-0.25.0. This Superset version is compatible with pandas-0.23.4.
So we need to uninstall pandas-0.25.0 and install pandas-0.23.4.
(venv) [iniciam@centos7 ~]$ sudo pip3.6 uninstall pandas
Uninstalling pandas-0.25.0:
Would remove:
/usr/lib64/python3.6/site-packages/pandas-0.25.0.dist-info/*
/usr/lib64/python3.6/site-packages/pandas/*
Proceed (y/n)? y
Successfully uninstalled pandas-0.25.0
(venv) [iniciam@centos7 ~]$ sudo pip3.6 install pandas==0.23.4
Collecting pandas==0.23.4
Downloading https://files.pythonhosted.org/packages/e1/d8/feeb346d41f181e83fba45224ab14a8d8af019b48af742e047f3845d8cff/pandas-0.23.4-cp36-cp36m-manylinux1_x86_64.whl (8.9MB)
|████████████████████████████████| 8.9MB 3.3MB/s
Requirement already satisfied: python-dateutil>=2.5.0 in /usr/lib/python3.6/site-packages (from pandas==0.23.4) (2.8.0)
Requirement already satisfied: pytz>=2011k in /usr/lib/python3.6/site-packages (from pandas==0.23.4) (2019.1)
Requirement already satisfied: numpy>=1.9.0 in /usr/lib64/python3.6/site-packages (from pandas==0.23.4) (1.17.0)
Requirement already satisfied: six>=1.5 in /usr/lib/python3.6/site-packages (from python-dateutil>=2.5.0->pandas==0.23.4) (1.12.0)
Installing collected packages: pandas
Successfully installed pandas-0.23.4
Run superset db upgrade again (and get new error)
(venv) [iniciam@centos7 ~]$ superset db upgrade
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
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
/usr/lib/python3.6/site-packages/alembic/ddl/sqlite.py:39: UserWarning: Skipping unsupported ALTER for creation of implicit constraint
"Skipping unsupported ALTER for "
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
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.
WARNI [root] Constraint must have a name
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 shortner 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
/usr/lib64/python3.6/site-packages/sqlalchemy/dialects/sqlite/base.py:1842: SAWarning: WARNING: SQL-parsed foreign key constraint '('datasource_name', 'datasources', 'datasource_name')' could not be located in PRAGMA foreign_keys for table metrics
"foreign_keys for table %s" % (sig, table_name)
INFO [alembic.runtime.migration] Running upgrade 4736ec66ce19 -> 67a6ac9b727b, update_spatial_params
INFO [alembic.runtime.migration] Running upgrade 67a6ac9b727b -> 21e88bc06c02
INFO [alembic.runtime.migration] Running upgrade 21e88bc06c02 -> e866bd2d4976, smaller_grid
Revision ID: e866bd2d4976
Revises: 21e88bc06c02
Create Date: 2018-02-13 08:07:40.766277
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
Traceback (most recent call last):
File "/usr/bin/superset", line 15, in
cli()
File "/usr/lib/python3.6/site-packages/click/core.py", line 722, in call__ return self.main(*args, **kwargs) File "/usr/lib64/python3.6/site-packages/flask/cli.py", line 380, in main return AppGroup.main(self, *args, **kwargs) File "/usr/lib/python3.6/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/usr/lib/python3.6/site-packages/click/core.py", line 1066, in invoke return process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/lib/python3.6/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/lib/python3.6/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, *ctx.params) File "/usr/lib/python3.6/site-packages/click/core.py", line 535, in invoke return callback(args, **kwargs) File "/usr/lib/python3.6/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, **kwargs) File "/usr/lib64/python3.6/site-packages/flask/cli.py", line 257, in decorator return __ctx.invoke(f, *args, *kwargs) File "/usr/lib/python3.6/site-packages/click/core.py", line 535, in invoke return callback(args, *kwargs) File "/usr/lib64/python3.6/site-packages/flask_migrate/cli.py", line 134, in upgrade _upgrade(directory, revision, sql, tag, x_arg) File "/usr/lib64/python3.6/site-packages/flask_migrate/__init_.py", line 95, in wrapped f(args, **kwargs) File "/usr/lib64/python3.6/site-packages/flask_migrate/__init.py", line 280, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/lib/python3.6/site-packages/alembic/command.py", line 276, in upgrade
script.run_env()
File "/usr/lib/python3.6/site-packages/alembic/script/base.py", line 475, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file
module = load_module_py(module_id, path)
File "/usr/lib/python3.6/site-packages/alembic/util/compat.py", line 177, in load_module_py
spec.loader.exec_module(module)
File "", line 678, in exec_module
File "", line 219, in _call_with_frames_removed
File "/usr/lib/python3.6/site-packages/superset/migrations/env.py", line 100, in
run_migrations_online()
File "/usr/lib/python3.6/site-packages/superset/migrations/env.py", line 93, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "/usr/lib/python3.6/site-packages/alembic/runtime/environment.py", line 839, in run_migrations
self.get_context().run_migrations(kw) File "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 362, in run_migrations step.migration_fn(kw)
File "/usr/lib/python3.6/site-packages/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 82, in upgrade
replace('%%', '%')
File "/usr/lib/python3.6/site-packages/superset/migrations/versions/4451805bbaa1_remove_double_percents.py", line 53, in replace
.join(Table)
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2243, in join
from_joinpoint=from_joinpoint,
File "", line 2, in _join
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/base.py", line 220, in generate
fn(self, *args[1:], **kw)
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2422, in _join
left, right, onclause, prop, create_aliases, outerjoin, full
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2445, in _join_left_to_right
) = self._join_determine_implicit_left_side(left, right, onclause)
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 2578, in _join_determine_implicit_left_side
"Can't determine which FROM clause to join "
sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.
Apparently, Superset 0.28.1 is also not compatible with SQLAlchemy-1.3.6. This version compatible with SQLAlchemy-1.2.18.
Let’s uninstall the newer SQLAlchemy and install the older compatible ones.
(venv) [iniciam@centos7 ~]$ sudo pip3.6 list | grep sqlalchemy
marshmallow-sqlalchemy 0.17.0
(venv) [iniciam@centos7 ~]$ sudo pip3.6 uninstall sqlalchemy
Uninstalling SQLAlchemy-1.3.6:
Would remove:
/usr/lib64/python3.6/site-packages/SQLAlchemy-1.3.6-py3.6.egg-info
/usr/lib64/python3.6/site-packages/sqlalchemy/*
Proceed (y/n)? y
Successfully uninstalled SQLAlchemy-1.3.6
(venv) [iniciam@centos7 ~]$ sudo pip3.6 install sqlalchemy==1.2.18
Collecting sqlalchemy==1.2.18
Downloading https://files.pythonhosted.org/packages/21/ed/7eb53305b43ca51774a458d7c292f3bc7664d7a9bbb5bac4149fa34756b9/SQLAlchemy-1.2.18.tar.gz (5.7MB)
|████████████████████████████████| 5.7MB 2.3MB/s
Installing collected packages: sqlalchemy
Running setup.py install for sqlalchemy … done
Successfully installed sqlalchemy-1.2.18
Run superset db upgrade again (success)
(venv) [iniciam@centos7 ~]$ superset db upgrade INFO [alembic.runtime.migration] Context impl SQLiteImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. 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 /usr/lib/python3.6/site-packages/alembic/ddl/sqlite.py:39: UserWarning: Skipping unsupported ALTER for creation of implicit constraint "Skipping unsupported ALTER for " 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 4451805bbaa1, 1d9e835a84f9 -> e3970889f38e, 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
execute some flask commands
(venv) [iniciam@centos7 ~]$ export FLASK_APP=superset (venv) [iniciam@centos7 ~]$ flask fab create-admin Username [admin]: iniciam User first name [admin]: ini User last name [user]: ciam Email [admin@fab.org]: iniciam@yahoo.com Password: Repeat for confirmation: Recognized Database Authentications. Admin User iniciam created.
install superset built-in examples
(venv) [iniciam@centos7 ~]$ superset load_examples Loading examples into Creating default CSS templates Loading energy related dataset Creating table [wb_health_population] reference 2019-07-30 19:15:10,374:INFO:root:Creating database reference 2019-07-30 19:15:10,488:INFO:root:Database.get_sqla_engine(). Masked URL: sqlite:////home/iniciam/.superset/superset.db Loading [World Bank's Health Nutrition and Population Stats] Creating table [wb_health_population] reference 2019-07-30 19:15:22,900:INFO:root:Creating database reference Creating slices Creating a World's Health Bank dashboard Loading [Birth names] Done loading table! Creating table [birth_names] reference 2019-07-30 19:15:25,959:INFO:root:Creating database reference Creating some slices Creating a dashboard Loading [Random time series data] Done loading table! Creating table [random_time_series] reference 2019-07-30 19:15:27,304:INFO:root:Creating database reference Creating a slice Loading [Random long/lat data] Done loading table! Creating table reference 2019-07-30 19:15:48,727:INFO:root:Creating database reference Creating a slice Loading [Country Map data] Done loading table! Creating table reference 2019-07-30 19:15:48,984:INFO:root:Creating database reference Creating a slice Loading [Multiformat time series] Done loading table! Creating table [multiformat_time_series] reference 2019-07-30 19:15:49,298:INFO:root:Creating database reference Creating Heatmap charts Loading [Paris GeoJson] Creating table paris_iris_mapping reference 2019-07-30 19:15:51,514:INFO:root:Creating database reference Loading [San Francisco population polygons] Creating table sf_population_polygons reference 2019-07-30 19:15:51,822:INFO:root:Creating database reference Loading [Flights data] 2019-07-30 19:15:56,600:INFO:root:Creating database reference Done loading table! Loading [BART lines] Creating table bart_lines reference 2019-07-30 19:15:56,901:INFO:root:Creating database reference Loading [Multi Line] Creating table [wb_health_population] reference 2019-07-30 19:16:11,525:INFO:root:Creating database reference Creating slices Creating a World's Health Bank dashboard Done loading table! Creating table [birth_names] reference 2019-07-30 19:16:14,495:INFO:root:Creating database reference Creating some slices Creating a dashboard Loading [Misc Charts] dashboard Creating the dashboard Loading DECK.gl demo Loading deck.gl dashboard Creating Scatterplot slice Creating Screen Grid slice Creating Hex slice Creating Grid slice Creating Polygon slice Creating Arc slice Creating Path slice Creating a dashboard
initialize the superset
(venv) [iniciam@centos7 ~]$ superset init 2019-07-30 19:16:32,997:INFO:root:Creating database reference 2019-07-30 19:16:33,008:INFO:root:Syncing role definition 2019-07-30 19:16:33,232:INFO:root:Syncing Admin perms 2019-07-30 19:16:33,350:INFO:root:Syncing Alpha perms 2019-07-30 19:16:33,967:INFO:root:Syncing Gamma perms 2019-07-30 19:16:34,475:INFO:root:Syncing granter perms 2019-07-30 19:16:34,891:INFO:root:Syncing sql_lab perms 2019-07-30 19:16:35,357:INFO:root:Fetching a set of all perms to lookup which ones are missing 2019-07-30 19:16:35,456:INFO:root:Creating missing datasource permissions. 2019-07-30 19:16:35,465:INFO:root:Creating missing database permissions. 2019-07-30 19:16:35,552:INFO:root:Creating missing metrics permissions 2019-07-30 19:16:35,578:INFO:root:Cleaning faulty perms
run superset
(venv) [iniciam@centos7 ~]$ superset run -p 8080 --with-threads --reload --debugger 2019-07-30 19:17:02,920:INFO:werkzeug: * Running on http://127.0.0.1:8080/ (Press CTRL+C to quit) 2019-07-30 19:17:02,921:INFO:werkzeug: * Restarting with stat 2019-07-30 19:17:06,746:WARNING:werkzeug: * Debugger is active! 2019-07-30 19:17:06,753:INFO:werkzeug: * Debugger PIN: 662-004-552 2019-07-30 19:17:36,795:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:36] "GET / HTTP/1.1" 302 - 2019-07-30 19:17:36,806:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:36] "GET /superset/welcome HTTP/1.1" 302 - 2019-07-30 19:17:37,031:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /login/ HTTP/1.1" 200 - 2019-07-30 19:17:37,081:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/css/ab.css HTTP/1.1" 200 - 2019-07-30 19:17:37,091:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/css/flags/flags16.css HTTP/1.1" 200 - 2019-07-30 19:17:37,101:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/select2/select2.css HTTP/1.1" 200 - 2019-07-30 19:17:37,112:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/datepicker/bootstrap-datepicker.css HTTP/1.1" 200 - 2019-07-30 19:17:37,126:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/css/bootstrap.min.css HTTP/1.1" 200 - 2019-07-30 19:17:37,144:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/css/font-awesome.min.css HTTP/1.1" 200 - 2019-07-30 19:17:37,153:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/assets/dist/theme.d60351269dd2a4d6b5ae.entry.css HTTP/1.1" 200 - 2019-07-30 19:17:37,160:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/js/jquery-latest.js HTTP/1.1" 200 - 2019-07-30 19:17:37,209:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/js/ab_filters.js HTTP/1.1" 200 - 2019-07-30 19:17:37,212:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/js/ab_actions.js HTTP/1.1" 200 - 2019-07-30 19:17:37,221:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/assets/dist/theme.d60351269dd2a4d6b5ae.entry.js HTTP/1.1" 200 - 2019-07-30 19:17:37,226:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/js/bootstrap.min.js HTTP/1.1" 200 - 2019-07-30 19:17:37,231:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/datepicker/bootstrap-datepicker.js HTTP/1.1" 200 - 2019-07-30 19:17:37,242:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/select2/select2.js HTTP/1.1" 200 - 2019-07-30 19:17:37,250:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/js/ab.js HTTP/1.1" 200 - 2019-07-30 19:17:37,362:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/assets/dist/common.e76242fbf6a1ecefeccd.entry.js HTTP/1.1" 200 - 2019-07-30 19:17:37,382:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/assets/dist/vendors-major.4f5a17619ab655ae0e0c.chunk.js HTTP/1.1" 200 - 2019-07-30 19:17:37,399:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/assets/images/superset-logo@2x.png HTTP/1.1" 200 - 2019-07-30 19:17:37,405:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/assets/dist/vendors-addSlice-common-dashboard-profile-welcome.a9d0f0127af22fd18730.chunk.js HTTP/1.1" 200 - 2019-07-30 19:17:37,414:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/img/flags/flags16.png HTTP/1.1" 200 - 2019-07-30 19:17:37,443:INFO:werkzeug:127.0.0.1 - - [30/Jul/2019 19:17:37] "GET /static/appbuilder/fonts/fontawesome-webfont.woff2?v=4.7.0 HTTP/1.1" 200
Open superset from web browser & check the examples
I will explore Superset and share my experiences in future blog post.
Enjoy today.
Technology gems to share 
You must be logged in to post a comment.