Hi,

I noticed that the support for the type long is improvable because:

Long-values converted to a variable are turned into int-type
The Math node does not provide the means too convert to long
Java edit nodes do not support returning long type either
However, one of the most important data values, the Row Index, is of type long. Therefore, and because it’s such aa fundamental type, I urgently suggest to improve the support of the long-type.

Corresponding topics date back more than 11 years by now

2011

Hi, currently I'm working with data containing columns that exceed the range supported by the IntValue type. Despite the fact that there is a type LongValue I noticed that the support is very limited even by the standard nodes, e.g. the "Table Creator" node does not support columns with type LongValue
the "Number to String" node is handling values defined as LongValue as if they were of type DoubleValue, i.e. 1385294400000 is converted to "1.3852944E12" I found a forum post (h…
2016

Dear all,
I noticed that column of type Long gets converted into Double when using the Table Row to Variable (Loop) nodes.
I this intentional? I would have expected an integer type.
Jan
2018

Hi there,
I have to do some math on very large integer values, which are stored on a database as BIGINT(12). When I load these values, Knime uses “long” as data type.
When I run a math node all these long type values are changed into double values. Normally this isn’t an issue, but I want save them back on my DB as long type too.
For example:
Value from DB: 312345123450 (Long)
Math: devide by 10: 31234512345 (Double)
When I enable “integer” in the math node I receive an error, because the …
2019

I wish the node Math Formula could produce Long values. Now, it produces Double values or Integer values when the corresponding option is checked. It is necessary to employ additional Double to Int node to convert Math Formula’s output to Long.
Please keep in mind working this out by using Math Formula’s option Convert to Int would produce wrong output facing values out of the range of integer.
And certainly more …

Best
Mike