# tHiveOutput

Connects to a given Hive database and writes the data it receives into a given Hive table or a directory in HDFS.

Hive allows you to access external tables from Spark but does not support ACID transactions.

When ACID is enabled on the Hive side, a Spark Job cannot delete or update a table and unless data is compacted, this Job cannot correctly read aggregated data from a Hive table, either. This is a known limitation described in the [Spark bug tracking system](https://issues.apache.org/jira/browse/SPARK-15348).

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).

### In this section

* [tHiveOutput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/8.0/hive/thiveoutput-properties-for-apache-spark-batch)
* [tHiveOutput properties for Apache Spark Streaming (deprecated)](https://help.qlik.com/talend/en-US/components/8.0/hive/thiveoutput-properties-for-apache-spark-streaming)
* [tHiveOutput properties for Apache Spark Structured Streaming](https://help.qlik.com/talend/en-US/components/8.0/hive/thiveoutput-properties-for-apache-spark-structured-streaming)