Superset 安装部署

  1. 云栖社区>
  2. 博客>
  3. 正文

Superset 安装部署

北斗云 2019-07-22 16:05:52 浏览143
展开阅读全文

Superset

1.jdk

2.mysql

clickhouse

pip install sqlalchemy-clickhouse

iso8601/six/pytz/setuptools/urllib3/chardet/idna/certifi/iso8601/infi.clickhouse-orm/sqlalchemy-clickhouse

3.document


https://access.redhat.com/products/red-hat-enterprise-linux/evaluation

https://github.com/apache/incubator-superset/issues/6347

https://github.com/Guavus/incubator-superset/commit/bac9840442e59a0e2bccd9b2b0bd01ccad497740

http://www.doc88.com/p-8512527762539.html

http://superset.apache.org/

https://pypi.org/project/superset/#description

https://pypi.org/project/superset/#history

http://www.pymssql.org/en/stable/

https://docs.sqlalchemy.org/en/13/core/engines.html#database-urls

https://pip.pypa.io/en/stable/reference/pip_download/

https://opsx.alibaba.com/mirror

https://mirrors.aliyun.com/centos/7.6.1810/os/x86_64/Packages/

http://vault.centos.org/7.3.1611/os/x86_64/Packages/

4.superset

a).Environmental dependence

[root@localhost /]# yum install gcc gcc-c++ libffi-devel python-devel python-pip python-wheel openssl-devel libsasl2-devel openldap-devel
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.nwsuaf.edu.cn
No package python-pip available.
No package python-wheel available.
No package libsasl2-devel available.
Resolving Dependencies
--> Running transaction check
---> Package gcc.x86_64 0:4.8.5-36.el7_6.2 will be installed
--> Processing Dependency: libgomp = 4.8.5-36.el7_6.2 for package: gcc-4.8.5-36.el7_6.2.x86_64
--> Processing Dependency: cpp = 4.8.5-36.el7_6.2 for package: gcc-4.8.5-36.el7_6.2.x86_64
--> Processing Dependency: libgcc >= 4.8.5-36.el7_6.2 for package: gcc-4.8.5-36.el7_6.2.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-36.el7_6.2.x86_64
---> Package gcc-c++.x86_64 0:4.8.5-36.el7_6.2 will be installed
--> Processing Dependency: libstdc++-devel = 4.8.5-36.el7_6.2 for package: gcc-c++-4.8.5-36.el7_6.2.x86_64
--> Processing Dependency: libstdc++ = 4.8.5-36.el7_6.2 for package: gcc-c++-4.8.5-36.el7_6.2.x86_64
---> Package libffi-devel.x86_64 0:3.0.13-18.el7 will be installed
---> Package openldap-devel.x86_64 0:2.4.44-21.el7_6 will be installed
--> Processing Dependency: openldap(x86-64) = 2.4.44-21.el7_6 for package: openldap-devel-2.4.44-21.el7_6.x86_64
--> Processing Dependency: cyrus-sasl-devel(x86-64) for package: openldap-devel-2.4.44-21.el7_6.x86_64
---> Package openssl-devel.x86_64 1:1.0.2k-16.el7_6.1 will be installed
--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.2k-16.el7_6.1 for package: 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64
--> Processing Dependency: zlib-devel(x86-64) for package: 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64
--> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64
---> Package python-devel.x86_64 0:2.7.5-77.el7_6 will be installed
--> Processing Dependency: python(x86-64) = 2.7.5-77.el7_6 for package: python-devel-2.7.5-77.el7_6.x86_64
--> Running transaction check
---> Package cpp.x86_64 0:4.8.5-36.el7_6.2 will be installed
---> Package cyrus-sasl-devel.x86_64 0:2.1.26-23.el7 will be installed
---> Package glibc-devel.x86_64 0:2.17-260.el7_6.5 will be installed
--> Processing Dependency: glibc-headers = 2.17-260.el7_6.5 for package: glibc-devel-2.17-260.el7_6.5.x86_64
--> Processing Dependency: glibc = 2.17-260.el7_6.5 for package: glibc-devel-2.17-260.el7_6.5.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-260.el7_6.5.x86_64
---> Package krb5-devel.x86_64 0:1.15.1-37.el7_6 will be installed
--> Processing Dependency: libkadm5(x86-64) = 1.15.1-37.el7_6 for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: krb5-libs(x86-64) = 1.15.1-37.el7_6 for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: libverto-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
---> Package libgcc.x86_64 0:4.8.5-36.el7 will be updated
---> Package libgcc.x86_64 0:4.8.5-36.el7_6.2 will be an update
---> Package libgomp.x86_64 0:4.8.5-36.el7 will be updated
---> Package libgomp.x86_64 0:4.8.5-36.el7_6.2 will be an update
---> Package libstdc++.x86_64 0:4.8.5-36.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-36.el7_6.2 will be an update
---> Package libstdc++-devel.x86_64 0:4.8.5-36.el7_6.2 will be installed
---> Package openldap.x86_64 0:2.4.44-20.el7 will be updated
---> Package openldap.x86_64 0:2.4.44-21.el7_6 will be an update
---> Package openssl-libs.x86_64 1:1.0.2k-16.el7 will be updated
--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.2k-16.el7 for package: 1:openssl-1.0.2k-16.el7.x86_64
---> Package openssl-libs.x86_64 1:1.0.2k-16.el7_6.1 will be an update
---> Package python.x86_64 0:2.7.5-76.el7 will be updated
---> Package python.x86_64 0:2.7.5-77.el7_6 will be an update
--> Processing Dependency: python-libs(x86-64) = 2.7.5-77.el7_6 for package: python-2.7.5-77.el7_6.x86_64
---> Package zlib-devel.x86_64 0:1.2.7-18.el7 will be installed
--> Running transaction check
---> Package glibc.x86_64 0:2.17-260.el7 will be updated
--> Processing Dependency: glibc = 2.17-260.el7 for package: glibc-common-2.17-260.el7.x86_64
---> Package glibc.x86_64 0:2.17-260.el7_6.5 will be an update
---> Package glibc-headers.x86_64 0:2.17-260.el7_6.5 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-260.el7_6.5.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-260.el7_6.5.x86_64
---> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed
---> Package krb5-libs.x86_64 0:1.15.1-34.el7 will be updated
--> Processing Dependency: krb5-libs(x86-64) = 1.15.1-34.el7 for package: krb5-workstation-1.15.1-34.el7.x86_64
---> Package krb5-libs.x86_64 0:1.15.1-37.el7_6 will be an update
---> Package libcom_err-devel.x86_64 0:1.42.9-13.el7 will be installed
---> Package libkadm5.x86_64 0:1.15.1-34.el7 will be updated
---> Package libkadm5.x86_64 0:1.15.1-37.el7_6 will be an update
---> Package libselinux-devel.x86_64 0:2.5-14.1.el7 will be installed
--> Processing Dependency: libsepol-devel(x86-64) >= 2.5-10 for package: libselinux-devel-2.5-14.1.el7.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.5-14.1.el7.x86_64
--> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.5-14.1.el7.x86_64
---> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed
---> Package openssl.x86_64 1:1.0.2k-16.el7 will be updated
---> Package openssl.x86_64 1:1.0.2k-16.el7_6.1 will be an update
---> Package python-libs.x86_64 0:2.7.5-76.el7 will be updated
---> Package python-libs.x86_64 0:2.7.5-77.el7_6 will be an update
--> Running transaction check
---> Package glibc-common.x86_64 0:2.17-260.el7 will be updated
---> Package glibc-common.x86_64 0:2.17-260.el7_6.5 will be an update
---> Package kernel-headers.x86_64 0:3.10.0-957.12.1.el7 will be installed
---> Package krb5-workstation.x86_64 0:1.15.1-34.el7 will be updated
---> Package krb5-workstation.x86_64 0:1.15.1-37.el7_6 will be an update
---> Package libsepol-devel.x86_64 0:2.5-10.el7 will be installed
---> Package pcre-devel.x86_64 0:8.32-17.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================================================================================================
 Package                                                       Arch                                             Version                                                          Repository                                         Size
=========================================================================================================================================================================================================================================
Installing:
 gcc                                                           x86_64                                           4.8.5-36.el7_6.2                                                 updates                                            16 M
 gcc-c++                                                       x86_64                                           4.8.5-36.el7_6.2                                                 updates                                           7.2 M
 libffi-devel                                                  x86_64                                           3.0.13-18.el7                                                    base                                               23 k
 openldap-devel                                                x86_64                                           2.4.44-21.el7_6                                                  updates                                           804 k
 openssl-devel                                                 x86_64                                           1:1.0.2k-16.el7_6.1                                              updates                                           1.5 M
 python-devel                                                  x86_64                                           2.7.5-77.el7_6                                                   updates                                           398 k
Installing for dependencies:
 cpp                                                           x86_64                                           4.8.5-36.el7_6.2                                                 updates                                           5.9 M
 cyrus-sasl-devel                                              x86_64                                           2.1.26-23.el7                                                    base                                              310 k
 glibc-devel                                                   x86_64                                           2.17-260.el7_6.5                                                 updates                                           1.1 M
 glibc-headers                                                 x86_64                                           2.17-260.el7_6.5                                                 updates                                           683 k
 kernel-headers                                                x86_64                                           3.10.0-957.12.1.el7                                              updates                                           8.0 M
 keyutils-libs-devel                                           x86_64                                           1.5.8-3.el7                                                      base                                               37 k
 krb5-devel                                                    x86_64                                           1.15.1-37.el7_6                                                  updates                                           271 k
 libcom_err-devel                                              x86_64                                           1.42.9-13.el7                                                    base                                               31 k
 libselinux-devel                                              x86_64                                           2.5-14.1.el7                                                     base                                              187 k
 libsepol-devel                                                x86_64                                           2.5-10.el7                                                       base                                               77 k
 libstdc++-devel                                               x86_64                                           4.8.5-36.el7_6.2                                                 updates                                           1.5 M
 libverto-devel                                                x86_64                                           0.2.5-4.el7                                                      base                                               12 k
 pcre-devel                                                    x86_64                                           8.32-17.el7                                                      base                                              480 k
 zlib-devel                                                    x86_64                                           1.2.7-18.el7                                                     base                                               50 k
Updating for dependencies:
 glibc                                                         x86_64                                           2.17-260.el7_6.5                                                 updates                                           3.7 M
 glibc-common                                                  x86_64                                           2.17-260.el7_6.5                                                 updates                                            12 M
 krb5-libs                                                     x86_64                                           1.15.1-37.el7_6                                                  updates                                           803 k
 krb5-workstation                                              x86_64                                           1.15.1-37.el7_6                                                  updates                                           816 k
 libgcc                                                        x86_64                                           4.8.5-36.el7_6.2                                                 updates                                           102 k
 libgomp                                                       x86_64                                           4.8.5-36.el7_6.2                                                 updates                                           158 k
 libkadm5                                                      x86_64                                           1.15.1-37.el7_6                                                  updates                                           178 k
 libstdc++                                                     x86_64                                           4.8.5-36.el7_6.2                                                 updates                                           305 k
 openldap                                                      x86_64                                           2.4.44-21.el7_6                                                  updates                                           356 k
 openssl                                                       x86_64                                           1:1.0.2k-16.el7_6.1                                              updates                                           493 k
 openssl-libs                                                  x86_64                                           1:1.0.2k-16.el7_6.1                                              updates                                           1.2 M
 python                                                        x86_64                                           2.7.5-77.el7_6                                                   updates                                            94 k
 python-libs                                                   x86_64                                           2.7.5-77.el7_6                                                   updates                                           5.6 M

Transaction Summary
=========================================================================================================================================================================================================================================
Install  6 Packages (+14 Dependent packages)
Upgrade             ( 13 Dependent packages)

Total download size: 70 M
Is this ok [y/d/N]: y
Downloading packages:
updates/7/x86_64/prestodelta                                                                                                                                                                                      | 632 kB  00:00:15     
Delta RPMs reduced 14 M of updates to 2.4 M (82% saved)
(1/33): libgomp-4.8.5-36.el7_4.8.5-36.el7_6.2.x86_64.drpm                                                                                                                                                         |  45 kB  00:00:01     
(2/33): libgcc-4.8.5-36.el7_4.8.5-36.el7_6.2.x86_64.drpm                                                                                                                                                          |  44 kB  00:00:01     
(3/33): libstdc++-4.8.5-36.el7_4.8.5-36.el7_6.2.x86_64.drpm                                                                                                                                                       |  47 kB  00:00:00     
(4/33): openldap-2.4.44-20.el7_2.4.44-21.el7_6.x86_64.drpm                                                                                                                                                        |  77 kB  00:00:01     
(5/33): openssl-libs-1.0.2k-16.el7_1.0.2k-16.el7_6.1.x86_64.drpm                                                                                                                                                  | 135 kB  00:00:02     
(6/33): krb5-workstation-1.15.1-34.el7_1.15.1-37.el7_6.x86_64.drpm                                                                                                                                                | 225 kB  00:00:07     
(7/33): python-2.7.5-76.el7_2.7.5-77.el7_6.x86_64.drpm                                                                                                                                                            |  66 kB  00:00:01     
(8/33): openssl-1.0.2k-16.el7_1.0.2k-16.el7_6.1.x86_64.drpm                                                                                                                                                       | 352 kB  00:00:06     
(9/33): krb5-libs-1.15.1-34.el7_1.15.1-37.el7_6.x86_64.drpm                                                                                                                                                       | 279 kB  00:00:12     
warning: /var/cache/yum/x86_64/7/base/packages/cyrus-sasl-devel-2.1.26-23.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY                                                       ] 189 kB/s | 2.8 MB  00:05:03 ETA 
Public key for cyrus-sasl-devel-2.1.26-23.el7.x86_64.rpm is not installed
(10/33): cyrus-sasl-devel-2.1.26-23.el7.x86_64.rpm                                                                                                                                                                | 310 kB  00:00:06     
(11/33): glibc-2.17-260.el7_2.17-260.el7_6.5.x86_64.drpm                                                                                                                                                          | 734 kB  00:00:18     
(12/33): python-libs-2.7.5-76.el7_2.7.5-77.el7_6.x86_64.drpm                                                                                                                                                      | 404 kB  00:00:15     
Public key for glibc-devel-2.17-260.el7_6.5.x86_64.rpm is not installed                               26% [========================-                                                                   ] 187 kB/s |  16 MB  00:03:54 ETA 
(13/33): glibc-devel-2.17-260.el7_6.5.x86_64.rpm                                                                                                                                                                  | 1.1 MB  00:01:02     
(14/33): glibc-headers-2.17-260.el7_6.5.x86_64.rpm                                                                                                                                                                | 683 kB  00:00:22     
(15/33): cpp-4.8.5-36.el7_6.2.x86_64.rpm                                                                                                                                                                          | 5.9 MB  00:02:11     
(16/33): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm                                                                                                                                                               |  37 kB  00:00:01     
(17/33): krb5-devel-1.15.1-37.el7_6.x86_64.rpm                                                                                                                                                                    | 271 kB  00:00:07     
(18/33): libcom_err-devel-1.42.9-13.el7.x86_64.rpm                                                                                                                                                                |  31 kB  00:00:00     
(19/33): libffi-devel-3.0.13-18.el7.x86_64.rpm                                                                                                                                                                    |  23 kB  00:00:00     
(20/33): libkadm5-1.15.1-37.el7_6.x86_64.rpm                                                                                                                                                                      | 178 kB  00:00:04     
(21/33): libselinux-devel-2.5-14.1.el7.x86_64.rpm                                                                                                                                                                 | 187 kB  00:00:04     
(22/33): libsepol-devel-2.5-10.el7.x86_64.rpm                                                                                                                                                                     |  77 kB  00:00:02     
(23/33): gcc-c++-4.8.5-36.el7_6.2.x86_64.rpm                                                                                                                                                                      | 7.2 MB  00:02:41     
(24/33): libverto-devel-0.2.5-4.el7.x86_64.rpm                                                                                                                                                                    |  12 kB  00:00:00     
(25/33): libstdc++-devel-4.8.5-36.el7_6.2.x86_64.rpm                                                                                                                                                              | 1.5 MB  00:00:33     
openldap-devel-2.4.44-21.el7_6 FAILED                                                                 69% [===============================================================-                            ] 175 kB/s |  41 MB  00:01:45 ETA 
http://centos.ustc.edu.cn/centos/7.6.1810/updates/x86_64/Packages/openldap-devel-2.4.44-21.el7_6.x86_64.rpm: [Errno 12] Timeout on http://centos.ustc.edu.cn/centos/7.6.1810/updates/x86_64/Packages/openldap-devel-2.4.44-21.el7_6.x86_64.rpm: (28, 'Operation too slow. Less than 1000 bytes/sec transferred the last 30 seconds')
Trying other mirror.
(26/33): pcre-devel-8.32-17.el7.x86_64.rpm                                                                                                                                                                        | 480 kB  00:00:09     
(27/33): python-devel-2.7.5-77.el7_6.x86_64.rpm                                                                                                                                                                   | 398 kB  00:00:16     
(28/33): zlib-devel-1.2.7-18.el7.x86_64.rpm                                                                                                                                                                       |  50 kB  00:00:01     
(29/33): openssl-devel-1.0.2k-16.el7_6.1.x86_64.rpm                                                                                                                                                               | 1.5 MB  00:01:10     
(30/33): openldap-devel-2.4.44-21.el7_6.x86_64.rpm                                                                                                                                                                | 804 kB  00:00:33     
(31/33): kernel-headers-3.10.0-957.12.1.el7.x86_64.rpm                                                                                                                                                            | 8.0 MB  00:03:15     
(32/33): glibc-common-2.17-260.el7_6.5.x86_64.rpm                                                                                                                                                                 |  12 MB  00:04:55     
(33/33): gcc-4.8.5-36.el7_6.2.x86_64.rpm                                                                                                                                                                          |  16 MB  00:05:21     
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                    180 kB/s |  59 MB  00:05:33     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Importing GPG key 0xF4A80EB5:
 Userid     : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>"
 Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5
 Package    : centos-release-7-6.1810.2.el7.centos.x86_64 (@anaconda)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
icedtea-web-1.7.1-1.el7.x86_64 has missing requires of java-1.8.0-openjdk
  Updating   : libgcc-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                       1/46 
  Updating   : glibc-common-2.17-260.el7_6.5.x86_64                                                                                                                                                                                 2/46 
  Updating   : glibc-2.17-260.el7_6.5.x86_64                                                                                                                                                                                        3/46 
  Updating   : 1:openssl-libs-1.0.2k-16.el7_6.1.x86_64                                                                                                                                                                              4/46 
  Updating   : krb5-libs-1.15.1-37.el7_6.x86_64                                                                                                                                                                                     5/46 
  Updating   : libkadm5-1.15.1-37.el7_6.x86_64                                                                                                                                                                                      6/46 
  Updating   : python-libs-2.7.5-77.el7_6.x86_64                                                                                                                                                                                    7/46 
  Updating   : libstdc++-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                    8/46 
  Installing : libstdc++-devel-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                              9/46 
  Updating   : python-2.7.5-77.el7_6.x86_64                                                                                                                                                                                        10/46 
  Installing : cyrus-sasl-devel-2.1.26-23.el7.x86_64                                                                                                                                                                               11/46 
  Updating   : openldap-2.4.44-21.el7_6.x86_64                                                                                                                                                                                     12/46 
  Updating   : libgomp-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                     13/46 
  Installing : cpp-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                         14/46 
  Installing : libverto-devel-0.2.5-4.el7.x86_64                                                                                                                                                                                   15/46 
  Installing : libsepol-devel-2.5-10.el7.x86_64                                                                                                                                                                                    16/46 
  Installing : zlib-devel-1.2.7-18.el7.x86_64                                                                                                                                                                                      17/46 
  Installing : kernel-headers-3.10.0-957.12.1.el7.x86_64                                                                                                                                                                           18/46 
  Installing : glibc-headers-2.17-260.el7_6.5.x86_64                                                                                                                                                                               19/46 
  Installing : glibc-devel-2.17-260.el7_6.5.x86_64                                                                                                                                                                                 20/46 
  Installing : gcc-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                         21/46 
  Installing : pcre-devel-8.32-17.el7.x86_64                                                                                                                                                                                       22/46 
  Installing : libselinux-devel-2.5-14.1.el7.x86_64                                                                                                                                                                                23/46 
  Installing : libcom_err-devel-1.42.9-13.el7.x86_64                                                                                                                                                                               24/46 
  Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                                                                                                              25/46 
  Installing : krb5-devel-1.15.1-37.el7_6.x86_64                                                                                                                                                                                   26/46 
  Installing : 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64                                                                                                                                                                            27/46 
  Installing : gcc-c++-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                     28/46 
  Installing : openldap-devel-2.4.44-21.el7_6.x86_64                                                                                                                                                                               29/46 
  Installing : python-devel-2.7.5-77.el7_6.x86_64                                                                                                                                                                                  30/46 
  Updating   : krb5-workstation-1.15.1-37.el7_6.x86_64                                                                                                                                                                             31/46 
  Updating   : 1:openssl-1.0.2k-16.el7_6.1.x86_64                                                                                                                                                                                  32/46 
  Installing : libffi-devel-3.0.13-18.el7.x86_64                                                                                                                                                                                   33/46 
  Cleanup    : krb5-workstation-1.15.1-34.el7.x86_64                                                                                                                                                                               34/46 
  Cleanup    : libkadm5-1.15.1-34.el7.x86_64                                                                                                                                                                                       35/46 
  Cleanup    : 1:openssl-1.0.2k-16.el7.x86_64                                                                                                                                                                                      36/46 
  Cleanup    : openldap-2.4.44-20.el7.x86_64                                                                                                                                                                                       37/46 
  Cleanup    : python-2.7.5-76.el7.x86_64                                                                                                                                                                                          38/46 
  Cleanup    : python-libs-2.7.5-76.el7.x86_64                                                                                                                                                                                     39/46 
  Cleanup    : 1:openssl-libs-1.0.2k-16.el7.x86_64                                                                                                                                                                                 40/46 
  Cleanup    : krb5-libs-1.15.1-34.el7.x86_64                                                                                                                                                                                      41/46 
  Cleanup    : libstdc++-4.8.5-36.el7.x86_64                                                                                                                                                                                       42/46 
  Cleanup    : libgomp-4.8.5-36.el7.x86_64                                                                                                                                                                                         43/46 
  Cleanup    : glibc-common-2.17-260.el7.x86_64                                                                                                                                                                                    44/46 
  Cleanup    : glibc-2.17-260.el7.x86_64                                                                                                                                                                                           45/46 
  Cleanup    : libgcc-4.8.5-36.el7.x86_64                                                                                                                                                                                          46/46 
  Verifying  : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                                                                                                               1/46 
  Verifying  : krb5-workstation-1.15.1-37.el7_6.x86_64                                                                                                                                                                              2/46 
  Verifying  : libcom_err-devel-1.42.9-13.el7.x86_64                                                                                                                                                                                3/46 
  Verifying  : pcre-devel-8.32-17.el7.x86_64                                                                                                                                                                                        4/46 
  Verifying  : gcc-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                          5/46 
  Verifying  : kernel-headers-3.10.0-957.12.1.el7.x86_64                                                                                                                                                                            6/46 
  Verifying  : krb5-devel-1.15.1-37.el7_6.x86_64                                                                                                                                                                                    7/46 
  Verifying  : libstdc++-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                    8/46 
  Verifying  : libffi-devel-3.0.13-18.el7.x86_64                                                                                                                                                                                    9/46 
  Verifying  : 1:openssl-devel-1.0.2k-16.el7_6.1.x86_64                                                                                                                                                                            10/46 
  Verifying  : zlib-devel-1.2.7-18.el7.x86_64                                                                                                                                                                                      11/46 
  Verifying  : krb5-libs-1.15.1-37.el7_6.x86_64                                                                                                                                                                                    12/46 
  Verifying  : glibc-devel-2.17-260.el7_6.5.x86_64                                                                                                                                                                                 13/46 
  Verifying  : libgcc-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                      14/46 
  Verifying  : libgomp-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                     15/46 
  Verifying  : openldap-devel-2.4.44-21.el7_6.x86_64                                                                                                                                                                               16/46 
  Verifying  : glibc-2.17-260.el7_6.5.x86_64                                                                                                                                                                                       17/46 
  Verifying  : cyrus-sasl-devel-2.1.26-23.el7.x86_64                                                                                                                                                                               18/46 
  Verifying  : libstdc++-devel-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                             19/46 
  Verifying  : glibc-common-2.17-260.el7_6.5.x86_64                                                                                                                                                                                20/46 
  Verifying  : 1:openssl-1.0.2k-16.el7_6.1.x86_64                                                                                                                                                                                  21/46 
  Verifying  : gcc-c++-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                     22/46 
  Verifying  : 1:openssl-libs-1.0.2k-16.el7_6.1.x86_64                                                                                                                                                                             23/46 
  Verifying  : python-2.7.5-77.el7_6.x86_64                                                                                                                                                                                        24/46 
  Verifying  : libsepol-devel-2.5-10.el7.x86_64                                                                                                                                                                                    25/46 
  Verifying  : python-devel-2.7.5-77.el7_6.x86_64                                                                                                                                                                                  26/46 
  Verifying  : libverto-devel-0.2.5-4.el7.x86_64                                                                                                                                                                                   27/46 
  Verifying  : libkadm5-1.15.1-37.el7_6.x86_64                                                                                                                                                                                     28/46 
  Verifying  : glibc-headers-2.17-260.el7_6.5.x86_64                                                                                                                                                                               29/46 
  Verifying  : libselinux-devel-2.5-14.1.el7.x86_64                                                                                                                                                                                30/46 
  Verifying  : cpp-4.8.5-36.el7_6.2.x86_64                                                                                                                                                                                         31/46 
  Verifying  : python-libs-2.7.5-77.el7_6.x86_64                                                                                                                                                                                   32/46 
  Verifying  : openldap-2.4.44-21.el7_6.x86_64                                                                                                                                                                                     33/46 
  Verifying  : python-2.7.5-76.el7.x86_64                                                                                                                                                                                          34/46 
  Verifying  : krb5-workstation-1.15.1-34.el7.x86_64                                                                                                                                                                               35/46 
  Verifying  : libgcc-4.8.5-36.el7.x86_64                                                                                                                                                                                          36/46 
  Verifying  : libstdc++-4.8.5-36.el7.x86_64                                                                                                                                                                                       37/46 
  Verifying  : openldap-2.4.44-20.el7.x86_64                                                                                                                                                                                       38/46 
  Verifying  : 1:openssl-libs-1.0.2k-16.el7.x86_64                                                                                                                                                                                 39/46 
  Verifying  : 1:openssl-1.0.2k-16.el7.x86_64                                                                                                                                                                                      40/46 
  Verifying  : libkadm5-1.15.1-34.el7.x86_64                                                                                                                                                                                       41/46 
  Verifying  : libgomp-4.8.5-36.el7.x86_64                                                                                                                                                                                         42/46 
  Verifying  : glibc-common-2.17-260.el7.x86_64                                                                                                                                                                                    43/46 
  Verifying  : glibc-2.17-260.el7.x86_64                                                                                                                                                                                           44/46 
  Verifying  : krb5-libs-1.15.1-34.el7.x86_64                                                                                                                                                                                      45/46 
  Verifying  : python-libs-2.7.5-76.el7.x86_64                                                                                                                                                                                     46/46 

Installed:
  gcc.x86_64 0:4.8.5-36.el7_6.2   gcc-c++.x86_64 0:4.8.5-36.el7_6.2   libffi-devel.x86_64 0:3.0.13-18.el7   openldap-devel.x86_64 0:2.4.44-21.el7_6   openssl-devel.x86_64 1:1.0.2k-16.el7_6.1   python-devel.x86_64 0:2.7.5-77.el7_6  

Dependency Installed:
  cpp.x86_64 0:4.8.5-36.el7_6.2                  cyrus-sasl-devel.x86_64 0:2.1.26-23.el7      glibc-devel.x86_64 0:2.17-260.el7_6.5        glibc-headers.x86_64 0:2.17-260.el7_6.5      kernel-headers.x86_64 0:3.10.0-957.12.1.el7     
  keyutils-libs-devel.x86_64 0:1.5.8-3.el7       krb5-devel.x86_64 0:1.15.1-37.el7_6          libcom_err-devel.x86_64 0:1.42.9-13.el7      libselinux-devel.x86_64 0:2.5-14.1.el7       libsepol-devel.x86_64 0:2.5-10.el7              
  libstdc++-devel.x86_64 0:4.8.5-36.el7_6.2      libverto-devel.x86_64 0:0.2.5-4.el7          pcre-devel.x86_64 0:8.32-17.el7              zlib-devel.x86_64 0:1.2.7-18.el7            

Dependency Updated:
  glibc.x86_64 0:2.17-260.el7_6.5      glibc-common.x86_64 0:2.17-260.el7_6.5  krb5-libs.x86_64 0:1.15.1-37.el7_6  krb5-workstation.x86_64 0:1.15.1-37.el7_6  libgcc.x86_64 0:4.8.5-36.el7_6.2         libgomp.x86_64 0:4.8.5-36.el7_6.2 
  libkadm5.x86_64 0:1.15.1-37.el7_6    libstdc++.x86_64 0:4.8.5-36.el7_6.2     openldap.x86_64 0:2.4.44-21.el7_6   openssl.x86_64 1:1.0.2k-16.el7_6.1         openssl-libs.x86_64 1:1.0.2k-16.el7_6.1  python.x86_64 0:2.7.5-77.el7_6    
  python-libs.x86_64 0:2.7.5-77.el7_6 

Complete!

b).Python dependence

[root@localhost opt]# wget https://bootstrap.pypa.io/get-pip.py
--2019-05-13 13:32:29--  https://bootstrap.pypa.io/get-pip.py
Resolving bootstrap.pypa.io (bootstrap.pypa.io)... 151.101.108.175, 2a04:4e42:1a::175
Connecting to bootstrap.pypa.io (bootstrap.pypa.io)|151.101.108.175|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1709825 (1.6M) [text/x-python]
Saving to: ‘get-pip.py’

100%[===============================================================================================================================================================================================>] 1,709,825    250KB/s   in 6.8s   

2019-05-13 13:32:41 (244 KB/s) - ‘get-pip.py’ saved [1709825/1709825]

[root@localhost opt]# ll
total 1672
-rw-r--r--. 1 root root 1709825 Apr 24 10:45 get-pip.py
drwxr-xr-x. 9 root root     129 May 13 11:35 mysql
drwxr-xr-x. 2 root root       6 Oct 31  2018 rh
drwxr-xr-x. 2 root root     216 May 13 11:42 software
[root@localhost opt]# python get-pip.py
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting pip
  Downloading https://files.pythonhosted.org/packages/5c/e0/be401c003291b56efc55aeba6a80ab790d3d4cece2778288d65323009420/pip-19.1.1-py2.py3-none-any.whl (1.4MB)
     |████████████████████████████████| 1.4MB 7.1kB/s 
Collecting wheel
  Downloading https://files.pythonhosted.org/packages/bb/10/44230dd6bf3563b8f227dbf344c908d412ad2ff48066476672f3a72e174e/wheel-0.33.4-py2.py3-none-any.whl
Installing collected packages: pip, wheel
Successfully installed pip-19.1.1 wheel-0.33.4

c).Activate venv

[root@localhost bin]# source activate
(venv) [root@localhost bin]# pip install pymysql
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting pymysql
  Downloading https://files.pythonhosted.org/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl (47kB)
     |████████████████████████████████| 51kB 3.4kB/s 
Installing collected packages: pymysql
Successfully installed pymysql-0.9.3

d).Install superset

(venv) [root@localhost bin]# pip install superset==0.27.0
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting superset==0.27.0
  Downloading https://files.pythonhosted.org/packages/e9/28/6a2a3317650b441990799312538b803dcfcb8dd6d2ee2489dfc928bd5ff9/superset-0.27.0.tar.gz (53.3MB)
     |████████████████████████████████| 53.3MB 127kB/s
-----------------------------------------------------------------------------------------------
Downloading https://files.pythonhosted.org/packages/22/28/a99c42aea746e18382ad9fb36f64c1c1f04216f41797f2f0fa567da11388/et_xmlfile-1.0.1.tar.gz
Building wheels for collected packages: superset, flask-appbuilder, flask-compress, flask-script, flask-testing, flower, future, humanize, pydruid, pyhive, python-geohash, pyyaml, simplejson, sqlalchemy, sqlalchemy-utils, thrift, thrift-sasl, unicodecsv, billiard, Flask-Babel, Flask-Login, Flask-OpenID, Flask-SQLAlchemy, alembic, tornado, geographiclib, scandir, sasl, pycparser, python-openid, Mako, functools32, pyrsistent, linear-tsv, openpyxl, et-xmlfile
  Building wheel for superset (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/ac/89/52/23994b4bfc6effe13f6257f29d2c0230b08cd7f5c85affdb9c
  Building wheel for flask-appbuilder (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/1e/b0/61/e8a16b4c2f4eac24f0e409e6c296032dbd23f71cf93dfde539
  Building wheel for flask-compress (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/96/32/88/a1f6d9dd3c29570ab3a8acc0d556b3b20abcf3c623c868ce0a
  Building wheel for flask-script (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/1c/17/70/4598e6dba4bec58c1b59552c6409272aea31978ab8159f11a1
  Building wheel for flask-testing (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/c0/60/a8/dbf20f30fbee518f6db9c3c539996cb29fb5d3f587c8a3f9e0
  Building wheel for flower (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/5b/9e/11/0baa7520069402a85f910a319ab0c90b1bea392d499ad5cd80
  Building wheel for future (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/bf/c9/a3/c538d90ef17cf7823fa51fc701a7a7a910a80f6a405bf15b1a
  Building wheel for humanize (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/69/86/6c/f8b8593bc273ec4b0c653d3827f7482bb2001a2781a73b7f44
  Building wheel for pydruid (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/b9/46/42/d759b9b3c90e1a6c54f8f7896b807107d22019fdd0a2403f23
  Building wheel for pyhive (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/00/61/fb/77a0e77deb4c900276f689e62628a5ca7ba9df600f9ad7ba6a
  Building wheel for python-geohash (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/b5/64/5a/6a286481fc7c2a698d2f297d4c90af19946be430b23eba9a33
  Building wheel for pyyaml (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/ad/56/bc/1522f864feb2a358ea6f1a92b4798d69ac783a28e80567a18b
  Building wheel for simplejson (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/5d/1a/1e/0350bb3df3e74215cd91325344cc86c2c691f5306eb4d22c77
  Building wheel for sqlalchemy (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/6b/02/e3/7f1149be63131cdf6aaaa3330924a2683bb530188940569d66
  Building wheel for sqlalchemy-utils (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/f6/6d/bc/61e4bcee3fa17541302eede4ccd65dd88c9d38a0cf726a7931
  Building wheel for thrift (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/be/36/81/0f93ba89a1cb7887c91937948519840a72c0ffdd57cac0ae8f
  Building wheel for thrift-sasl (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/c8/3a/34/1d82df3d652788fc211c245d51dde857a58e603695ea41d93d
  Building wheel for unicodecsv (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/a6/09/e9/e800279c98a0a8c94543f3de6c8a562f60e51363ed26e71283
  Building wheel for billiard (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/f0/69/3c/7df7f2f49f3934716458ea8a3ca5f3263ce2656e5ed5322acd
  Building wheel for Flask-Babel (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/2e/56/0c/ae3cc1279a4d1c5b7cec98634973266e3b4c06d026c2fc35cf
  Building wheel for Flask-Login (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/94/98/8f/b357415afe27adcdf071306f3f981e61a0498b7101707471fc
  Building wheel for Flask-OpenID (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/3b/1e/c0/b941aa1a5954f1acabbf1671a64e27adc359c0b0e74b16f8b4
  Building wheel for Flask-SQLAlchemy (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/bd/18/c4/5b1ebaec15e2bb933089576ebf905ea29976b2f37ed629e1c3
  Building wheel for alembic (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/de/cf/b3/0eb5c89ea6aa1b49cb41315f9ec139ada8cbffd575bf170d43
  Building wheel for tornado (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/6d/e1/ce/f4ee2fa420cc6b940123c64992b81047816d0a9fad6b879325
  Building wheel for geographiclib (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/99/45/d1/14954797e2a976083182c2e7da9b4e924509e59b6e5c661061
  Building wheel for scandir (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/91/95/75/19c98a91239878abbc7c59970abd3b4e0438a7dd5b61778335
  Building wheel for sasl (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/56/20/21/ff481fd0f4ae09d5d94c76d089f550204580b1703e44f27dd5
  Building wheel for pycparser (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/f2/9a/90/de94f8556265ddc9d9c8b271b0f63e57b26fb1d67a45564511
  Building wheel for python-openid (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/89/2a/a5/9efdd8de9a8f3d5bb0c13378f36fcaba544ae2a056c0d9dc37
  Building wheel for Mako (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/82/59/50/e9c6d83cf76c5f09e2f3eb976e38d4d5578ed37585e960a150
  Building wheel for functools32 (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/b5/18/32/77a1030457155606ba5e3ec3a8a57132b1a04b1c4f765177b2
  Building wheel for pyrsistent (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/6b/b9/15/c8c6a1e095a370e8c3273e65a5c982e5cf355dde16d77502f5
  Building wheel for linear-tsv (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/3f/8a/cb/38917fd1ef4356b9870ace7331b83417dc594bf2c029bd991f
  Building wheel for openpyxl (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/59/44/27/63b211425501ad51d197ff8ed00e9e469e38b9e516cb69b1c2
  Building wheel for et-xmlfile (setup.py) ... done
  Stored in directory: /root/.cache/pip/wheels/2a/77/35/0da0965a057698121fc7d8c5a7a9955cdbfb3cc4e2423cad39
Successfully built superset flask-appbuilder flask-compress flask-script flask-testing flower future humanize pydruid pyhive python-geohash pyyaml simplejson sqlalchemy sqlalchemy-utils thrift thrift-sasl unicodecsv billiard Flask-Babel Flask-Login Flask-OpenID Flask-SQLAlchemy alembic tornado geographiclib scandir sasl pycparser python-openid Mako functools32 pyrsistent linear-tsv openpyxl et-xmlfile
ERROR: flask-appbuilder 1.10.0 has requirement click==6.7, but you'll have click 7.0 which is incompatible.
ERROR: flask-appbuilder 1.10.0 has requirement colorama==0.3.9, but you'll have colorama 0.4.1 which is incompatible.
Installing collected packages: six, webencodings, bleach, python-dateutil, jmespath, docutils, botocore, futures, s3transfer, boto3, vine, pytz, billiard, amqp, kombu, celery, colorama, contextlib2, enum34, asn1crypto, pycparser, cffi, ipaddress, cryptography, itsdangerous, click, MarkupSafe, Jinja2, Werkzeug, flask, babel, Flask-Babel, Flask-Login, python-openid, Flask-OpenID, sqlalchemy, Flask-SQLAlchemy, WTForms, flask-wtf, flask-appbuilder, flask-caching, flask-compress, Mako, python-editor, alembic, flask-migrate, flask-script, flask-testing, singledispatch, backports-abc, tornado, flower, future, geographiclib, geopy, gunicorn, humanize, idna, markdown, numpy, pandas, parsedatetime, scandir, pathlib2, polyline, urllib3, chardet, certifi, requests, pydruid, pyhive, python-geohash, pyyaml, simplejson, sqlalchemy-utils, sqlparse, unicodecsv, functools32, pyrsistent, attrs, jsonschema, cchardet, xlrd, jsonlines, ijson, linear-tsv, jdcal, et-xmlfile, openpyxl, tabulator, isodate, rfc3986, tableschema, thrift, sasl, thrift-sasl, unidecode, superset
Successfully installed Flask-Babel-0.11.1 Flask-Login-0.2.11 Flask-OpenID-1.2.5 Flask-SQLAlchemy-2.1 Jinja2-2.10.1 Mako-1.0.10 MarkupSafe-1.1.1 WTForms-2.2.1 Werkzeug-0.15.2 alembic-1.0.10 amqp-2.4.2 asn1crypto-0.24.0 attrs-19.1.0 babel-2.6.0 backports-abc-0.5 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.3.9 cffi-1.12.3 chardet-3.0.4 click-7.0 colorama-0.4.1 contextlib2-0.5.5 cryptography-2.6.1 docutils-0.14 enum34-1.1.6 et-xmlfile-1.0.1 flask-0.12.4 flask-appbuilder-1.10.0 flask-caching-1.7.1 flask-compress-1.4.0 flask-migrate-2.4.0 flask-script-2.0.6 flask-testing-0.7.1 flask-wtf-0.14.2 flower-0.9.3 functools32-3.2.3.post2 future-0.16.0 futures-3.2.0 geographiclib-1.49 geopy-1.19.0 gunicorn-19.9.0 humanize-0.5.1 idna-2.8 ijson-2.3 ipaddress-1.0.22 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.5.0 linear-tsv-1.1.0 markdown-3.1 numpy-1.16.3 openpyxl-2.4.11 pandas-0.24.2 parsedatetime-2.4 pathlib2-2.3.3 polyline-1.3.2 pycparser-2.19 pydruid-0.5.2 pyhive-0.6.1 pyrsistent-0.15.2 python-dateutil-2.8.0 python-editor-1.0.4 python-geohash-0.8.5 python-openid-2.2.5 pytz-2019.1 pyyaml-5.1 requests-2.21.0 rfc3986-1.3.1 s3transfer-0.1.13 sasl-0.2.1 scandir-1.10.0 simplejson-3.16.0 singledispatch-3.4.0.3 six-1.12.0 sqlalchemy-1.3.3 sqlalchemy-utils-0.33.11 sqlparse-0.3.0 superset-0.27.0 tableschema-1.4.1 tabulator-1.20.0 thrift-0.11.0 thrift-sasl-0.3.0 tornado-5.1.1 unicodecsv-0.14.1 unidecode-1.0.23 urllib3-1.24.3 vine-1.3.0 webencodings-0.5.1 xlrd-1.2.0

e).Create user

(venv) [root@localhost bin]# fabmanager create-admin --app superset
Username [admin]: superset
User first name [admin]: superset
User last name [user]: superset
Email [admin@fab.org]: superset@apache.org      
Password: 
Repeat for confirmation: 
Recognized Database Authentications.
Admin User superset created.
(venv) [root@localhost bin]# 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
/opt/venv/lib/python2.7/site-packages/alembic/util/messaging.py:73: UserWarning: Skipping unsupported ALTER for creation of implicit constraint
  warnings.warn(msg)
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
WARNI [root] Could not find or drop constraint on `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] No such constraint: 'slices_ibfk_1'
WARNI [root] Constraint must have a name
WARNI [root] No such index: 'table_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
/opt/venv/lib/python2.7/site-packages/sqlalchemy/dialects/sqlite/base.py:1838: SAWarning: WARNING: SQL-parsed foreign key constraint '(u'datasource_name', u'datasources', u'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
(venv) [root@localhost bin]# superset load_examples
Loading examples into <SQLA engine=u'sqlite:////root/.superset/superset.db'>
Creating default CSS templates
Loading energy related dataset
Creating table [wb_health_population] reference
2019-05-13 17:18:40,526:INFO:root:Creating database reference
2019-05-13 17:18:40,581:INFO:root:Database.get_sqla_engine(). Masked URL: sqlite:////root/.superset/superset.db
Loading [World Bank's Health Nutrition and Population Stats]
Creating table [wb_health_population] reference
2019-05-13 17:19:04,410: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-05-13 17:19:08,303: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-05-13 17:19:09,213:INFO:root:Creating database reference
Creating a slice
Loading [Random long/lat data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
2019-05-13 17:19:25,063:INFO:root:Creating database reference
Creating a slice
Loading [Country Map data]
Done loading table!
--------------------------------------------------------------------------------
Creating table reference
2019-05-13 17:19:25,283:INFO:root:Creating database reference
Creating a slice
Loading [Multiformat time series]
Done loading table!
--------------------------------------------------------------------------------
Creating table [multiformat_time_series] reference
2019-05-13 17:19:25,494:INFO:root:Creating database reference
Creating Heatmap charts
Loading [Misc Charts] dashboard
Creating the dashboard
Loading [Paris GeoJson]
Creating table paris_iris_mapping reference
2019-05-13 17:19:27,488:INFO:root:Creating database reference
2019-05-13 17:19:27,528:INFO:root:Database.get_sqla_engine(). Masked URL: sqlite:////root/.superset/superset.db
Loading [San Francisco population polygons]
Creating table sf_population_polygons reference
2019-05-13 17:19:27,729:INFO:root:Creating database reference
Loading [Flights data]
2019-05-13 17:19:31,768:INFO:root:Creating database reference
Done loading table!
Loading [BART lines]
Creating table bart_lines reference
2019-05-13 17:19:31,949:INFO:root:Creating database reference
Loading [Multi Line]
Creating table [wb_health_population] reference
2019-05-13 17:19:46,481:INFO:root:Creating database reference
Creating slices
Creating a World's Health Bank dashboard
Done loading table!
--------------------------------------------------------------------------------
Creating table [birth_names] reference
2019-05-13 17:19:49,034:INFO:root:Creating database reference
Creating some slices
Creating a 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
(venv) [root@localhost bin]# superset init
2019-05-13 17:20:33,120:INFO:root:Creating database reference
2019-05-13 17:20:33,138:INFO:root:Syncing role definition
2019-05-13 17:20:33,216:INFO:root:Syncing Admin perms
2019-05-13 17:20:33,313:INFO:root:Syncing Alpha perms
2019-05-13 17:20:33,655:INFO:root:Syncing Gamma perms
2019-05-13 17:20:34,049:INFO:root:Syncing granter perms
2019-05-13 17:20:34,422:INFO:root:Syncing sql_lab perms
2019-05-13 17:20:34,814:INFO:root:Fetching a set of all perms to lookup which ones are missing
2019-05-13 17:20:34,893:INFO:root:Creating missing datasource permissions.
2019-05-13 17:20:34,902:INFO:root:Creating missing database permissions.
2019-05-13 17:20:34,930:INFO:root:Creating missing metrics permissions
2019-05-13 17:20:34,952:INFO:root:Cleaning faulty perms
superset runserver -d
nohup superset runserver -p 8088 & 

Mysql

a). update datasource

/opt/venv/lib/python2.7/site-packages/superset/config.py
#SQLALCHEMY_DATABASE_URI = 'sqlite:///' + os.path.join(DATA_DIR, 'superset.db')

SQLALCHEMY_DATABASE_URI = 'mysql://root:2wsx@WSX@druid01/superset'

b). update init

/opt/venv/lib/python2.7/site-packages/sqlalchemy/dialects/mysql
pip install mysql-python

Download

a). download and install

pip freeze > requirement.txt

pip download -d package -r requirement.txt 

pip install --no-index --find-links=d:\pak -r paklist.txt

yum install yum-plugin-downloadonly

yum -y install xxx --downloadonly --downloaddir /opt/temp

yum -y install gcc --downloadonly --downloaddir /opt/venv/rpm_package/

b). download repo

(venv) [root@localhost venv]# pip download -d package -r requirement.txt 
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting alembic==1.0.10 (from -r requirement.txt (line 1))
  Using cached https://files.pythonhosted.org/packages/6e/8b/fa3bd058cccd5e9177fea4efa26bfb769228fdd3178436ad5e05830ef6ef/alembic-1.0.10.tar.gz
  Saved ./package/alembic-1.0.10.tar.gz
Collecting amqp==2.4.2 (from -r requirement.txt (line 2))
  Using cached https://files.pythonhosted.org/packages/42/ec/cbbaa8f75be8cbd019afb9d63258e2bdc95242f8c46a54bb90db5fef03bd/amqp-2.4.2-py2.py3-none-any.whl
  Saved ./package/amqp-2.4.2-py2.py3-none-any.whl
Collecting asn1crypto==0.24.0 (from -r requirement.txt (line 3))
  Using cached https://files.pythonhosted.org/packages/ea/cd/35485615f45f30a510576f1a56d1e0a7ad7bd8ab5ed7cdc600ef7cd06222/asn1crypto-0.24.0-py2.py3-none-any.whl
  Saved ./package/asn1crypto-0.24.0-py2.py3-none-any.whl
Collecting attrs==19.1.0 (from -r requirement.txt (line 4))
  Using cached https://files.pythonhosted.org/packages/23/96/d828354fa2dbdf216eaa7b7de0db692f12c234f7ef888cc14980ef40d1d2/attrs-19.1.0-py2.py3-none-any.whl
  Saved ./package/attrs-19.1.0-py2.py3-none-any.whl
Collecting Babel==2.6.0 (from -r requirement.txt (line 5))
  Using cached https://files.pythonhosted.org/packages/b8/ad/c6f60602d3ee3d92fbed87675b6fb6a6f9a38c223343ababdb44ba201f10/Babel-2.6.0-py2.py3-none-any.whl
  Saved ./package/Babel-2.6.0-py2.py3-none-any.whl
Collecting backports-abc==0.5 (from -r requirement.txt (line 6))
  Using cached https://files.pythonhosted.org/packages/7d/56/6f3ac1b816d0cd8994e83d0c4e55bc64567532f7dc543378bd87f81cebc7/backports_abc-0.5-py2.py3-none-any.whl
  Saved ./package/backports_abc-0.5-py2.py3-none-any.whl
Collecting billiard==3.6.0.0 (from -r requirement.txt (line 7))
  Using cached https://files.pythonhosted.org/packages/3c/a0/5a01bed569cf1af8fcdd4294590acb980a2788d1594f4ccd678b6fea8644/billiard-3.6.0.0.tar.gz
  Saved ./package/billiard-3.6.0.0.tar.gz
Collecting bleach==3.1.0 (from -r requirement.txt (line 8))
  Using cached https://files.pythonhosted.org/packages/ab/05/27e1466475e816d3001efb6e0a85a819be17411420494a1e602c36f8299d/bleach-3.1.0-py2.py3-none-any.whl
  Saved ./package/bleach-3.1.0-py2.py3-none-any.whl
Collecting boto3==1.4.7 (from -r requirement.txt (line 9))
  Using cached https://files.pythonhosted.org/packages/e0/7c/ed4ddcaa65dadba5992fba71b0cd221181f189dd87ac975d25d33c190a61/boto3-1.4.7-py2.py3-none-any.whl
  Saved ./package/boto3-1.4.7-py2.py3-none-any.whl
Collecting botocore==1.7.48 (from -r requirement.txt (line 10))
  Using cached https://files.pythonhosted.org/packages/78/07/88ef02fca320ff8f61a5c8f46739f72e715f8745c9ddbf59fc5dba43db1a/botocore-1.7.48-py2.py3-none-any.whl
  Saved ./package/botocore-1.7.48-py2.py3-none-any.whl
Collecting cchardet==2.1.4 (from -r requirement.txt (line 11))
  Using cached https://files.pythonhosted.org/packages/cd/ee/b1320c92200558a03656964c4d2eac4d99441e7e8ab8ce9b884dc2c4643f/cchardet-2.1.4-cp27-cp27mu-manylinux1_x86_64.whl
  Saved ./package/cchardet-2.1.4-cp27-cp27mu-manylinux1_x86_64.whl
Collecting celery==4.3.0 (from -r requirement.txt (line 12))
  Using cached https://files.pythonhosted.org/packages/5c/a1/a3dd9d8bfa09156ec2cba37f90accf35c0f4ecc3980d96cb4fb99e56504b/celery-4.3.0-py2.py3-none-any.whl
  Saved ./package/celery-4.3.0-py2.py3-none-any.whl
Collecting certifi==2019.3.9 (from -r requirement.txt (line 13))
  Using cached https://files.pythonhosted.org/packages/60/75/f692a584e85b7eaba0e03827b3d51f45f571c2e793dd731e598828d380aa/certifi-2019.3.9-py2.py3-none-any.whl
  Saved ./package/certifi-2019.3.9-py2.py3-none-any.whl
Collecting cffi==1.12.3 (from -r requirement.txt (line 14))
  Using cached https://files.pythonhosted.org/packages/8d/e9/0c8afd1579e5cf7bc0f06fbcd7cdb954cbc0baadd505973949a99337da1c/cffi-1.12.3-cp27-cp27mu-manylinux1_x86_64.whl
  Saved ./package/cffi-1.12.3-cp27-cp27mu-manylinux1_x86_64.whl
Collecting chardet==3.0.4 (from -r requirement.txt (line 15))
  Using cached https://files.pythonhosted.org/packages/bc/a9/01ffebfb562e4274b6487b4bb1ddec7ca55ec7510b22e4c51f14098443b8/chardet-3.0.4-py2.py3-none-any.whl
  Saved ./package/chardet-3.0.4-py2.py3-none-any.whl
Collecting click==6.7 (from -r requirement.txt (line 16))
  Downloading https://files.pythonhosted.org/packages/34/c1/8806f99713ddb993c5366c362b2f908f18269f8d792aff1abfd700775a77/click-6.7-py2.py3-none-any.whl (71kB)
     |████████████████████████████████| 71kB 140kB/s 
  Saved ./package/click-6.7-py2.py3-none-any.whl
Collecting colorama==0.3.9 (from -r requirement.txt (line 17))
  Downloading https://files.pythonhosted.org/packages/db/c8/7dcf9dbcb22429512708fe3a547f8b6101c0d02137acbd892505aee57adf/colorama-0.3.9-py2.py3-none-any.whl
  Saved ./package/colorama-0.3.9-py2.py3-none-any.whl
Collecting contextlib2==0.5.5 (from -r requirement.txt (line 18))
  Using cached https://files.pythonhosted.org/packages/a2/71/8273a7eeed0aff6a854237ab5453bc9aa67deb49df4832801c21f0ff3782/contextlib2-0.5.5-py2.py3-none-any.whl
  Saved ./package/contextlib2-0.5.5-py2.py3-none-any.whl
Collecting cryptography==2.6.1 (from -r requirement.txt (line 19))
  Using cached https://files.pythonhosted.org/packages/c3/c1/cf8665c955c9393e9ff0872ba6cd3dc6f46ef915e94afcf6e0410508ca69/cryptography-2.6.1-cp27-cp27mu-manylinux1_x86_64.whl
  Saved ./package/cryptography-2.6.1-cp27-cp27mu-manylinux1_x86_64.whl
Collecting docutils==0.14 (from -r requirement.txt (line 20))
  Using cached https://files.pythonhosted.org/packages/50/09/c53398e0005b11f7ffb27b7aa720c617aba53be4fb4f4f3f06b9b5c60f28/docutils-0.14-py2-none-any.whl
  Saved ./package/docutils-0.14-py2-none-any.whl
Collecting enum34==1.1.6 (from -r requirement.txt (line 21))
  Using cached https://files.pythonhosted.org/packages/c5/db/e56e6b4bbac7c4a06de1c50de6fe1ef3810018ae11732a50f15f62c7d050/enum34-1.1.6-py2-none-any.whl
  Saved ./package/enum34-1.1.6-py2-none-any.whl
Collecting et-xmlfile==1.0.1 (from -r requirement.txt (line 22))
  Using cached https://files.pythonhosted.org/packages/22/28/a99c42aea746e18382ad9fb36f64c1c1f04216f41797f2f0fa567da11388/et_xmlfile-1.0.1.tar.gz
  Saved ./package/et_xmlfile-1.0.1.tar.gz
Collecting Flask==0.12.4 (from -r requirement.txt (line 23))
  Using cached https://files.pythonhosted.org/packages/2e/48/f1936dadac2326b3d73f2fe0a964a87d16be16eb9d7fc56f09c1bea3d17c/Flask-0.12.4-py2.py3-none-any.whl
  Saved ./package/Flask-0.12.4-py2.py3-none-any.whl
Collecting Flask-AppBuilder==1.10.0 (from -r requirement.txt (line 24))
  Using cached https://files.pythonhosted.org/packages/54/80/a50e047f35ed6f2832bd9257a788d9948390c3ea0a9bc6955feb3e285123/Flask-AppBuilder-1.10.0.tar.gz
  Saved ./package/Flask-AppBuilder-1.10.0.tar.gz
Collecting Flask-Babel==0.11.1 (from -r requirement.txt (line 25))
  Using cached https://files.pythonhosted.org/packages/47/96/6013d4091fb4238e27e918aec4929f082942fa8c9489ae3aad2f18de4b5b/Flask-Babel-0.11.1.tar.gz
  Saved ./package/Flask-Babel-0.11.1.tar.gz
Collecting Flask-Caching==1.7.1 (from -r requirement.txt (line 26))
  Using cached https://files.pythonhosted.org/packages/9d/0c/20dd6bf0ec56e0b324d578e77e34a13ffaac8988c6d13e70543974bf5c58/Flask_Caching-1.7.1-py2.py3-none-any.whl
  Saved ./package/Flask_Caching-1.7.1-py2.py3-none-any.whl
Collecting Flask-Compress==1.4.0 (from -r requirement.txt (line 27))
  Using cached https://files.pythonhosted.org/packages/0e/2a/378bd072928f6d92fd8c417d66b00c757dc361c0405a46a0134de6fd323d/Flask-Compress-1.4.0.tar.gz
  Saved ./package/Flask-Compress-1.4.0.tar.gz
Collecting Flask-Login==0.2.11 (from -r requirement.txt (line 28))
  Using cached https://files.pythonhosted.org/packages/42/3c/ead3f50b8a39b6dd3499ae6f0f5b13b955130c92a7479a287e2e07921faf/Flask-Login-0.2.11.tar.gz
  Saved ./package/Flask-Login-0.2.11.tar.gz
Collecting Flask-Migrate==2.4.0 (from -r requirement.txt (line 29))
  Using cached https://files.pythonhosted.org/packages/07/6a/53695aab4c7cf7b230e46a5e4f06e0c9719c01a51223590fd75804439a01/Flask_Migrate-2.4.0-py2.py3-none-any.whl
  Saved ./package/Flask_Migrate-2.4.0-py2.py3-none-any.whl
Collecting Flask-OpenID==1.2.5 (from -r requirement.txt (line 30))
  Using cached https://files.pythonhosted.org/packages/d1/a2/9d1fba3287a65f81b9d1c09c4f7cb16f8ea4988b1bc97ffea0d60983338f/Flask-OpenID-1.2.5.tar.gz
  Saved ./package/Flask-OpenID-1.2.5.tar.gz
Collecting Flask-Script==2.0.6 (from -r requirement.txt (line 31))
  Using cached https://files.pythonhosted.org/packages/00/a4/cd587b2b19f043b65bf33ceda2f6e4e6cdbd0ce18d01a52b9559781b1da6/Flask-Script-2.0.6.tar.gz
  Saved ./package/Flask-Script-2.0.6.tar.gz
Collecting Flask-SQLAlchemy==2.1 (from -r requirement.txt (line 32))
  Using cached https://files.pythonhosted.org/packages/b3/52/227aaf4e8cebb153e239c518a9e916590b2fe0e4350e6b02d92b546b69b7/Flask-SQLAlchemy-2.1.tar.gz
  Saved ./package/Flask-SQLAlchemy-2.1.tar.gz
Collecting Flask-Testing==0.7.1 (from -r requirement.txt (line 33))
  Using cached https://files.pythonhosted.org/packages/04/78/c8cd18b08f2f1ca3eaea56a3f2f53bc0d146f7c8faed8c64a93bc09e586a/Flask-Testing-0.7.1.tar.gz
  Saved ./package/Flask-Testing-0.7.1.tar.gz
Collecting Flask-WTF==0.14.2 (from -r requirement.txt (line 34))
  Using cached https://files.pythonhosted.org/packages/60/3a/58c629472d10539ae5167dc7c1fecfa95dd7d0b7864623931e3776438a24/Flask_WTF-0.14.2-py2.py3-none-any.whl
  Saved ./package/Flask_WTF-0.14.2-py2.py3-none-any.whl
Collecting flower==0.9.3 (from -r requirement.txt (line 35))
  Using cached https://files.pythonhosted.org/packages/36/15/ed670b1f1fe14727f1564c9d98d7a917352ce8a0d88e87256be3c1e1190e/flower-0.9.3.tar.gz
  Saved ./package/flower-0.9.3.tar.gz
Collecting functools32==3.2.3.post2 (from -r requirement.txt (line 36))
  Using cached https://files.pythonhosted.org/packages/c5/60/6ac26ad05857c601308d8fb9e87fa36d0ebf889423f47c3502ef034365db/functools32-3.2.3-2.tar.gz
  Saved ./package/functools32-3.2.3-2.tar.gz
Collecting future==0.16.0 (from -r requirement.txt (line 37))
  Using cached https://files.pythonhosted.org/packages/00/2b/8d082ddfed935f3608cc61140df6dcbf0edea1bc3ab52fb6c29ae3e81e85/future-0.16.0.tar.gz
  Saved ./package/future-0.16.0.tar.gz
Collecting futures==3.2.0 (from -r requirement.txt (line 38))
  Using cached https://files.pythonhosted.org/packages/2d/99/b2c4e9d5a30f6471e410a146232b4118e697fa3ffc06d6a65efde84debd0/futures-3.2.0-py2-none-any.whl
  Saved ./package/futures-3.2.0-py2-none-any.whl
Collecting geographiclib==1.49 (from -r requirement.txt (line 39))
  Using cached https://files.pythonhosted.org/packages/5b/ac/4f348828091490d77899bc74e92238e2b55c59392f21948f296e94e50e2b/geographiclib-1.49.tar.gz
  Saved ./package/geographiclib-1.49.tar.gz
Collecting geopy==1.19.0 (from -r requirement.txt (line 40))
  Using cached https://files.pythonhosted.org/packages/75/3e/80bc987e1635ba9e7455b95e233b296c17f3d3bf3d4760fa67cdfc840e84/geopy-1.19.0-py2.py3-none-any.whl
  Saved ./package/geopy-1.19.0-py2.py3-none-any.whl
Collecting gunicorn==19.9.0 (from -r requirement.txt (line 41))
  Using cached https://files.pythonhosted.org/packages/8c/da/b8dd8deb741bff556db53902d4706774c8e1e67265f69528c14c003644e6/gunicorn-19.9.0-py2.py3-none-any.whl
  Saved ./package/gunicorn-19.9.0-py2.py3-none-any.whl
Collecting humanize==0.5.1 (from -r requirement.txt (line 42))
  Using cached https://files.pythonhosted.org/packages/8c/e0/e512e4ac6d091fc990bbe13f9e0378f34cf6eecd1c6c268c9e598dcf5bb9/humanize-0.5.1.tar.gz
  Saved ./package/humanize-0.5.1.tar.gz
Collecting idna==2.8 (from -r requirement.txt (line 43))
  Using cached https://files.pythonhosted.org/packages/14/2c/cd551d81dbe15200be1cf41cd03869a46fe7226e7450af7a6545bfc474c9/idna-2.8-py2.py3-none-any.whl
  Saved ./package/idna-2.8-py2.py3-none-any.whl
Collecting ijson==2.3 (from -r requirement.txt (line 44))
  Using cached https://files.pythonhosted.org/packages/7f/e9/8508c5f4987ba238a2b169e582c1f70a47272b22a2f1fb06b9318201bb9e/ijson-2.3-py2.py3-none-any.whl
  Saved ./package/ijson-2.3-py2.py3-none-any.whl
Collecting ipaddress==1.0.22 (from -r requirement.txt (line 45))
  Using cached https://files.pythonhosted.org/packages/fc/d0/7fc3a811e011d4b388be48a0e381db8d990042df54aa4ef4599a31d39853/ipaddress-1.0.22-py2.py3-none-any.whl
  Saved ./package/ipaddress-1.0.22-py2.py3-none-any.whl
Collecting isodate==0.6.0 (from -r requirement.txt (line 46))
  Using cached https://files.pythonhosted.org/packages/9b/9f/b36f7774ff5ea8e428fdcfc4bb332c39ee5b9362ddd3d40d9516a55221b2/isodate-0.6.0-py2.py3-none-any.whl
  Saved ./package/isodate-0.6.0-py2.py3-none-any.whl
Collecting itsdangerous==1.1.0 (from -r requirement.txt (line 47))
  Using cached https://files.pythonhosted.org/packages/76/ae/44b03b253d6fade317f32c24d100b3b35c2239807046a4c953c7b89fa49e/itsdangerous-1.1.0-py2.py3-none-any.whl
  Saved ./package/itsdangerous-1.1.0-py2.py3-none-any.whl
Collecting jdcal==1.4.1 (from -r requirement.txt (line 48))
  Using cached https://files.pythonhosted.org/packages/f0/da/572cbc0bc582390480bbd7c4e93d14dc46079778ed915b505dc494b37c57/jdcal-1.4.1-py2.py3-none-any.whl
  Saved ./package/jdcal-1.4.1-py2.py3-none-any.whl
Collecting Jinja2==2.10.1 (from -r requirement.txt (line 49))
  Using cached https://files.pythonhosted.org/packages/1d/e7/fd8b501e7a6dfe492a433deb7b9d833d39ca74916fa8bc63dd1a4947a671/Jinja2-2.10.1-py2.py3-none-any.whl
  Saved ./package/Jinja2-2.10.1-py2.py3-none-any.whl
Collecting jmespath==0.9.4 (from -r requirement.txt (line 50))
  Using cached https://files.pythonhosted.org/packages/83/94/7179c3832a6d45b266ddb2aac329e101367fbdb11f425f13771d27f225bb/jmespath-0.9.4-py2.py3-none-any.whl
  Saved ./package/jmespath-0.9.4-py2.py3-none-any.whl
Collecting jsonlines==1.2.0 (from -r requirement.txt (line 51))
  Using cached https://files.pythonhosted.org/packages/4f/9a/ab96291470e305504aa4b7a2e0ec132e930da89eb3ca7a82fbe03167c131/jsonlines-1.2.0-py2.py3-none-any.whl
  Saved ./package/jsonlines-1.2.0-py2.py3-none-any.whl
Collecting jsonschema==3.0.1 (from -r requirement.txt (line 52))
  Using cached https://files.pythonhosted.org/packages/aa/69/df679dfbdd051568b53c38ec8152a3ab6bc533434fc7ed11ab034bf5e82f/jsonschema-3.0.1-py2.py3-none-any.whl
  Saved ./package/jsonschema-3.0.1-py2.py3-none-any.whl
Collecting kombu==4.5.0 (from -r requirement.txt (line 53))
  Using cached https://files.pythonhosted.org/packages/b7/af/1914e93314f1b98756d5c5e366193124a0ffaab0e6d0e51e0f6f65fa851d/kombu-4.5.0-py2.py3-none-any.whl
  Saved ./package/kombu-4.5.0-py2.py3-none-any.whl
Collecting linear-tsv==1.1.0 (from -r requirement.txt (line 54))
  Using cached https://files.pythonhosted.org/packages/82/e5/03207a0f11e1d60df85b97b61704ed701b725a7c2feaf83f7bfbd0c2d83e/linear-tsv-1.1.0.tar.gz
  Saved ./package/linear-tsv-1.1.0.tar.gz
Collecting Mako==1.0.10 (from -r requirement.txt (line 55))
  Using cached https://files.pythonhosted.org/packages/f9/93/63f78c552e4397549499169198698de23b559b52e57f27d967690811d16d/Mako-1.0.10.tar.gz
  Saved ./package/Mako-1.0.10.tar.gz
Collecting Markdown==2.6.11 (from -r requirement.txt (line 56))
  Using cached https://files.pythonhosted.org/packages/6d/7d/488b90f470b96531a3f5788cf12a93332f543dbab13c423a5e7ce96a0493/Markdown-2.6.11-py2.py3-none-any.whl
  Saved ./package/Markdown-2.6.11-py2.py3-none-any.whl
Collecting MarkupSafe==1.1.1 (from -r requirement.txt (line 57))
  Using cached https://files.pythonhosted.org/packages/fb/40/f3adb7cf24a8012813c5edb20329eb22d5d8e2a0ecf73d21d6b85865da11/MarkupSafe-1.1.1-cp27-cp27mu-manylinux1_x86_64.whl
  Saved ./package/MarkupSafe-1.1.1-cp27-cp27mu-manylinux1_x86_64.whl
Collecting numpy==1.16.3 (from -r requirement.txt (line 58))
  Using cached https://files.pythonhosted.org/packages/e1/72/179a78b565ecf01fe98dab6417581d30acac15c2d93c49f93169ebea99b1/numpy-1.16.3-cp27-cp27mu-manylinux1_x86_64.whl
  Saved ./package/numpy-1.16.3-cp27-cp27mu-manylinux1_x86_64.whl
Collecting openpyxl==2.4.11 (from -r requirement.txt (line 59))
  Using cached https://files.pythonhosted.org/packages/77/26/0bd1a39776f53b4f28e5bb1d26b3fcd99068584a7e1ddca4e09c0d5fd592/openpyxl-2.4.11.tar.gz
  Saved ./package/openpyxl-2.4.11.tar.gz
Collecting pandas==0.23.4 (from -r requirement.txt (line 60))
  Using cached https://files.pythonhosted.org/packages/b7/e3/f52d484244105fa3d558ce8217a5190cd3d40536076bef66d92d01566325/pandas-0.23.4-cp27-cp27mu-manylinux1_x86_64.whl
  Saved ./package/pandas-0.23.4-cp27-cp27mu-manylinux1_x86_64.whl
Collecting parsedatetime==2.4 (from -r requirement.txt (line 61))
  Using cached https://files.pythonhosted.org/packages/1d/48/ac8d4c6239437592852e951bcb9438dc585f80c29777c391aef69c67dc79/parsedatetime-2.4-py2-none-any.whl
  Saved ./package/parsedatetime-2.4-py2-none-any.whl
Collecting pathlib2==2.3.3 (from -r requirement.txt (line 62))
  Using cached https://files.pythonhosted.org/packages/2a/46/c696dcf1c7aad917b39b875acdc5451975e3a9b4890dca8329983201c97a/pathlib2-2.3.3-py2.py3-none-any.whl
  Saved ./package/pathlib2-2.3.3-py2.py3-none-any.whl
Collecting polyline==1.3.2 (from -r requirement.txt (line 63))
  Using cached https://files.pythonhosted.org/packages/c1/d0/58a19ca3fbe880145d200518fcd97d176cae07b9677db330f4881954d5f5/polyline-1.3.2-py2.py3-none-any.whl
  Saved ./package/polyline-1.3.2-py2.py3-none-any.whl
Collecting pycparser==2.19 (from -r requirement.txt (line 64))
  Using cached https://files.pythonhosted.org/packages/68/9e/49196946aee219aead1290e00d1e7fdeab8567783e83e1b9ab5585e6206a/pycparser-2.19.tar.gz
  Saved ./package/pycparser-2.19.tar.gz
Collecting pydruid==0.5.2 (from -r requirement.txt (line 65))
  Using cached https://files.pythonhosted.org/packages/11/78/9a7e5fbb8f1009c877452b6629e4c738a40ef4ffb0e320c25bdb263a90c7/pydruid-0.5.2.tar.gz
  Saved ./package/pydruid-0.5.2.tar.gz
Collecting PyHive==0.6.1 (from -r requirement.txt (line 66))
  Using cached https://files.pythonhosted.org/packages/4e/26/de91125c0d9e8947d48f387f4d1f2e7a22aa92a30771ad02f63a5653361b/PyHive-0.6.1.tar.gz
  Saved ./package/PyHive-0.6.1.tar.gz
Collecting PyMySQL==0.9.3 (from -r requirement.txt (line 67))
  Using cached https://files.pythonhosted.org/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl
  Saved ./package/PyMySQL-0.9.3-py2.py3-none-any.whl
Collecting pyrsistent==0.15.2 (from -r requirement.txt (line 68))
  Using cached https://files.pythonhosted.org/packages/68/0b/f514e76b4e074386b60cfc6c8c2d75ca615b81e415417ccf3fac80ae0bf6/pyrsistent-0.15.2.tar.gz
  Saved ./package/pyrsistent-0.15.2.tar.gz
Collecting python-dateutil==2.8.0 (from -r requirement.txt (line 69))
  Using cached https://files.pythonhosted.org/packages/41/17/c62faccbfbd163c7f57f3844689e3a78bae1f403648a6afb1d0866d87fbb/python_dateutil-2.8.0-py2.py3-none-any.whl
  Saved ./package/python_dateutil-2.8.0-py2.py3-none-any.whl
Collecting python-editor==1.0.4 (from -r requirement.txt (line 70))
  Using cached https://files.pythonhosted.org/packages/55/a0/3c0ba1c10f2ca381645dd46cb7afbb73fddc8de9f957e1f9e726a846eabc/python_editor-1.0.4-py2-none-any.whl
  Saved ./package/python_editor-1.0.4-py2-none-any.whl
Collecting python-geohash==0.8.5 (from -r requirement.txt (line 71))
  Using cached https://files.pythonhosted.org/packages/9c/e2/1a3507af7c8f91f8a4975d651d4aeb6a846dfdf74713954186ade4205850/python-geohash-0.8.5.tar.gz
  Saved ./package/python-geohash-0.8.5.tar.gz
Collecting python-openid==2.2.5 (from -r requirement.txt (line 72))
  Using cached https://files.pythonhosted.org/packages/7b/8a/e94d18c666073280b8c0614b7e38cfaf0b129989e42f4ca713942b862f0a/python-openid-2.2.5.tar.gz
  Saved ./package/python-openid-2.2.5.tar.gz
Collecting pytz==2019.1 (from -r requirement.txt (line 73))
  Using cached https://files.pythonhosted.org/packages/3d/73/fe30c2daaaa0713420d0382b16fbb761409f532c56bdcc514bf7b6262bb6/pytz-2019.1-py2.py3-none-any.whl
  Saved ./package/pytz-2019.1-py2.py3-none-any.whl
Collecting PyYAML==5.1 (from -r requirement.txt (line 74))
  Using cached https://files.pythonhosted.org/packages/9f/2c/9417b5c774792634834e730932745bc09a7d36754ca00acf1ccd1ac2594d/PyYAML-5.1.tar.gz
  Saved ./package/PyYAML-5.1.tar.gz
Collecting requests==2.21.0 (from -r requirement.txt (line 75))
  Using cached https://files.pythonhosted.org/packages/7d/e3/20f3d364d6c8e5d2353c72a67778eb189176f08e873c9900e10c0287b84b/requests-2.21.0-py2.py3-none-any.whl
  Saved ./package/requests-2.21.0-py2.py3-none-any.whl
Collecting rfc3986==1.3.1 (from -r requirement.txt (line 76))
  Using cached https://files.pythonhosted.org/packages/a8/1e/648eed6ea17d1de1585c7a534e765104818eaa16c74ff6cfd3951caeefee/rfc3986-1.3.1-py2.py3-none-any.whl
  Saved ./package/rfc3986-1.3.1-py2.py3-none-any.whl
Collecting s3transfer==0.1.13 (from -r requirement.txt (line 77))
  Using cached https://files.pythonhosted.org/packages/d7/14/2a0004d487464d120c9fb85313a75cd3d71a7506955be458eebfe19a6b1d/s3transfer-0.1.13-py2.py3-none-any.whl
  Saved ./package/s3transfer-0.1.13-py2.py3-none-any.whl
Collecting sasl==0.2.1 (from -r requirement.txt (line 78))
  Using cached https://files.pythonhosted.org/packages/8e/2c/45dae93d666aea8492678499e0999269b4e55f1829b1e4de5b8204706ad9/sasl-0.2.1.tar.gz
  Saved ./package/sasl-0.2.1.tar.gz
Collecting scandir==1.10.0 (from -r requirement.txt (line 79))
  Using cached https://files.pythonhosted.org/packages/df/f5/9c052db7bd54d0cbf1bc0bb6554362bba1012d03e5888950a4f5c5dadc4e/scandir-1.10.0.tar.gz
  Saved ./package/scandir-1.10.0.tar.gz
Collecting simplejson==3.16.0 (from -r requirement.txt (line 80))
  Using cached https://files.pythonhosted.org/packages/e3/24/c35fb1c1c315fc0fffe61ea00d3f88e85469004713dab488dee4f35b0aff/simplejson-3.16.0.tar.gz
  Saved ./package/simplejson-3.16.0.tar.gz
Collecting singledispatch==3.4.0.3 (from -r requirement.txt (line 81))
  Using cached https://files.pythonhosted.org/packages/c5/10/369f50bcd4621b263927b0a1519987a04383d4a98fb10438042ad410cf88/singledispatch-3.4.0.3-py2.py3-none-any.whl
  Saved ./package/singledispatch-3.4.0.3-py2.py3-none-any.whl
Collecting six==1.12.0 (from -r requirement.txt (line 82))
  Using cached https://files.pythonhosted.org/packages/73/fb/00a976f728d0d1fecfe898238ce23f502a721c0ac0ecfedb80e0d88c64e9/six-1.12.0-py2.py3-none-any.whl
  Saved ./package/six-1.12.0-py2.py3-none-any.whl
Collecting SQLAlchemy==1.3.3 (from -r requirement.txt (line 83))
  Using cached https://files.pythonhosted.org/packages/2b/b2/e6f5c5efc68942edefaa924e8fbea0b32375baa434a511cbf6bb17769cf6/SQLAlchemy-1.3.3.tar.gz
  Saved ./package/SQLAlchemy-1.3.3.tar.gz
Collecting SQLAlchemy-Utils==0.33.11 (from -r requirement.txt (line 84))
  Using cached https://files.pythonhosted.org/packages/fe/8b/a68f81076e9a2729675253228f43986914f0510078c86f14f6cd51dd3f01/SQLAlchemy-Utils-0.33.11.tar.gz
  Saved ./package/SQLAlchemy-Utils-0.33.11.tar.gz
Collecting sqlparse==0.3.0 (from -r requirement.txt (line 85))
  Using cached https://files.pythonhosted.org/packages/ef/53/900f7d2a54557c6a37886585a91336520e5539e3ae2423ff1102daf4f3a7/sqlparse-0.3.0-py2.py3-none-any.whl
  Saved ./package/sqlparse-0.3.0-py2.py3-none-any.whl
Collecting superset==0.27.0 (from -r requirement.txt (line 86))
  Using cached https://files.pythonhosted.org/packages/e9/28/6a2a3317650b441990799312538b803dcfcb8dd6d2ee2489dfc928bd5ff9/superset-0.27.0.tar.gz
  Saved ./package/superset-0.27.0.tar.gz
Collecting tableschema==1.4.1 (from -r requirement.txt (line 87))
  Using cached https://files.pythonhosted.org/packages/7e/64/412d92b24caa0cf2a4e95105995839f5d7ec9c0f613709bd01d70af289e6/tableschema-1.4.1-py2.py3-none-any.whl
  Saved ./package/tableschema-1.4.1-py2.py3-none-any.whl
Collecting tabulator==1.20.0 (from -r requirement.txt (line 88))
  Using cached https://files.pythonhosted.org/packages/58/bd/54f9dbf9f82f36f1e1c727ca697e679cb9c601d49f8c2733910cb6f15f77/tabulator-1.20.0-py2.py3-none-any.whl
  Saved ./package/tabulator-1.20.0-py2.py3-none-any.whl
Collecting thrift==0.11.0 (from -r requirement.txt (line 89))
  Using cached https://files.pythonhosted.org/packages/c6/b4/510617906f8e0c5660e7d96fbc5585113f83ad547a3989b80297ac72a74c/thrift-0.11.0.tar.gz
  Saved ./package/thrift-0.11.0.tar.gz
Collecting thrift-sasl==0.3.0 (from -r requirement.txt (line 90))
  Using cached https://files.pythonhosted.org/packages/50/fe/89cbc910809e3757c762f56ee190ca39e0f28b7ea451835232c0c988d706/thrift_sasl-0.3.0.tar.gz
  Saved ./package/thrift_sasl-0.3.0.tar.gz
Collecting tornado==5.1.1 (from -r requirement.txt (line 91))
  Using cached https://files.pythonhosted.org/packages/e6/78/6e7b5af12c12bdf38ca9bfe863fcaf53dc10430a312d0324e76c1e5ca426/tornado-5.1.1.tar.gz
  Saved ./package/tornado-5.1.1.tar.gz
Collecting unicodecsv==0.14.1 (from -r requirement.txt (line 92))
  Using cached https://files.pythonhosted.org/packages/6f/a4/691ab63b17505a26096608cc309960b5a6bdf39e4ba1a793d5f9b1a53270/unicodecsv-0.14.1.tar.gz
  Saved ./package/unicodecsv-0.14.1.tar.gz
Collecting Unidecode==1.0.23 (from -r requirement.txt (line 93))
  Using cached https://files.pythonhosted.org/packages/31/39/53096f9217b057cb049fe872b7fc7ce799a1a89b76cf917d9639e7a558b5/Unidecode-1.0.23-py2.py3-none-any.whl
  Saved ./package/Unidecode-1.0.23-py2.py3-none-any.whl
Collecting urllib3==1.24.3 (from -r requirement.txt (line 94))
  Using cached https://files.pythonhosted.org/packages/01/11/525b02e4acc0c747de8b6ccdab376331597c569c42ea66ab0a1dbd36eca2/urllib3-1.24.3-py2.py3-none-any.whl
  Saved ./package/urllib3-1.24.3-py2.py3-none-any.whl
Collecting vine==1.3.0 (from -r requirement.txt (line 95))
  Using cached https://files.pythonhosted.org/packages/7f/60/82c03047396126c8331ceb64da1dc52d4f1317209f32e8fe286d0c07365a/vine-1.3.0-py2.py3-none-any.whl
  Saved ./package/vine-1.3.0-py2.py3-none-any.whl
Collecting webencodings==0.5.1 (from -r requirement.txt (line 96))
  Using cached https://files.pythonhosted.org/packages/f4/24/2a3e3df732393fed8b3ebf2ec078f05546de641fe1b667ee316ec1dcf3b7/webencodings-0.5.1-py2.py3-none-any.whl
  Saved ./package/webencodings-0.5.1-py2.py3-none-any.whl
Collecting Werkzeug==0.15.2 (from -r requirement.txt (line 97))
  Using cached https://files.pythonhosted.org/packages/18/79/84f02539cc181cdbf5ff5a41b9f52cae870b6f632767e43ba6ac70132e92/Werkzeug-0.15.2-py2.py3-none-any.whl
  Saved ./package/Werkzeug-0.15.2-py2.py3-none-any.whl
Collecting WTForms==2.2.1 (from -r requirement.txt (line 98))
  Using cached https://files.pythonhosted.org/packages/9f/c8/dac5dce9908df1d9d48ec0e26e2a250839fa36ea2c602cc4f85ccfeb5c65/WTForms-2.2.1-py2.py3-none-any.whl
  Saved ./package/WTForms-2.2.1-py2.py3-none-any.whl
Collecting xlrd==1.2.0 (from -r requirement.txt (line 99))
  Using cached https://files.pythonhosted.org/packages/b0/16/63576a1a001752e34bf8ea62e367997530dc553b689356b9879339cf45a4/xlrd-1.2.0-py2.py3-none-any.whl
  Saved ./package/xlrd-1.2.0-py2.py3-none-any.whl
Collecting setuptools (from jsonschema==3.0.1->-r requirement.txt (line 52))
  Downloading https://files.pythonhosted.org/packages/ec/51/f45cea425fd5cb0b0380f5b0f048ebc1da5b417e48d304838c02d6288a1e/setuptools-41.0.1-py2.py3-none-any.whl (575kB)
     |████████████████████████████████| 583kB 21kB/s 
  Saved ./package/setuptools-41.0.1-py2.py3-none-any.whl
Successfully downloaded alembic amqp asn1crypto attrs Babel backports-abc billiard bleach boto3 botocore cchardet celery certifi cffi chardet click colorama contextlib2 cryptography docutils enum34 et-xmlfile Flask Flask-AppBuilder Flask-Babel Flask-Caching Flask-Compress Flask-Login Flask-Migrate Flask-OpenID Flask-Script Flask-SQLAlchemy Flask-Testing Flask-WTF flower functools32 future futures geographiclib geopy gunicorn humanize idna ijson ipaddress isodate itsdangerous jdcal Jinja2 jmespath jsonlines jsonschema kombu linear-tsv Mako Markdown MarkupSafe numpy openpyxl pandas parsedatetime pathlib2 polyline pycparser pydruid PyHive PyMySQL pyrsistent python-dateutil python-editor python-geohash python-openid pytz PyYAML requests rfc3986 s3transfer sasl scandir simplejson singledispatch six SQLAlchemy SQLAlchemy-Utils sqlparse superset tableschema tabulator thrift thrift-sasl tornado unicodecsv Unidecode urllib3 vine webencodings Werkzeug WTForms xlrd setuptools

DOWNLOAD

pip download superset==0.27.0

http://vault.centos.org

ERROR

a).Click & colorama

ERROR: flask-appbuilder 1.10.0 has requirement click==6.7, but you'll have click 7.0 which is incompatible.
ERROR: flask-appbuilder 1.10.0 has requirement colorama==0.3.9, but you'll have colorama 0.4.1 which is incompatible.
pip freeze > requirement.txt
vi requirement.txt 
Click==6.7
colorama==0.3.9
pip install -i https://pypi.doubanio.com/simple --trusted-host pypi.doubanio.com  -r requirement.txt
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Looking in indexes: https://pypi.doubanio.com/simple
Requirement already satisfied: alembic==1.0.10 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 1)) (1.0.10)
Requirement already satisfied: amqp==2.4.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 2)) (2.4.2)
Requirement already satisfied: asn1crypto==0.24.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 3)) (0.24.0)
Requirement already satisfied: attrs==19.1.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 4)) (19.1.0)
Requirement already satisfied: Babel==2.6.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 5)) (2.6.0)
Requirement already satisfied: backports-abc==0.5 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 6)) (0.5)
Requirement already satisfied: billiard==3.6.0.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 7)) (3.6.0.0)
Requirement already satisfied: bleach==3.1.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 8)) (3.1.0)
Requirement already satisfied: boto3==1.4.7 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 9)) (1.4.7)
Requirement already satisfied: botocore==1.7.48 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 10)) (1.7.48)
Requirement already satisfied: cchardet==2.1.4 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 11)) (2.1.4)
Requirement already satisfied: celery==4.3.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 12)) (4.3.0)
Requirement already satisfied: certifi==2019.3.9 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 13)) (2019.3.9)
Requirement already satisfied: cffi==1.12.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 14)) (1.12.3)
Requirement already satisfied: chardet==3.0.4 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 15)) (3.0.4)
Collecting Click==6.7 (from -r requirement.txt (line 16))
  Downloading https://pypi.doubanio.com/packages/34/c1/8806f99713ddb993c5366c362b2f908f18269f8d792aff1abfd700775a77/click-6.7-py2.py3-none-any.whl (71kB)
     |████████████████████████████████| 71kB 20.0MB/s 
Collecting colorama==0.3.9 (from -r requirement.txt (line 17))
  Downloading https://pypi.doubanio.com/packages/db/c8/7dcf9dbcb22429512708fe3a547f8b6101c0d02137acbd892505aee57adf/colorama-0.3.9-py2.py3-none-any.whl
Requirement already satisfied: contextlib2==0.5.5 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 18)) (0.5.5)
Requirement already satisfied: cryptography==2.6.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 19)) (2.6.1)
Requirement already satisfied: docutils==0.14 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 20)) (0.14)
Requirement already satisfied: enum34==1.1.6 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 21)) (1.1.6)
Requirement already satisfied: et-xmlfile==1.0.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 22)) (1.0.1)
Requirement already satisfied: Flask==0.12.4 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 23)) (0.12.4)
Requirement already satisfied: Flask-AppBuilder==1.10.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 24)) (1.10.0)
Requirement already satisfied: Flask-Babel==0.11.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 25)) (0.11.1)
Requirement already satisfied: Flask-Caching==1.7.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 26)) (1.7.1)
Requirement already satisfied: Flask-Compress==1.4.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 27)) (1.4.0)
Requirement already satisfied: Flask-Login==0.2.11 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 28)) (0.2.11)
Requirement already satisfied: Flask-Migrate==2.4.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 29)) (2.4.0)
Requirement already satisfied: Flask-OpenID==1.2.5 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 30)) (1.2.5)
Requirement already satisfied: Flask-Script==2.0.6 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 31)) (2.0.6)
Requirement already satisfied: Flask-SQLAlchemy==2.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 32)) (2.1)
Requirement already satisfied: Flask-Testing==0.7.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 33)) (0.7.1)
Requirement already satisfied: Flask-WTF==0.14.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 34)) (0.14.2)
Requirement already satisfied: flower==0.9.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 35)) (0.9.3)
Requirement already satisfied: functools32==3.2.3.post2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 36)) (3.2.3.post2)
Requirement already satisfied: future==0.16.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 37)) (0.16.0)
Requirement already satisfied: futures==3.2.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 38)) (3.2.0)
Requirement already satisfied: geographiclib==1.49 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 39)) (1.49)
Requirement already satisfied: geopy==1.19.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 40)) (1.19.0)
Requirement already satisfied: gunicorn==19.9.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 41)) (19.9.0)
Requirement already satisfied: humanize==0.5.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 42)) (0.5.1)
Requirement already satisfied: idna==2.8 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 43)) (2.8)
Requirement already satisfied: ijson==2.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 44)) (2.3)
Requirement already satisfied: ipaddress==1.0.22 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 45)) (1.0.22)
Requirement already satisfied: isodate==0.6.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 46)) (0.6.0)
Requirement already satisfied: itsdangerous==1.1.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 47)) (1.1.0)
Requirement already satisfied: jdcal==1.4.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 48)) (1.4.1)
Requirement already satisfied: Jinja2==2.10.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 49)) (2.10.1)
Requirement already satisfied: jmespath==0.9.4 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 50)) (0.9.4)
Requirement already satisfied: jsonlines==1.2.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 51)) (1.2.0)
Requirement already satisfied: jsonschema==3.0.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 52)) (3.0.1)
Requirement already satisfied: kombu==4.5.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 53)) (4.5.0)
Requirement already satisfied: linear-tsv==1.1.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 54)) (1.1.0)
Requirement already satisfied: Mako==1.0.10 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 55)) (1.0.10)
Requirement already satisfied: Markdown==3.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 56)) (3.1)
Requirement already satisfied: MarkupSafe==1.1.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 57)) (1.1.1)
Requirement already satisfied: numpy==1.16.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 58)) (1.16.3)
Requirement already satisfied: openpyxl==2.4.11 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 59)) (2.4.11)
Requirement already satisfied: pandas==0.24.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 60)) (0.24.2)
Requirement already satisfied: parsedatetime==2.4 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 61)) (2.4)
Requirement already satisfied: pathlib2==2.3.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 62)) (2.3.3)
Requirement already satisfied: polyline==1.3.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 63)) (1.3.2)
Requirement already satisfied: pycparser==2.19 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 64)) (2.19)
Requirement already satisfied: pydruid==0.5.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 65)) (0.5.2)
Requirement already satisfied: PyHive==0.6.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 66)) (0.6.1)
Requirement already satisfied: PyMySQL==0.9.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 67)) (0.9.3)
Requirement already satisfied: pyrsistent==0.15.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 68)) (0.15.2)
Requirement already satisfied: python-dateutil==2.8.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 69)) (2.8.0)
Requirement already satisfied: python-editor==1.0.4 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 70)) (1.0.4)
Requirement already satisfied: python-geohash==0.8.5 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 71)) (0.8.5)
Requirement already satisfied: python-openid==2.2.5 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 72)) (2.2.5)
Requirement already satisfied: pytz==2019.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 73)) (2019.1)
Requirement already satisfied: PyYAML==5.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 74)) (5.1)
Requirement already satisfied: requests==2.21.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 75)) (2.21.0)
Requirement already satisfied: rfc3986==1.3.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 76)) (1.3.1)
Requirement already satisfied: s3transfer==0.1.13 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 77)) (0.1.13)
Requirement already satisfied: sasl==0.2.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 78)) (0.2.1)
Requirement already satisfied: scandir==1.10.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 79)) (1.10.0)
Requirement already satisfied: simplejson==3.16.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 80)) (3.16.0)
Requirement already satisfied: singledispatch==3.4.0.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 81)) (3.4.0.3)
Requirement already satisfied: six==1.12.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 82)) (1.12.0)
Requirement already satisfied: SQLAlchemy==1.3.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 83)) (1.3.3)
Requirement already satisfied: SQLAlchemy-Utils==0.33.11 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 84)) (0.33.11)
Requirement already satisfied: sqlparse==0.3.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 85)) (0.3.0)
Requirement already satisfied: superset==0.27.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 86)) (0.27.0)
Requirement already satisfied: tableschema==1.4.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 87)) (1.4.1)
Requirement already satisfied: tabulator==1.20.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 88)) (1.20.0)
Requirement already satisfied: thrift==0.11.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 89)) (0.11.0)
Requirement already satisfied: thrift-sasl==0.3.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 90)) (0.3.0)
Requirement already satisfied: tornado==5.1.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 91)) (5.1.1)
Requirement already satisfied: unicodecsv==0.14.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 92)) (0.14.1)
Requirement already satisfied: Unidecode==1.0.23 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 93)) (1.0.23)
Requirement already satisfied: urllib3==1.24.3 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 94)) (1.24.3)
Requirement already satisfied: vine==1.3.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 95)) (1.3.0)
Requirement already satisfied: webencodings==0.5.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 96)) (0.5.1)
Requirement already satisfied: Werkzeug==0.15.2 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 97)) (0.15.2)
Requirement already satisfied: WTForms==2.2.1 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 98)) (2.2.1)
Requirement already satisfied: xlrd==1.2.0 in /opt/venv/lib/python2.7/site-packages (from -r requirement.txt (line 99)) (1.2.0)
Requirement already satisfied: setuptools in /opt/venv/lib/python2.7/site-packages (from jsonschema==3.0.1->-r requirement.txt (line 52)) (41.0.1)
Installing collected packages: Click, colorama
  Found existing installation: Click 7.0
    Uninstalling Click-7.0:
      Successfully uninstalled Click-7.0
  Found existing installation: colorama 0.4.1
    Uninstalling colorama-0.4.1:
      Successfully uninstalled colorama-0.4.1
Successfully installed Click-6.7 colorama-0.3.9

b).pandas

(venv) [root@localhost bin]# fabmanager create-admin --app superset
Username [admin]: superset
User first name [admin]: superset
User last name [user]: apache
Email [admin@fab.org]: superset@apache.org
Password: 
Repeat for confirmation: 
Was unable to import superset Error: cannot import name _maybe_box_datetimelike
(venv) [root@localhost bin]# pip uninstall pandas
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Uninstalling pandas-0.24.2:
  Would remove:
    /opt/venv/lib/python2.7/site-packages/pandas-0.24.2.dist-info/*
    /opt/venv/lib/python2.7/site-packages/pandas/*
Proceed (y/n)? y
  Successfully uninstalled pandas-0.24.2
(venv) [root@localhost bin]# pip install pandas==0.23.4
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting pandas==0.23.4
  Downloading https://files.pythonhosted.org/packages/b7/e3/f52d484244105fa3d558ce8217a5190cd3d40536076bef66d92d01566325/pandas-0.23.4-cp27-cp27mu-manylinux1_x86_64.whl (8.9MB)
     |████████████████████████████████| 8.9MB 24kB/s 
Requirement already satisfied: pytz>=2011k in /opt/venv/lib/python2.7/site-packages (from pandas==0.23.4) (2019.1)
Requirement already satisfied: numpy>=1.9.0 in /opt/venv/lib/python2.7/site-packages (from pandas==0.23.4) (1.16.3)
Requirement already satisfied: python-dateutil>=2.5.0 in /opt/venv/lib/python2.7/site-packages (from pandas==0.23.4) (2.8.0)
Requirement already satisfied: six>=1.5 in /opt/venv/lib/python2.7/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

c).markdown

(venv) [root@localhost bin]# fabmanager create-admin --app superset
Username [admin]: superset
User first name [admin]: superset
User last name [user]: superset
Email [admin@fab.org]: superset@apache.org
Password: 
Repeat for confirmation: 
Was unable to import superset Error: markdown() takes exactly 1 argument (2 given)
(venv) [root@localhost bin]# pip install "markdown<3.0.0" superset
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting markdown<3.0.0
  Downloading https://files.pythonhosted.org/packages/6d/7d/488b90f470b96531a3f5788cf12a93332f543dbab13c423a5e7ce96a0493/Markdown-2.6.11-py2.py3-none-any.whl (78kB)
     |████████████████████████████████| 81kB 129kB/s 
Requirement already satisfied: superset in /opt/venv/lib/python2.7/site-packages (0.27.0)
Requirement already satisfied: pathlib2 in /opt/venv/lib/python2.7/site-packages (from superset) (2.3.3)
Requirement already satisfied: flask-migrate in /opt/venv/lib/python2.7/site-packages (from superset) (2.4.0)
Requirement already satisfied: six in /opt/venv/lib/python2.7/site-packages (from superset) (1.12.0)
Requirement already satisfied: python-geohash in /opt/venv/lib/python2.7/site-packages (from superset) (0.8.5)
Requirement already satisfied: flask-testing in /opt/venv/lib/python2.7/site-packages (from superset) (0.7.1)
Requirement already satisfied: colorama in /opt/venv/lib/python2.7/site-packages (from superset) (0.3.9)
Requirement already satisfied: pyyaml>=3.11 in /opt/venv/lib/python2.7/site-packages (from superset) (5.1)
Requirement already satisfied: boto3==1.4.7 in /opt/venv/lib/python2.7/site-packages (from superset) (1.4.7)
Requirement already satisfied: contextlib2 in /opt/venv/lib/python2.7/site-packages (from superset) (0.5.5)
Requirement already satisfied: simplejson>=3.15.0 in /opt/venv/lib/python2.7/site-packages (from superset) (3.16.0)
Requirement already satisfied: pyhive>=0.4.0 in /opt/venv/lib/python2.7/site-packages (from superset) (0.6.1)
Requirement already satisfied: pandas in /opt/venv/lib/python2.7/site-packages (from superset) (0.23.4)
Requirement already satisfied: flask-appbuilder==1.10.0 in /opt/venv/lib/python2.7/site-packages (from superset) (1.10.0)
Requirement already satisfied: requests in /opt/venv/lib/python2.7/site-packages (from superset) (2.21.0)
Requirement already satisfied: geopy in /opt/venv/lib/python2.7/site-packages (from superset) (1.19.0)
Requirement already satisfied: flask-compress in /opt/venv/lib/python2.7/site-packages (from superset) (1.4.0)
Requirement already satisfied: gunicorn in /opt/venv/lib/python2.7/site-packages (from superset) (19.9.0)
Requirement already satisfied: sqlalchemy in /opt/venv/lib/python2.7/site-packages (from superset) (1.3.3)
Requirement already satisfied: thrift-sasl>=0.2.1 in /opt/venv/lib/python2.7/site-packages (from superset) (0.3.0)
Requirement already satisfied: flask-script in /opt/venv/lib/python2.7/site-packages (from superset) (2.0.6)
Requirement already satisfied: bleach in /opt/venv/lib/python2.7/site-packages (from superset) (3.1.0)
Requirement already satisfied: polyline in /opt/venv/lib/python2.7/site-packages (from superset) (1.3.2)
Requirement already satisfied: unidecode>=0.04.21 in /opt/venv/lib/python2.7/site-packages (from superset) (1.0.23)
Requirement already satisfied: tableschema in /opt/venv/lib/python2.7/site-packages (from superset) (1.4.1)
Requirement already satisfied: pydruid>=0.4.3 in /opt/venv/lib/python2.7/site-packages (from superset) (0.5.2)
Requirement already satisfied: sqlalchemy-utils in /opt/venv/lib/python2.7/site-packages (from superset) (0.33.11)
Requirement already satisfied: python-dateutil in /opt/venv/lib/python2.7/site-packages (from superset) (2.8.0)
Requirement already satisfied: sqlparse in /opt/venv/lib/python2.7/site-packages (from superset) (0.3.0)
Requirement already satisfied: flask-wtf in /opt/venv/lib/python2.7/site-packages (from superset) (0.14.2)
Requirement already satisfied: flower in /opt/venv/lib/python2.7/site-packages (from superset) (0.9.3)
Requirement already satisfied: future<0.17,>=0.16.0 in /opt/venv/lib/python2.7/site-packages (from superset) (0.16.0)
Requirement already satisfied: flask<1.0.0 in /opt/venv/lib/python2.7/site-packages (from superset) (0.12.4)
Requirement already satisfied: botocore<1.8.0,>=1.7.0 in /opt/venv/lib/python2.7/site-packages (from superset) (1.7.48)
Requirement already satisfied: parsedatetime in /opt/venv/lib/python2.7/site-packages (from superset) (2.4)
Requirement already satisfied: unicodecsv in /opt/venv/lib/python2.7/site-packages (from superset) (0.14.1)
Requirement already satisfied: flask-caching in /opt/venv/lib/python2.7/site-packages (from superset) (1.7.1)
Requirement already satisfied: humanize in /opt/venv/lib/python2.7/site-packages (from superset) (0.5.1)
Requirement already satisfied: idna in /opt/venv/lib/python2.7/site-packages (from superset) (2.8)
Requirement already satisfied: cryptography in /opt/venv/lib/python2.7/site-packages (from superset) (2.6.1)
Requirement already satisfied: celery>=4.2.0 in /opt/venv/lib/python2.7/site-packages (from superset) (4.3.0)
Requirement already satisfied: thrift>=0.9.3 in /opt/venv/lib/python2.7/site-packages (from superset) (0.11.0)
Requirement already satisfied: scandir; python_version < "3.5" in /opt/venv/lib/python2.7/site-packages (from pathlib2->superset) (1.10.0)
Requirement already satisfied: Flask-SQLAlchemy>=1.0 in /opt/venv/lib/python2.7/site-packages (from flask-migrate->superset) (2.1)
Requirement already satisfied: alembic>=0.7 in /opt/venv/lib/python2.7/site-packages (from flask-migrate->superset) (1.0.10)
Requirement already satisfied: jmespath<1.0.0,>=0.7.1 in /opt/venv/lib/python2.7/site-packages (from boto3==1.4.7->superset) (0.9.4)
Requirement already satisfied: s3transfer<0.2.0,>=0.1.10 in /opt/venv/lib/python2.7/site-packages (from boto3==1.4.7->superset) (0.1.13)
Requirement already satisfied: pytz>=2011k in /opt/venv/lib/python2.7/site-packages (from pandas->superset) (2019.1)
Requirement already satisfied: numpy>=1.9.0 in /opt/venv/lib/python2.7/site-packages (from pandas->superset) (1.16.3)
Requirement already satisfied: Flask-OpenID==1.2.5 in /opt/venv/lib/python2.7/site-packages (from flask-appbuilder==1.10.0->superset) (1.2.5)
Requirement already satisfied: Flask-Babel==0.11.1 in /opt/venv/lib/python2.7/site-packages (from flask-appbuilder==1.10.0->superset) (0.11.1)
Requirement already satisfied: click==6.7 in /opt/venv/lib/python2.7/site-packages (from flask-appbuilder==1.10.0->superset) (6.7)
Requirement already satisfied: Flask-Login==0.2.11 in /opt/venv/lib/python2.7/site-packages (from flask-appbuilder==1.10.0->superset) (0.2.11)
Requirement already satisfied: urllib3<1.25,>=1.21.1 in /opt/venv/lib/python2.7/site-packages (from requests->superset) (1.24.3)
Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /opt/venv/lib/python2.7/site-packages (from requests->superset) (3.0.4)
Requirement already satisfied: certifi>=2017.4.17 in /opt/venv/lib/python2.7/site-packages (from requests->superset) (2019.3.9)
Requirement already satisfied: geographiclib<2,>=1.49 in /opt/venv/lib/python2.7/site-packages (from geopy->superset) (1.49)
Requirement already satisfied: sasl>=0.2.1 in /opt/venv/lib/python2.7/site-packages (from thrift-sasl>=0.2.1->superset) (0.2.1)
Requirement already satisfied: webencodings in /opt/venv/lib/python2.7/site-packages (from bleach->superset) (0.5.1)
Requirement already satisfied: jsonschema>=2.5 in /opt/venv/lib/python2.7/site-packages (from tableschema->superset) (3.0.1)
Requirement already satisfied: tabulator>=1.3 in /opt/venv/lib/python2.7/site-packages (from tableschema->superset) (1.20.0)
Requirement already satisfied: isodate>=0.5.4 in /opt/venv/lib/python2.7/site-packages (from tableschema->superset) (0.6.0)
Requirement already satisfied: rfc3986>=1.1.0 in /opt/venv/lib/python2.7/site-packages (from tableschema->superset) (1.3.1)
Requirement already satisfied: WTForms in /opt/venv/lib/python2.7/site-packages (from flask-wtf->superset) (2.2.1)
Requirement already satisfied: babel<3.0.0,>=1.0 in /opt/venv/lib/python2.7/site-packages (from flower->superset) (2.6.0)
Requirement already satisfied: tornado<6.0.0,>=4.2.0 in /opt/venv/lib/python2.7/site-packages (from flower->superset) (5.1.1)
Requirement already satisfied: futures; python_version == "2.7" in /opt/venv/lib/python2.7/site-packages (from flower->superset) (3.2.0)
Requirement already satisfied: itsdangerous>=0.21 in /opt/venv/lib/python2.7/site-packages (from flask<1.0.0->superset) (1.1.0)
Requirement already satisfied: Jinja2>=2.4 in /opt/venv/lib/python2.7/site-packages (from flask<1.0.0->superset) (2.10.1)
Requirement already satisfied: Werkzeug>=0.7 in /opt/venv/lib/python2.7/site-packages (from flask<1.0.0->superset) (0.15.2)
Requirement already satisfied: docutils>=0.10 in /opt/venv/lib/python2.7/site-packages (from botocore<1.8.0,>=1.7.0->superset) (0.14)
Requirement already satisfied: enum34; python_version < "3" in /opt/venv/lib/python2.7/site-packages (from cryptography->superset) (1.1.6)
Requirement already satisfied: asn1crypto>=0.21.0 in /opt/venv/lib/python2.7/site-packages (from cryptography->superset) (0.24.0)
Requirement already satisfied: cffi!=1.11.3,>=1.8 in /opt/venv/lib/python2.7/site-packages (from cryptography->superset) (1.12.3)
Requirement already satisfied: ipaddress; python_version < "3" in /opt/venv/lib/python2.7/site-packages (from cryptography->superset) (1.0.22)
Requirement already satisfied: vine>=1.3.0 in /opt/venv/lib/python2.7/site-packages (from celery>=4.2.0->superset) (1.3.0)
Requirement already satisfied: billiard<4.0,>=3.6.0 in /opt/venv/lib/python2.7/site-packages (from celery>=4.2.0->superset) (3.6.0.0)
Requirement already satisfied: kombu<5.0,>=4.4.0 in /opt/venv/lib/python2.7/site-packages (from celery>=4.2.0->superset) (4.5.0)
Requirement already satisfied: python-editor>=0.3 in /opt/venv/lib/python2.7/site-packages (from alembic>=0.7->flask-migrate->superset) (1.0.4)
Requirement already satisfied: Mako in /opt/venv/lib/python2.7/site-packages (from alembic>=0.7->flask-migrate->superset) (1.0.10)
Requirement already satisfied: python-openid>=2.0 in /opt/venv/lib/python2.7/site-packages (from Flask-OpenID==1.2.5->flask-appbuilder==1.10.0->superset) (2.2.5)
Requirement already satisfied: functools32; python_version < "3" in /opt/venv/lib/python2.7/site-packages (from jsonschema>=2.5->tableschema->superset) (3.2.3.post2)
Requirement already satisfied: pyrsistent>=0.14.0 in /opt/venv/lib/python2.7/site-packages (from jsonschema>=2.5->tableschema->superset) (0.15.2)
Requirement already satisfied: setuptools in /opt/venv/lib/python2.7/site-packages (from jsonschema>=2.5->tableschema->superset) (41.0.1)
Requirement already satisfied: attrs>=17.4.0 in /opt/venv/lib/python2.7/site-packages (from jsonschema>=2.5->tableschema->superset) (19.1.0)
Requirement already satisfied: openpyxl<2.5,>=2.4 in /opt/venv/lib/python2.7/site-packages (from tabulator>=1.3->tableschema->superset) (2.4.11)
Requirement already satisfied: cchardet>=1.0 in /opt/venv/lib/python2.7/site-packages (from tabulator>=1.3->tableschema->superset) (2.1.4)
Requirement already satisfied: xlrd>=1.0 in /opt/venv/lib/python2.7/site-packages (from tabulator>=1.3->tableschema->superset) (1.2.0)
Requirement already satisfied: jsonlines>=1.1 in /opt/venv/lib/python2.7/site-packages (from tabulator>=1.3->tableschema->superset) (1.2.0)
Requirement already satisfied: ijson>=2.0 in /opt/venv/lib/python2.7/site-packages (from tabulator>=1.3->tableschema->superset) (2.3)
Requirement already satisfied: linear-tsv>=1.0 in /opt/venv/lib/python2.7/site-packages (from tabulator>=1.3->tableschema->superset) (1.1.0)
Requirement already satisfied: singledispatch in /opt/venv/lib/python2.7/site-packages (from tornado<6.0.0,>=4.2.0->flower->superset) (3.4.0.3)
Requirement already satisfied: backports-abc>=0.4 in /opt/venv/lib/python2.7/site-packages (from tornado<6.0.0,>=4.2.0->flower->superset) (0.5)
Requirement already satisfied: MarkupSafe>=0.23 in /opt/venv/lib/python2.7/site-packages (from Jinja2>=2.4->flask<1.0.0->superset) (1.1.1)
Requirement already satisfied: pycparser in /opt/venv/lib/python2.7/site-packages (from cffi!=1.11.3,>=1.8->cryptography->superset) (2.19)
Requirement already satisfied: amqp<3.0,>=2.4.0 in /opt/venv/lib/python2.7/site-packages (from kombu<5.0,>=4.4.0->celery>=4.2.0->superset) (2.4.2)
Requirement already satisfied: jdcal in /opt/venv/lib/python2.7/site-packages (from openpyxl<2.5,>=2.4->tabulator>=1.3->tableschema->superset) (1.4.1)
Requirement already satisfied: et-xmlfile in /opt/venv/lib/python2.7/site-packages (from openpyxl<2.5,>=2.4->tabulator>=1.3->tableschema->superset) (1.0.1)
Installing collected packages: markdown
  Found existing installation: Markdown 3.1
    Uninstalling Markdown-3.1:
      Successfully uninstalled Markdown-3.1
Successfully installed markdown-2.6.11

d).firewalld

主机不能访问虚拟机中的web服务
(venv) [root@localhost bin]# firewall-cmd --permanent --add-port=8088/tcp
success
(venv) [root@localhost bin]# firewall-cmd --reload
success
systemctl stop firewalld.service

网友评论

登录后评论
0/500
评论
北斗云
+ 关注