Installing HDF Services on an Existing HDP Cluster for IBM Power Systems
Also available as:
PDF
loading table of contents...

Configuring Druid and Superset Metadata Stores in MySQL

About This Task

Druid and Superset require a relational data store to store metadata. To use MySQL for this, install MySQL and create a database for the Druid metastore.

Steps

  1. Launch the MySQL monitor:

    mysql -u root -p
  2. Create the database for the Druid and Superset metastore:

    CREATE DATABASE druid DEFAULT CHARACTER SET utf8;
    CREATE DATABASE superset DEFAULT CHARACTER SET utf8;
    
  3. Create druid and superset user accounts, replacing the last string with your password:

    CREATE USER 'druid'@'%' IDENTIFIED BY '9oNio)ex1ndL';
    CREATE USER 'superset'@'%' IDENTIFIED BY '9oNio)ex1ndL';
    
  4. Assign privileges to the druid account:

    GRANT ALL PRIVILEGES ON *.* TO 'druid'@'%' WITH GRANT OPTION;
    GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' WITH GRANT OPTION;
    
  5. Commit the operation:

    commit;