Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@somesh101 ,what is the DB type for tDBInput_1?
@somesh101 ,the problem with the DB data types which are highlited in colour in tDBinputs.
I am sure i mentioned that in last line MariaDB mysql.
But i will rephrase it ... IT'S maria-DB 🎉
by default it is converted to BIGINT in next step to String.
What should I do ?
@somesh101, can you change to BIGINT in DB data type and see the problem exists.
i tried changing it to bigint but error still persists.
@somesh101 ,can you change it to INT8 for the DB data type.