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.
Can anyone please help?
Can you please provide output from the execution and also schemas used in both components with an example of working and not working row? Thanks.
Print screens are attached:
compile-error.jpg > The execution error
scheme-fail.jpg> The scheme structure while failed
scheme-success.jpg > The scheme structure while succeeding (string only)
success-output.jpg> execution output while using string only
error-java.jpg > The JAVA code error source
int cannot be compared to null, which is a null reference to an object. Compare with zero instead.
Also... In schema where you have an ID (int), you use it as a primary key. Primary key can't be NULL.
Please post here a screenshot of the job.
How can I change the comparison to 0 instead of NULL (though the UI interface)?
I understand the problem is in the code, but I do not have the option to change it, so I guess that I need to change something in the variables configuration?
The job screenshot is attached