# 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
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* 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 [Creating an analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-an-analysis).

   This analysis profiles database content to have an overview of the number of tables and rows per table. For further information, see [Creating an analysis](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-an-analysis)Creating an analysis.
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), [Table analyses](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-07/tables-analyses "You can examine the data available in single tables of a database and collect information and statistics about this data.") and [Analyzing duplicates](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/dq-analyzing-duplicates).