# 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-R2024-04-and-earlier/creating-connection-to-hive "You can create a connection to Hive directly from the connection you defined for the Hadoop distribution. However, you can proceed differently and create the connection to Hive simultaneously while you create an analysis on HDFS file as outlined in Creating a connection to an HDFS file."), 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-R2024-04-and-earlier/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-R2024-04-and-earlier/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-R2024-04-and-earlier/where-to-start "Talend Studio enables you to examine and collect statistics and information about the data available in database columns and in delimited files."), [Steps to analyze database tables](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-04-and-earlier/steps-to-analyze-database-tables) and [Analyzing duplicates](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-04-and-earlier/dq-analyzing-duplicates).