# tHiveWarehouseConfiguration

Enables the reuse of the Hive Warehouse Connector connection configuration to Hive in the same Job.

Hive Warehouse Connector supports Hive internal tables which allow you to access ACID table data from Spark with Apache Hive 3 tables.

tHiveConfiguration provides Hive Warehouse Connector connection information for the Hive related components used in the same Spark Job.

This component is not shipped with your Talend Studio by default. You need to install it using the Feature Manager. For more information, see [Installing features using the Feature Manager](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/install-features-to-talend-studio).

## tHiveWarehouseConfiguration properties for Apache Spark Batch

These properties are used to configure tHiveWarehouseConfiguration running in the Spark Batch Job framework.

The Spark Batch tHiveWarehouseConfiguration component belongs to the Storage family.

The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric.

## Basic settings

| Properties | Description |
| --- | --- |
| Property Type | Select the way the connection details<br>will be set.<br><br><ul> <li> <p> <span>Built-In</span>: The connection details will be set                                locally for this component. You need to specify the values for all                                related connection properties manually.</p> </li> <li> <p> <span>Repository</span>: The connection details stored                                centrally in <span><span>Repository</span><abbr> &gt; </abbr><span>Metadata</span></span> will be reused by this component. </p> <p>You need to click                                the <span>[...]</span> button next to it and in the pop-up                                    <span>Repository Content</span> dialog box, select the                                connection details to be reused, and all related connection                                properties will be automatically filled in.</p> </li> </ul> |
| Execution mode | Select the execution mode you want to use:<br><br><ul> <li><span>Spark Direct Reader</span>: Spark reads Hive table data                        files directly from storage, bypassing HiveServer2/LLAP.</li> <li><span>JDBC</span>: Spark executes Hive SQL queries through                        HiveServer2 over JDBC and retrieves results through the JDBC                        connection.</li> </ul> |
| Host | Enter the database server IP address. |
| Port | Enter the listening port number of the database server. |
| Database | Enter the name of the database. |
| Username and<br>Password | Enter the user authentication data of the database.<br><br>To enter the password, click the [...] button<br>next to the password field, enter the password in double quotes in the pop-up dialog box,<br>and click OK to save the settings. |
| Additional JDBC Settings | Specify additional connection properties for the database connection<br>you are creating. |
| Use Kerberos authentication | If you are accessing a Hive metastore running with Kerberos security,<br>select this checkbox.<br><br>Then you need to enter the Hive principal that should have been defined in<br>the *hive-site.xml* file of the cluster to be used.<br><br><br>Hive principal uses the value<br>of *hive.metastore.kerberos.principal*. This is<br>the service principal of the Hive metastore. |
| Use SSL encryption | Select this check box to enable the SSL or TLS encrypted<br>connection.<br><br>Then in the fields that are displayed, provide the<br>authentication information:<br><br><ul> <li>In the <span>Trust store                                        path</span> field, enter the path, or browse to the                                    TrustStore file to be used. By default, the supported TrustStore                                    types are <em>JKS</em> and <em>PKCS 12</em>.</li> <li>To enter the password, click the <span>[...]</span> button next to the <span>Trust store                                        password</span> field, and then in the pop-up dialog                                    box enter the password between double quotes and click                                        <span>OK</span> to save the                                    settings.</li> </ul> |

## Global Variables

| Variables | Description |
| --- | --- |
| Global Variables | ERROR\_MESSAGE: the error message generated by the<br>component when an error occurs. This is an After variable and it returns a string. This<br>variable functions only if the Die on error checkbox is<br>cleared, if the component has this checkbox.<br><br>A Flow variable functions during the execution of a component<br>while an After variable functions after the execution of the component.<br><br>To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from<br>it.<br><br>For more information about variables, see [Using contexts and variables](https://help.qlik.com/talend/r/en-US/8.0/studio-user-guide/contexts-and-variables). |

## Usage

| Usage guidance | Description |
| --- | --- |
| **Usage rule** | This component is generally used with other Hive<br>components, particularly tHiveWarehouseInput and<br>tHiveWarehouseOutput. |