# tHiveOutput properties for Apache Spark Structured Streaming

[Preview](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/feature-preview-program-overview.htm)

These properties are used to configure tHiveOutput running in the Spark Structured Streaming Job framework.

The Spark Structured Streaming tHiveOutput component belongs to the Databases family.

The streaming version of this component is available in Talend Real-Time Big Data Platform and in Talend Data Fabric.

Information noteImportant: Talend does not support the import of schema for complex data types such as array, struct, and map.

## Basic settings

| Properties | Description |
| --- | --- |
| Property Type | Select the way the file path and the schema will be set.<br><br><ul> <li> <p> <span>Built-In</span>: The file path and the schema will be                                set locally for this component.</p> </li> <li> <p> <span>Repository</span>: The file 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                                file to be reused, and all related properties will be automatically                                filled in.</p> </li> </ul> |
| External table | Select this check box to write data to an external Hive table. When<br>selected, the Table property changes to<br>Path, and Spark writes data directly in the configured<br>format without using Hive's table management. |
| Table / Path | When External table is cleared, enter the name of<br>the Hive table to write to. When External table is<br>selected, enter the path to the output directory. |
| Format | Select the file format for the output data. The default format is<br>parquet. |
| Output mode | Append: adds rows to the output table without<br>modifying existing rows.<br><br>Information noteRestriction: In Spark Structured Streaming<br>Jobs, tHiveOutput supports only the Append output mode.<br>The Complete and Update modes are not supported for file-based sinks in<br>Structured Streaming. |
| Checkpoint location | Enter the path to the directory where Spark stores the checkpoint data for<br>this streaming query. Checkpointing enables fault tolerance and allows a failed<br>query to resume from where it stopped. |
| Set trigger | Select this check box to configure how often the streaming query<br>processes data. When selected, choose one of the following trigger types:<br><br><ul> <li><span>Available now</span>: processes all available data in a                        single batch, then stops the query.</li> <li><span>Fixed interval</span>: runs the query at a fixed time                        interval. Enter the interval duration in the field that appears, for example                        <kbd>10 seconds</kbd>.</li> </ul> |
| Set query name | Select this check box to assign a name to the streaming query. In the<br>Query name field, enter the name. |

## Usage

| Usage guidance | Description |
| --- | --- |
| Usage rule | This component is used as an end component and requires an input link.<br><br>This component should use a tHiveConfiguration component present in the same Job to connect to<br>Hive.<br><br>This component, along with the Spark Structured Streaming component Palette it belongs to,<br>appears only when you are creating a Spark Structured Streaming Job. |
| Spark Connection | You need to use the Structured Streaming Configuration<br>tab in the Run view to define the connection to a Spark cluster for<br>the whole Job.<br><br>This connection is effective on a per-Job basis. |