How to Enable and Use Governance-Based Data Discovery
As of Cloudera Enterprise 5.11, Hue can use the metadata tagging, indexing, and search features available with Cloudera Navigator data management. After integrating Hue with Cloudera Navigator, existing Cloudera Navigator tags and indexed entities can be accessed and viewed in Hue, and entities can be tagged using Hue interfaces. Managed metadata and custom metadata tags created or applied using Hue are then stored in the Cloudera Navigator instance. This How To shows administrators how to enable this capability and SQL users how to use the feature.
Continue reading:
Administrator Setup Tasks
SQL Users Get Started
This short tutorial shows you how to organize data better, how to create new tags, or re-use existing tags.
Applying Metadata Tags Using Hue
Prepare Hue Tables
As the Hue superuser, install sample tables and then refresh Impala metadata.
- Log in to Hue (as superuser) by selecting Hue Web UI in Cloudera Manager.
- Go to Note: You can also append /about to the Hue URL: http://<hostname>:8889/hue/about/.
and install sample tables for Hive and Impala.
- Go to and click the refresh icon.
- Select Perform incremental metadata update to display sample tables.
- Go to Metastore Tables Manager and click the refresh icon.
Tag Database, Table, and Field
- In Metastore Tables Manager, click the default (or some other) database.
- Add database tag: Hover over TAGS, click the edit icon, enter a tag of your choice, and save.
- Add table tag: Click a table name (such as "customers"), hover over TAGS, and repeat.
- Add field tag: Click the "show details" icon by a column name and repeat in the context popup.
Search Cloudera Navigator Metadata with Hue
After integrating Hue with Cloudera Navigator, the Hue SQL Editor provides a Search bar that includes a list of filters and an auto-complete listing that is pre-filled with top values.
The Search mechanism by default returns tables and views only. Use the type filter to search for columns, partitions, and databases.
Note: On clusters that use Sentry for role-based access control, the Search mechanism does not
display counts of popular values. Sentry ensures that Hue users can view only entities to which their user role (as configured and managed by Sentry) has been granted specific permissions.
The Cloudera Navigator search field can be accessed in the Metastore Tables Manager as well as from the Hive and Impala editors.
- Go to .
- Search on "type:field tags:" in the Navigator search field.
Note: You can search for table tags with "tags:". For other types, input "type:database tags:" or "type:field tags:". - Create a view of customers named David:
CREATE VIEW IF NOT EXISTS davids AS SELECT * FROM customers WHERE customers.name LIKE 'David%';
- Search on "davids". You should see, No recent match found, until Navigator can process the new view.
Note: New tables and views can take ~1 hour to register in Navigator and be searchable.
- Log in to Cloudera Navigator at http://<cloudera manager hostname>:7187.
- On the Search tab, select type=View. When you see "davids," return to Hue and retry your search.
- To see your tags in Cloudera Navigator, click Add New Value under tags.
Page generated July 25, 2018.
<< How to Enable SQL Editor Autocompleter in Hue | ©2016 Cloudera, Inc. All rights reserved | How to Enable Usage-Based Query Assistance for Hue >> |
Terms and Conditions Privacy Policy |