Created on 01-30-201705:15 AM - edited 08-17-201905:11 AM
Working with airbnb's Superset
This is a very cool open source Analytics platform based on
some cool Python.
I installed this on a CentOS 7 edge node.
sudo yum upgrade python-setuptools
sudo yum install gcc libffi-devel python-devel python-pip
python-wheel openssl-devel libsasl2-devel openldap-devel
pip install virtualenv
virtualenv venv. ./venv/bin/activate
pip install --upgrade setuptools pip
pip install mysqlclient
pip install pyhive
pip install superset
fabmanager create-admin --app superset
2017-01-27 18:15:37,864:INFO:flask_appbuilder.security.sqla.manager:Created Permission
View: menu access on Query Search2017-01-27
18:15:37,885:INFO:flask_appbuilder.security.sqla.manager:Added Permission menu
access on Query Search to role AdminRecognized Database Authentications.2017-01-27
18:15:37,907:INFO:flask_appbuilder.security.sqla.manager:Added user admin
Admin User admin created.
superset db upgrade
superset runserver -p 8088
The main things you will need are Python
Browse to http://yourservername:8088/ and start running querys, building charts and reports. It does a lot of things that commercial reporting tools do, but fully open source. Superset + Zeppelin + CLI + ODBC + JDBC give me all the access to my Hadoop, Druid, SparkSQL and MariaDB data that I need.
This is admin with the password you set in the fabmanager create admin.
Browsing tables is easy in the web based platform.
The results of running a query which shows the intellisense that suggests table names for you.
This was a built-in example report that shows you how powerful and professional reports you can build with this tool.
The SQL Lab is a great place to try out queries and examine data.
SQL Lab lets you run queries and explore the data. You get quick access to your previous queries and run status.
This is a simple report that was autogenerated for me by picking a query on one table.
This is your home page that will show you dashboards you have built and recent activity. A very nice github style interface.