You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by "ossDataEngineer (via GitHub)" <gi...@apache.org> on 2026/03/23 22:32:56 UTC
[D] Potential Bug : Handling large numbers (hop)
GitHub user ossDataEngineer created a discussion: Potential Bug : Handling large numbers
Hello Hop Team,
I have a incoming string datapoint with value = "10000000000000000.00"
I am trying to save it inside Oracle Column with datatype NUMBER(18,2).
Get the following error: ORA-01438: value larger than specified precision allowed for this column when inserting data using table output transform.
I applied metadata conversion (using select values transform) to convert original datatype of column from string to 'number' and 'bignumber' with length=16 and precision=2. The value projected after select values transform is unaffected by the precision conversion and so oracle db complains.
Question: Is the metadata conversion not working properly?
<img width="1839" height="862" alt="image" src="https://github.com/user-attachments/assets/0fe58202-578b-4a35-bf5a-1b10c5652051" />
Thanks!
GitHub link: https://github.com/apache/hop/discussions/6860
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Potential Bug : Handling large numbers (hop)
Posted by zayasj1 via users <us...@hop.apache.org>.
Try BigNumber vs Number. I've had this happen in the oast
Yahoo Mail: Search, Organize, Conquer
On Mon, Mar 23, 2026 at 15:47, dmainou (via GitHub)<gi...@apache.org> wrote:
GitHub user dmainou added a comment to the discussion: Potential Bug : Handling large numbers
It can get quirky at times if you don't get things exactly right.
Do me a favour add a calculate step and make a copy of your string as a number with the required characteristics.
Then use a select to remove, rename and reorganise and try again
GitHub link: https://github.com/apache/hop/discussions/6860#discussioncomment-16283520
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Potential Bug : Handling large numbers (hop)
Posted by "dmainou (via GitHub)" <gi...@apache.org>.
GitHub user dmainou added a comment to the discussion: Potential Bug : Handling large numbers
It can get quirky at times if you don't get things exactly right.
Do me a favour add a calculate step and make a copy of your string as a number with the required characteristics.
Then use a select to remove, rename and reorganise and try again
GitHub link: https://github.com/apache/hop/discussions/6860#discussioncomment-16283520
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Potential Bug : Handling large numbers (hop)
Posted by "dave-csc (via GitHub)" <gi...@apache.org>.
GitHub user dave-csc added a comment to the discussion: Potential Bug : Handling large numbers
If you copied the number correctly, it has **nineteen** digits in total, hence the Oracle error (a `NUMBER(18,2)` allows you to store an **eighteen**-digit number, **of which** two digits are decimal, with rounding if your actual data has more than two decimals)
Check the [Oracle Documentation for numeric data types](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html#GUID-9401BC04-81C4-4CD5-99E7-C5E25C83F608) for more details.
Hope this helps :)
GitHub link: https://github.com/apache/hop/discussions/6860#discussioncomment-16289102
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org