Realtime catalog search with Hue and Apache Atlas

20 June 2019 in Querying / Version 4.5 - 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

    13 November 2019
    Visually surfacing SQL information like Primary Keys, Foreign Keys, Views and Complex Types
    Read More
    31 October 2019
    Missing some color? How to improve or add your own SQL syntax Highlighter
    Read More
    24 October 2019
    How to create a HBase table on Kerberized Hadoop clusters
    Read More