You can connect to Hive to create a Superset visualization.
Upon completion of this task, you can create a Superset visualization.
You have started the Superset service in Ambari.
-
Click Superset.
-
In the Summary portion of Quick Links, click Superset and log in using your
Superset user name and password.
An empty dashboard appears.
-
From Sources, select Databases.
-
In Add Filter, add a new record.
-
In Add Database, enter the name of your Hive database: for example,
default.
-
Enter the SQLAlchemy URL for accessing your database.
For example, assuming HiveServer is running on node c7402, connect the
database named default to the Superset listening port
10000:
hive://hive@c7402:10000/default
ZooKeeper-based URL discovery is not supported.
-
Click Test Connection.
The success message appears, and the names of any tables in the database
appear at the bottom of the page.
-
Scroll to the bottom of the page, and click Save.