# Installing Hive

From the Cloudera Manager Home page, select the ‘Add a Service’ menu option from the drop-down menu to the right of Cluster Name.

The Add Service Wizard appears.

![](/files/gC8yJrUqervItacUd5cf)

Select the Hive Service

![](/files/cCPDXGyzH3arQSsI7Km0)

Select dependencies and click on continue.

![](/files/OH1gQydxZtutpVmRtdus)

Choose center machine for your Gateway, Hive MetaStore and HiveServer2.

> * Gateway: datacouch.training.io
> * Hive Metastore Server: datacouch.training.io
> * Hive Server2: datacouch.training.io

![](/files/OPuArgNRyZeAZKkCNDel)

Configure and test database connection

Select the database type and enter the database name, username, and password for each service.

![](/files/ITTW3kG93dh1zDgsgADl)

Click Test Connection to validate the settings. If the connection is successful, a green checkmark and the word Successful appears next to each service. If there are any problems, the error is reported next to the service that failed to connect.

After verifying that each connection is successful, click Continue.

After testing the connection click Continue

Mention the Hive Warehouse Directory and the Hive Metastore Port Number and Click Continue

![](/files/DJXwQ07t6lV1KKGu7aPM) ![](/files/lCzcXpAeDWSZEYYbQl54) ![](/files/IwLXMwCspOmUD3x8Tt7p)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://training-team.gitbook.io/setting-up-cloudera-data-platform-cdp/installing-hive.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.