The operator! is undefined for the argument type int

[Anonymous]

Hi,

I want to use SCD1 in my job.so I have used tamp with the below condition

!Relational.isNull(row2.COURSE_KEY)
&&
(
!row1.STUDENT_ID.equals(row2.STUDENT_ID)||
!row1.EMAIL.equals(row2.EMAIL)||
!row1.ENROLLED_ON.equals(row2.ENROLLED_ON)||  !row1.GROUP_ID.equals(row2.GROUP_ID)||
!row1.IS_ENROLLED.equals(row2.IS_ENROLLED)||  !row1.LAST_SEEN_ON.equals(row2.LAST_SEEN_ON)|| !row1.LABELS.equals(row2.LABELS)||
!row1.NAME.equals(row2.NAME)||
!row1.USER_ID.equals(row2.USER_ID))

But iam getting

The operator ! is undefined for the argument type(s) Integer

Can you please help on this

[manodwhb · Accepted solution]

@ruthvi , please try with the below one. can you tell me which column are coming with Integer type from input schema? change the comparison for the integer type. as changed for STUDENT_ID.

!Relational.isNull(row2.COURSE_KEY)
&&
(
row1.STUDENT_ID<>row2.STUDENT_ID||
!row1.EMAIL.equals(row2.EMAIL)||
!row1.ENROLLED_ON.equals(row2.ENROLLED_ON)||  !row1.GROUP_ID.equals(row2.GROUP_ID)||
!row1.IS_ENROLLED.equals(row2.IS_ENROLLED)||  !row1.LAST_SEEN_ON.equals(row2.LAST_SEEN_ON)|| !row1.LABELS.equals(row2.LABELS)||
!row1.NAME.equals(row2.NAME)||
!row1.USER_ID.equals(row2.USER_ID))