Hi Friends,
I have an issue.I have 2 jobs,In one job i loaded a hash file(HF1).In another job i am trying to fetch data from the hash file(HF1) into another hash file(HF2) for a lookup.Now when I tried to view the data in HF2,My data with the metadat is not matching.Could naybody tell me where i went wrong,Please
metadata data mismatch
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
metadata data mismatch
Warm Regards,
Vijay
Vijay
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
You can't do what you are doing with HF2 without a much better understanding of the fact that hashed files are metadata driven and how the columns are positional and thus don't operate like database tables. You are going to get yourself in trouble if you make a habit of writing to one with one set of metadata and then attempting to read it back with another.
Best to read all columns and just 'drop' the unwanted ones from the stream right after the read.
Best to read all columns and just 'drop' the unwanted ones from the stream right after the read.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
Thanks Chullet,chulett wrote:You can't do what you are doing with HF2 without a much better understanding of the fact that hashed files are metadata driven and how the columns are positional and thus don't operate like database tables. You are going to get yourself in trouble if you make a habit of writing to one with one set of metadata and then attempting to read it back with another.
Best to read all columns and just 'drop' the unwanted ones from the stream right after the read.
I got it.
Warm Regards,
Vijay
Vijay