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:
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:
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.-
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. -
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.
Please sign in to leave a comment.
Comments 2