# 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
* 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 [Profiling an HDFS file](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-07/profiling-hive "Once you create the Hive connection via the connection to the Hadoop distribution as outlined in Profiling an HDFS file, you can analyze the data present in all Hive tables."), 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 [Column analyses](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-07/column-analyses "Talend Studio enables you to examine and collect statistics and information about the data available in database columns and in delimited files."), [Table analyses](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2026-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).