Decimal Sort problem

actiview · Post by **actiview** » Sun Jan 04, 2009 7:22 am

Hi everyone,

I have the following very simple job:

Seq file -> Sort -> Seq file

The source file contains a list of decimal values that needs to be sorted.
When the type of the column is set to Decimal, the output results in "-Infinity" in each row, instead of the original values.
When I change it to another type, such as Integer or Float, the output is OK.

Since this is an upgrade from 7.5 to 8.1 and there are dozens of jobs in this project, I would like to solve this issue on the infrastructure level, rather than on the application level, so changing the type is not an option for me.

Could someone suggest a solution for this issus?
Is there a known problem with Sort and Decimal on 8.1?

thank you

ray.wurlod · Post by **ray.wurlod** » Sun Jan 04, 2009 3:57 pm

In version 8 server jobs have to run (on the principal node) in the parallel execution environment, so there is a deal of conversion of data types that needs to be achieved. I suspect what you're seeing is something to do with this, but you really need to involve your official support provider to verify the same.