Bug in pivot stage ???
Moderators: chulett, rschirm, roy
Bug in pivot stage ???
Hi ,
Today i developed a parallel job .My requirement is to do horizontal pivot .So , i have used the pivot stage .
The job is getting aborted after having a warning arthimetic overflow.So , i have developed another simple job which has pivot stage and that job is working fine .
After an ordeal of 1 hr , i came to know that bigint field is giving the problem Further i observed that whenever the input is having a field of datatype bigint job is failing .
Just i want to know is it a bug or it is as expected ? Is there any restriction on the datatypes to use in pivot stage ?
Please throw some light on this .
Thanks in advance .
Today i developed a parallel job .My requirement is to do horizontal pivot .So , i have used the pivot stage .
The job is getting aborted after having a warning arthimetic overflow.So , i have developed another simple job which has pivot stage and that job is working fine .
After an ordeal of 1 hr , i came to know that bigint field is giving the problem Further i observed that whenever the input is having a field of datatype bigint job is failing .
Just i want to know is it a bug or it is as expected ? Is there any restriction on the datatypes to use in pivot stage ?
Please throw some light on this .
Thanks in advance .
Nag
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not expected. After all the Pivot stage does not change the value - it only moves it to a different place. What happens if you change the output to unsigned BigInt (int64)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The resource bundle message is unrelated to the arithmetic overflow, I believe. The resource bundle message is about finding the text to accompany some particular error code.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 7
- Joined: Tue Apr 21, 2009 2:27 am
- Location: chennai
Re: Bug in pivot stage ???
I tried doing the same. Luckily it ran successfully but the viewdata is giving error.
Anshul