topic Re: tjoin column mismatch in Talend Studio

tjoin column mismatch

Anonymous — Sat, 16 Nov 2024 02:07:58 GMT

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 — Wed, 17 Jun 2020 12:13:15 GMT

@somesh101 ,what is the DB type for tDBInput_1?

manodwhb — Wed, 17 Jun 2020 12:19:38 GMT

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

Anonymous — Wed, 17 Jun 2020 12:20:47 GMT

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

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

Anonymous — Wed, 17 Jun 2020 13:05:16 GMT

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

What should I do ?

manodwhb — Thu, 18 Jun 2020 09:53:21 GMT

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

Anonymous — Mon, 22 Jun 2020 12:06:31 GMT

i tried changing it to bigint but error still persists.

manodwhb — Fri, 26 Jun 2020 09:49:30 GMT

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