topic Re: Error converting data, invalid type for parameter: in Talend Studio

Error converting data, invalid type for parameter:

param123 — Thu, 19 Sep 2019 22:37:54 GMT

hi all,

I am trying to load table from mysql to redshift using dynamic schema. but Im getting the below error

"Error converting data, invalid type for parameter:3"

can someone what should i do to resolve this.

job design:

tmysqlinput with dynamic schema-->tmap-->tredshiftoutput with dynamic schema(settings create table and insert)

Re: Error converting data, invalid type for parameter:

fdenis — Fri, 20 Sep 2019 11:04:17 GMT

run your job in debug mode to define the type who cause this trouble.
When using dynamic type I ll alwasy prefer to use sys table to build destination table before uploading data.

Re: Error converting data, invalid type for parameter:

param123 — Fri, 20 Sep 2019 14:45:11 GMT

Thanks for your response!

Can you please help me with job design for creating table using sys table.

and I want to this creation of table dynamically for many tables..Kindly suggest!

Re: Error converting data, invalid type for parameter:

fdenis — Fri, 20 Sep 2019 15:05:50 GMT

SELECT * FROM INFORMATION_SCHEMA.TABLES
will return metadata information on every table, while

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
will return metadata information on every column.

then use create table syntaxe to dynamically build you table.

good luck

Re: Error converting data, invalid type for parameter:

param123 — Fri, 20 Sep 2019 15:21:07 GMT

but how to generate "create statement" dynamically using this sys tables....should we have to write a java code or is there a straight forward way to do this in Talend using some components?

I wanted to do this for all tables before loading data in single job....using tablelist i can get the tables and then i can get the sys columns...but wht would be the next step to generate create statment using this?

please suggest!

Re: Error converting data, invalid type for parameter:

fdenis — Fri, 20 Sep 2019 16:03:20 GMT

use tmap to create column definition. colname varchar(5)
use taggregate to list all coldefinition
then tDBsp to ececute Créate table xxx.

is it one shot?
in this case you may generate sctipt from MySQL user interface and sun it (with modification) on destination db