Warning: "schema is different from the query

Anonymous — Fri, 07 Jun 2013 11:40:53 GMT

Hi.
I build a job with a mysql input component. The SQL:

SELECT CAST(COALESCE(MAX(ID), 0)+1 as SIGNED) as MAX_ID FROM TABLE_XY

The schema:

I got the warning near the the component:

What is the solution?
Thanks in advance.
Marcus

Re: Warning: "schema is different from the query

Anonymous — Sat, 08 Jun 2013 03:33:18 GMT

Hi,
This warning refer to the setting of your "DB type" not the query. Because the query should be fine if it can check the data source.
Set a correct DB type in schema will avoid this issue. Certainly, this warning doesn't affect your job.
Related https://community.talend.com/t5/Design-and-Development/Schema-s-db-type-not-correct-for-this-component/td-p/107368
Best regards
Sabrina