Configuring MariaDB as the backend database for Cloudera Data Explorer (Hue)

After installing and configuring the MariaDB database,you can configure Data Explorer to use it as its backend database.

  1. Log into Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue service > Configuration and filter by Database category.
  3. Select the Hue Database Type as MySQL.
  4. Set the following database parameters:
    Hue Database Hostname: FQDN of host running MariaDB server
    Hue Database Port: 3306
    Hue Database Username: [***USERNAME***]
    Hue Database Password: [***PASSWORD***]
    Hue Database Name: [***HUE-DATABASE-NAME***] or SID
  5. Click Save Changes.
  6. Restart the Data Explorer service.
You can click Data Explorer (Hue) Web UI to log on to Hue with a custom MariaDB database.