SQLite Database Parsing Long values

KNIME Analytics Platform
1

Hi,

I stored some long values in a SQLite database. Now I want to analyze my data from the database (SQLite Connector -> Database Table Selector -> Database Connection Table Reader). The problem is that the long values are parsed as NUMBER (integer).

I am using version 3.2.1

 

Best regards,

Johannes

 

1 Like
2

You have to specify an SQLLite data type in the writer dialog ("SQL Types") that gets mapped to a long.  Use BIGINT, for example.

1 Like
3

Ah okay thanks !

On the workflow I used the database writer for reproducing the "bug". In this case I declared my databasetypes wrong (just a little bit).

The workaround  'SELECT cast(value as bigint) FROM test' works great for me.

Thank you for your hellp.

 

Best regards,

Johannes

1 Like