Database Writer SQLITE schema is Numeric but Input table is Long

KNIME Analytics Platform
1

Hello guys,

I have found a stupid issue whereby I am saving Tweets via the Database Writer into SQLITE.

The schema writes the tweet and user id as Numeric (they are long from the twitter api) and then upon reading the Table again for an update there is a type mismatch Numeric vs Long.

Is there a node that will allow me to convert Numeric to Long or Long to Numeric directly?

Cheers.

2

Hi there,

The database writer node allows you to specify the SQL type when writing to DB, one option is to use VARCHAR(255).