Hello guys, I am trying to create index for a mysql table using talend, but, so far, i couldnt figure it out. I tried to insert a query like this on tMysqlInput component: ALTER TABLE `fh_datamart`.`dim_date` ADD INDEX `index2` (`year4` ASC) , ADD INDEX `index3` (`month2` ASC) ;
but it returns me the following error: java.sql.SQLException: Can not issue data manipulation statements with executeQuery(). Can somebody help me figure out , how do to this? Thank you in advance.