Skip to main content

tHiveInput

Extracts data from Hive and sends the data to the component that follows.

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

tHiveInput is the dedicated component to the Hive database (the Hive data warehouse system). It can execute a given HiveQL query in order to extract the data from Hive.

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.

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!