Data Types in knime

KNIME Analytics Platform
1

Hi,

One of my column has following value 3.689348814744643E19

colun is double and it fails when I try to "Database Write" to MySql

I coverted it from double to long by java snippet  as followed and it worked-

-----------------------------

long x;

x=$GTP.DlActvSmplsNbr$.longValue();

return x;

--------------------------------

 

I am wondering whats the difference between these two dataypes in 'KNIME'.

Also I have 100+ columns which are in double. with such a large value. How can I convert this to long.

I can't use file reader node for this.

 

2

I figured out seconds part -

double >>numer to string > String >> String to number >> Long.

But still wondering about data types in knime and thier relation(mappng) with Mysql datatypes via DB writer.

Any suggestions?

 

 

3

You can see the (default) mapping in the second tab of the Database Writer. There you can also change the mapping.

Note that by converting double values to long you will loose information (basically the fractional part). If you are fine with this you can use the Double to Int node (which can also create long cells despite its name).