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 ?
2 REPLIES
Moderator

Re: tHiveLoad "Append" option not working

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