Configuring the number of objects displayed in Hue

By default, a specific number of databases, tables, and columns are displayed in the Hue web interface. You can increase this number by specifying a value for the MAX_CATALOG_SQL_ENTRIES property in the Hue Advanced Configuration Snippet using Cloudera Manager.

5000 objects (databases, tables, and columns) are displayed by default on the left assist panel, auto-complete drop-down list, and on the Table Browser page in the Hue web interface. Setting the value of the MAX_CATALOG_SQL_ENTRIES property higher than the default value increases the number of objects but can downgrade performance.
  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue > Configuration > Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini and add the following lines:
    [beeswax]
    max_catalog_sql_entries=[***NUMBER-OF-OBJECTS***]
  3. Click Save Changes.
  4. Restart the Hue service.