Hi
I am using aggregator stage in my sample job , getting 2 inputs as no,sno
and i am using grouping keys as no and using sum output column for sno
i try to sum the sno column.
i am getting the following warning msg:
' When binding output interface field "SNo" to field "SNo": Implicit conversion; from source type "dfloat" to result type "int32": Possible range/precision limitation '
Aggregator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
It's just telling you that you might face number truncation or loss of decimal places when your SNo field is aggregated and delivered to an output field. You are aggregating a floating point number into an integer. Floating point fields are capable of holding very large or very small numbers via the scientific notation. I believe they support numbers from 1,000,000,000,000 to 0.0000000000000001.
If you know for sure that your input numbers are never that large or that small you can ignore the warning, otherwise you can adjust your output fields to also be a float field.
If you know for sure that your input numbers are never that large or that small you can ignore the warning, otherwise you can adjust your output fields to also be a float field.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn