The specified field does not exist in the view adapted schem

Telenet · Post by **Telenet** » Thu Dec 28, 2006 4:34 am

Hi,
I'm getting the error:
The specified field: USAGEHOUR does not exist in the view adapated schema
(with the type-error!)
I'm getting this error in a filter stage. This used to work correctly sequential, but I've now made this parallel on a sorted hash partition. This field is not used as hashkey, but is is used to filter for the outputs. It's also on 3 of the 4 outputs.

any idea?

ajith · Post by **ajith** » Thu Dec 28, 2006 4:43 am

Are you using a modify stage somewhere in your design and modifying the Field which is not found???

What is the filter condition??, are you sure that the column it says not found exists???

Need more info

ray.wurlod · Post by **ray.wurlod** » Thu Dec 28, 2006 6:30 am

Please post the entire error message detail.

DSguru2B · Post by **DSguru2B** » Thu Dec 28, 2006 8:23 am

Need more info on the job design and as Ray requested the entire error message, with surrounding warning messages too, for any of us to provide help.

Telenet · Post by **Telenet** » Fri Dec 29, 2006 1:28 am

this is the entire error message.
I've allready got it solved. I've removed the partitioning and sorting from the input of the filter stage and preceded it with a sort stage doing exactly the same thing.

To answer some of your questions:
- I'm not using modify stage, there is a transformer and a lookup stage before the filter(the field is created from a function in the transformer)
-filter condition USAGEHOUR<12 for link 0, >12 for link 1
-this is the first error in the log, it is followed by likewise errors in the following stages, but I disregarded them, since they're probably the same thing.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 3:01 am

Telenet wrote: I've allready got it solved. I've removed the partitioning and sorting from the input of the filter stage and preceded it with a sort stage doing exactly the same thing.

Well done. Why does this work? Why did you think to try it?

Telenet · Post by **Telenet** » Tue Jan 02, 2007 6:53 am

actually I have no clue why it works, I thought the sort stage just has extra functionality, but doesn't work any different from sorting at the input of another stage.

reason why I tried it is to find out if the problem was in the filtering or in the sorting, since the error is on a stage. by adding a sort stage I would get a more clear error.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 02, 2007 1:41 pm

Telenet wrote:-filter condition USAGEHOUR<12 for link 0, >12 for link 1

... and discard the input row if USAGEHOUR = 12 ?