Integrating Apache Hive with Spark and BI
Also available as:

Add the Superset service

You can add the Apache Superset service, which is installed by default with HDP 3.0, to your cluster in Apache Ambari.

In this task, you use a wizard for customizing Superset services that includes configuring a database backend that Superset uses to store metadata, such as dashboard definitions. By default, SQLite is installed for use as the metastore in nonproduction situations.

SQLite is not a client/server SQL database. For production use, you must install a suitable database. For example purposes, in this task, you accept the default SQLite database.

You configure a SECRET_KEY to encrypt user passwords. The key is stored in the Superset metastore. Do not change the key after setup.Upon completion of this task, you can connect Apache Hive to Superset.
You have installed a client/server database, such as MySQL or PostgreSQL, to use as the Superset database for storing metadata.
  1. From the Ambari navigation pane, select Services, scroll down the list of services to Superset, and click Add Service.
  2. In the Add Service wizard, scroll down to Superset, which is selected for addition, and click Next.
  3. In Assign Masters, accept the single default node selected to run the Superset service, and click Next.
  4. In Customize Services, configure properties:

    Superset Database password

    Superset Database Port--Enter a port number. For example, enter 8088 if you accepted the default SQLite Superset database, or 3306 if you configured MySQL as the Superset database.

    Superset SECRET_KEY--Provide any random number in SECRET_KEY, accept the other default settings, and scroll to the bottom of the page.

    Attention message--Click Show All Properties and follow prompts to configure any properties, such as providing a Superset Admin Password.

  5. Click Next.
  6. In Customize Services, in Advanced, enter a Superset Admin password.
  7. Click Next, and then click Deploy,
  8. Click Next, and in Summary, click Complete and confirm completion.
    Superset appears in the Ambari navigation pane.
    Ambari-Dashboard-Services-HDFS-YARN-MapReduce2-Tez-Hive-Zookeeper-Ambari Metrics-SmartSense-Superset