Realtime catalog search with Hue and Apache Atlas

20 June 2019 in Querying / Version 4 - 2 minutes read

With the latest Hue (future 4.5 release), we are glad to announce that Hue integrates with Apache Atlas as backend to enable SQL users for real time data catalog searching.

Previously Hue’s catalog was powered by Cloudera Navigator only, but now the API is generic and could potentially support other Catalog services too. The nice end user experience for finding content to query can be transparently re-used.

With this first integration, Hue lists properties of entities like classifications and provides real time search among thousands of possible tables or databases:

Here is the search UI from Atlas for Data Stewards:

It is accessible from the top global search bar of the interface and offers free text search of SQL databases, tables, fields(columns), classifications and saved queries(Hue documents) similar to Hue-Navigator integration.

Here are a few examples to get you started:

  • ‘sample’ → Any table or Hue document with prefix ‘sample’ will be returned
  • ‘type:database’List all databases on this cluster

  • ‘type:table ’List all tables on this cluster

  • ‘type:field name’List tables with field(column): ‘name’

  • ‘tag:classification_testdb5’ or ‘classification:classification_testdb5’ List entities with classification ‘classification_testdb5’

  • ‘owner:admin’List all tables owned by ‘admin’ user


    As always, thank you for your interest and if you have any questions please feel free to comment and send feedback here or @gethue!



    comments powered by Disqus

    More recent stories

    25 December 2019
    A more collaborating Datawarehousing Experience with SQL query sharing via links or gists
    Read More
    05 December 2019
    Hue 4.6 and its improvements are out!
    Read More
    13 November 2019
    Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
    Read More