topic Re: Load numeric / boolean data in Talend Studio

Load numeric / boolean data

Anonymous — Sat, 16 Nov 2024 08:52:55 GMT

Hello,

I'm using "Open Studio for Data Integration" and I have a simple job which reads from mysql and writes to Google BigQuery.

I'm getting the following error while trying to read from a table that includes any numeric/boolean values:

"the operator =! is undefined for the argument type(s) int, null"

If the source table contains only strings, the job works fine.

Both input and output schemes are defined with the corrected variable types.

The JAVA code compare int to null which makes this exception, but I do not have the option to change it.

Am I doing something wrong, or its a bug?

Print screen is attached,

Thanks in advance!

Re: Load numeric / boolean data

Anonymous — Wed, 10 Jan 2018 11:05:49 GMT

Check the 'nullable' box of id column on the schema. Let me know if it works.

Re: Load numeric / boolean data

TRF — Wed, 10 Jan 2018 11:08:06 GMT

In Java, Int can't be null. However, Integer can be null.

Check this link https://stackoverflow.com/questions/2254435/can-an-int-be-null-in-java

Re: Load numeric / boolean data

Anonymous — Wed, 10 Jan 2018 11:43:37 GMT

Hi Shong,

It's still not working

Thanks

Re: Load numeric / boolean data

Anonymous — Wed, 10 Jan 2018 11:46:07 GMT

Thanks TRF,

I don't think that I have the option to change the JAVA code through the UI interface

Re: Load numeric / boolean data

TRF — Wed, 10 Jan 2018 12:07:47 GMT

No, you don't.
But you probably may convert int value to Integer then compare to null

Re: Load numeric / boolean data

Anonymous — Thu, 11 Jan 2018 05:10:34 GMT

The operator != is not defined for int type, If I check 'Nullable' box on the schema, the type will be changed to Integer and the compilation error is fixed.

Regards

Shong

Re: Load numeric / boolean data

Anonymous — Fri, 12 Jan 2018 13:56:38 GMT

I tried now and it worked, thank you for the clarification