tELTHiveOutput component's INSERT(append) functionality is not working

Highlighted
One Star

tELTHiveOutput component's INSERT(append) functionality is not working

Hi,
When I tried to use tELTHiveOutput component to append data in an existing table, I am not getting the desired output.
The component is deleting the corresponding HDFS file data before loading the new data into it.
I verified the logs and I could see that the syntax (if I select INSERT operation) is INSERT INTO TABLE which is the right syntax.
I am not sure which part of the component is deleting the data before loading.
I could see the append happening with the same query , if I run it using tHiveRow component.
Could you please help me to resolve this issue ?

Thanks,
Saravana
Highlighted
Moderator

Re: tELTHiveOutput component's INSERT(append) functionality is not working

Hi,
Have you checked component reference TalendHelpCenter:tELTHiveOutput?
Did you use tELTHiveMap and tELTHiveInput / tELTHiveOutput in your job design? Would you mind uploading your current job design screenshot into forum?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: tELTHiveOutput component's INSERT(append) functionality is not working

Hi Sabrina,
I have verified the component reference. And below is property of the tELTHiveOutput component which I mentioned earlier.
"
Action on data :
Select the action to be performed on the data to be written in the Hive table.
With the Insert option, the data to be written in the Hive table will be appended to the existing data if there is any
"
I do have tELTHiveInput and tELTHiveMap component in my job and I have attached the screen shots of my job as well as the component in which I am facing issue.
Thanks,
Saravana

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog