tjoin column mismatch

[Anonymous]

I am trying to join two tables coming from two different databases.

but after selecting columns on which to perform join and output columns. I am getting compile-time error "Type mismatch".

After looking at code it is clear why. but how to rectify this?

MY SETUP:

windows 10

Java 1.8_0_251

Talend open studio data integration 7.2.1 (free version)

connections used: MariaDB MySQL input

[manodwhb]

@somesh101 ,what is the DB type for tDBInput_1?

[manodwhb]

@somesh101 ,the problem with the DB data types which are highlited in colour in tDBinputs.

[Anonymous]

I am sure i mentioned that in last line MariaDB mysql.

But i will rephrase it ... IT'S maria-DB 🎉

[Anonymous]

by default it is converted to BIGINT in next step to String.

What should I do ?

[manodwhb]

@somesh101, can you change to BIGINT in DB data type and see the problem exists.

[Anonymous]

i tried changing it to bigint but error still persists.

[manodwhb]

@somesh101 ,can you change it to INT8 for the DB data type.