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