Dynamic table creation fails when using column alias

[mat2121]

Hello,

I'm trying to create a table using the dynamic schema. The job looks like this :

tJDBCInput --> dynamicSchema ---> tMSSqlOutput (Create table if not exists)

The query in the input contains alias for duplicate column name :

Select
addressBookA.email as email1,
addressBookB.email as email2,
....
from
addressBook addressBookA,
addressBook addressBookB
where addressBookA.id = addressBookB.id .....

when running the job, i have the following error : 

java.sql.SQLException:Column names in each table must be unique

It looks like the dynamic schema does not use the alias for the table creation thus giving the error.

Any idea how to solve this ?

Thanks

[manodwhb]

@mat2121,as part of testing keep the different name then email in Table B and modify the query and execute the job and let me know.

by the way which database are you using?

[mat2121 · Accepted solution]

Hi, thanks for your input.

I'am using MySQL.

I was able to fix the problem using this parameter in the connection string : useOldAliasMetadataBehavior=true

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-installing-upgrading-5-1.html