Hi all,

I have a flat file(TSV file) generated on daily basis for hadoop's Hive database external table.

I need to delete the old file which is being referred by Hive's external Table and create the new file for the same table with the same .tsv file name.

I dont know how to delete the file and create the new file on same Path.

I'm using ubuntu 12.0.4 OS and Pentaho DataIntergration CE 4.4 .
Please let me know is there a way around to automate this process as I'm doing this job manually.

I really appreciate your inputs.