# Profiling Hive

Available in...

* Big Data Platform
* Cloud API Services Platform
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Management Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Real-Time Big Data Platform

Once you create the Hive connection via the connection to the Hadoop distribution as outlined in [Creating a connection to Hive](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-connection-to-hive), you can analyze the data present in all Hive tables.

## Procedure

1. Under the Metadata node in the DQ Repository tree view browse to the Hive connection.
2. Right-click the Hive connection and select Overview Analysis.

   ![Contextual menu of a Hive connection.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/profile_hive.png)

   This analysis profiles database content to have an overview of the number of tables and rows per table. For further information, see [Analyzing databases](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/analyzing-databases).

   This analysis profiles database content to have an overview of the number of tables and rows per table. For further information, see [Analyzing databases](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/analyzing-databases)Analyzing databases.
3. Right-click a Hive table and select any of the analyses listed in the menu.

   ![Contextual menu of a table in a Hive connection.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/profile_hive2.png)

   A wizard guides you through the steps to create the selected analysis. You can then assign indicators to the analyzed columns according to your need.

   A wizard guides you through the steps to create the selected analysis. You can then assign indicators to the analyzed columns according to your need.

   For further information, see [Where to start?](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/where-to-start), [Steps to analyze database tables](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/steps-to-analyze-database-tables) and [Analyzing duplicates](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/dq-analyzing-duplicates).