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