Remove hash

RAI ROUSES · Post by **RAI ROUSES** » Tue May 03, 2011 8:25 pm

At the end of the job I would like to remove the hash file ? How can I do that ?

Cheers

Rai

ray.wurlod · Post by **ray.wurlod** » Tue May 03, 2011 8:27 pm

Why did you post this in the parallel forum?

RAI ROUSES · Post by **RAI ROUSES** » Tue May 03, 2011 8:44 pm

oops .....

chulett · Post by **chulett** » Tue May 03, 2011 9:18 pm

What you talk'n about Ray?

chulett · Post by **chulett** » Tue May 03, 2011 9:21 pm

I'm curious why you think you need to delete the hashed file when you are done? From both a lineage and trouble-shooting standpoint, you may be in trouble if that information is gone. Why not simply clear it (or drop and recreate it) at the start of the next run, an ability that's built into the stage?

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 4:46 am

You can delete the hashed file (note: it's not "hash" file) using an after-stage or after-job subroutine. The actual command to use will depend on whether you are using an account-based or directory-based ("pathed") hashed file.

chulett · Post by **chulett** » Wed May 04, 2011 7:02 am

As noted, it depends on how the hashed file was created. The log will show the command used, from which you can infer what you need to do to delete. So, pathed or in an account?

greggknight · Post by **greggknight** » Wed May 04, 2011 7:15 am

I would use a parameter in the hashfile name so that each one is related to the run it was loaded in.

I agree with previous posts that they should not be removed.
1) for trouble shooting reasons.
2) disk space. What I mean by that is if the files maintain approx the same size each time they will hold the space they need for each run.
.......