ddl - What is the best component to use, If I want to create a table from my talend job? -

ddl - What is the best component to use, If I want to create a table from my talend job? -

from job, trying create table ( if not exists ) selecting few records joining few tables ( create table xx select * t1 inner t2 etc ), talend job. using tmysqlrow component. not sure, right component utilize ddl operations ..!! please suggest right component use.

using tmysqlrow, working fine not consistent. times failing "java.sql.sqlexception: lock wait timeout exceeded; seek restarting transaction". because of query taking long time, or using tmysqlrow ddl operation wrong ? doing wrong ?

i able figure out issue. issue that, trying drop table in tmysqlrow component , connecting tmysqlrow create again. , these 2 not working out of single tmysqlconnection object. 1 waiting other 1 commit.

once, made both these tmysqlrow components work same tmysqlconnection object, issue got resolved.

the point larn here , of should work out of same connection object.

ddl sqlexception talend