I’ve a SQL query that when I run in an external program gives me the result of 9068697280905089, however when I run it within the Database Reader node KNIME gets the result 9,068,697,280,905,088
The DB field is Number (38) and the Column Type which KNIME returns is Number (Double)
Have you any idea why KNIME would change the last decimal in the returned result from a 9 to an 8?
Is this something you have seen before?
It would be helpful to know what database do you use and what the external tool name.
I’m using an Oracle DB and SQL Developer as the external tool to query the DB.
I’ve found the solution to this using the data type mappings feature in the latest DB Connection nodes.
Hi there @brendanPdoherty,
glad you solved it but what was the problem with default mapping in this case?
The data value returned was different from that in the Oracle table as in the screen shot below. First one is from Oracle Query (Numeric 38 Data Type) the second image is the Default Data Type mapping to a Double which changes the last digit from a 9 to an 8.
yep, get that. But what have you changed in order to work? Changed mapping to which type?
Numeric -> Long -> Number(Long) as in the screen shot below.
tnx. Maybe helps someone else as well
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.