tHiveLoad "Append" option not working

One Star

tHiveLoad "Append" option not working

Hi Team,
I'm using a loop to read data from certain files and then do a "Insert into table select". While I'm doing this, the target table is getting overwritten by the output of latest query. I'm using tHiveLoad component with Append option.
I've added a screenshot with information in component tab. Could you please look into it and let me know? Is there a work around ?

Re: tHiveLoad "Append" option not working

We don't see any screenshot on our side. Could you please check it?
Is there any error info popping up?
Best regards
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tHiveLoad "Append" option not working

Hi Sabrina,
PFA the snapshot. No there isn't any pop up.
What actually happening is, I'm looping and inserting using following query :
INSERT INTO TABLE xxxx SELECT Columns name from {table_name}, here table name is dynamic. So every time the script runs,
the data for the latest file overwrites all the content previously stored. 
Please let me know if you do not see the image attached.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach


Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.