topic Re: tHiveLoad "Append" option not working in Talend Studio

tHiveLoad "Append" option not working

Anonymous — Sat, 16 Nov 2024 11:12:00 GMT

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

Anonymous — Tue, 02 Jun 2015 06:58:07 GMT

Hi,
We don't see any screenshot on our side. Could you please check it?
Is there any error info popping up?
Best regards
Sabrina

Re: tHiveLoad "Append" option not working

Anonymous — Tue, 02 Jun 2015 07:17:26 GMT

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.