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 ?