Warning: "schema is different from the query

One Star

Warning: "schema is different from the query

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
Moderator

Re: Warning: "schema is different from the query

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 Forum 29481
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.