Datatype ranges

CloverDX Platform
1

I have a DBInputTable node which accesses a MySQL database and pulls from a table with a primary key of type INT(11).

I was receiving this error:

'2.147551688E9' in column '1' is outside valid range for the datatype INTEGER.

So I edited the metadata to expect that column to be a LONG. I am still getting the exact same error. Here is more of it as it currently stands:

  Component [Events:EVENTS] finished with status ERROR. (Out0: 85026 recs)
   Parsing error in field 1 - code (long) in metadata logging
    Error on field 'code'
     '2.147551688E9' in column '1' is outside valid range for the datatype INTEGER.
2

I assume that you have column in the database as ‘INT UNSIGNED’, I found out on Google that mysql jdbc driver could have some issues with this, I cannot say more about it, that would be a question for developers, but for now I think you could try workaround and explicitly cast that column to bigint (and keep field metadata as ‘long’) .

Something like:

select cast(field1 as unsigned) from test.TestInt

Hope this helps.

3

Thank you for the information, kalisp.

I do not fully understand how, but this workaround seems to have alleviated the issue. I thought that the column being too large an INT was the problem, but instead we have forced it to be larger and now it works?

Regardless, I appreciate the help.

Thanks again.