topic Re: How to convert data type boolean to tinyint(1) in Talend Studio

How to convert data type boolean to tinyint(1)

Anonymous — Sat, 16 Nov 2024 02:25:29 GMT

Hello,

My source is cassandra DB (data type is boolean) and target is Mysql(data type is tinyint(1)).

I used below Inline condition,but i am getting only 0 value in "External" field, no single 1 value for "True" in target Mysql.
user.external.equals("true") ? 1 : 0

I have a an string in source "external" with "True/False" as value and in target i have a tinyint type with bit(1) which hold only 1 OR 0.

so i want convert "True/False" to "1/0".

Source Cassandra data type for external field is booleanMysql data Type for external field is tinyint(1)

Best regards,

Re: How to convert data type boolean to tinyint(1)

TRF — Sat, 16 May 2020 17:24:53 GMT

As it is boolean, try this:
user.external ? 1 : 0

Re: How to convert data type boolean to tinyint(1)

Anonymous — Sat, 16 May 2020 19:18:13 GMT

Hi TRF,
Getting error.

Re: How to convert data type boolean to tinyint(1)

TRF — Sat, 16 May 2020 19:23:41 GMT

Is user.external daclared as a boolean field on Talend side?

Re: How to convert data type boolean to tinyint(1)

Anonymous — Sat, 16 May 2020 19:29:49 GMT

Hi TRF,

Below is my mapping in tMap.Thanks.

Mapping In tMap Schema editor

Re: How to convert data type boolean to tinyint(1)

Anonymous — Sat, 16 May 2020 19:45:00 GMT

Hi TRF,

Yes, declared as a boolean field on Talend for cassandra(source) side and integer for Mysql (Target)side.Cassandra source Data type is boolean,hence i declared boolean on TalendMysql (Target)data type is tinyint(1),but tinyint data type is not there, hence using (int | Integer) data typetmap data type declar

Re: How to convert data type boolean to tinyint(1)

TRF — Sat, 16 May 2020 20:22:39 GMT

I confirm it works.

Here is a tMap with the required expression as an example: