topic Re: warning : schema is different from the query in Talend Studio

warning : schema is different from the query

Anonymous — Tue, 22 Jan 2013 22:23:28 GMT

I think that this is bugs...
step1. plz, create table
CREATE TABLE ZZ$BUG
(
START_DATE VARCHAR2(8 BYTE)
)
step2. create new job
step3. Drop the following components from the Palette onto the design workspace : tOracleInput, tOracleOutput
step4. Connect tOracleInput to tOracleOutput using a Row Main link.
step5. In the design workspace, select tOracleInput
and click the Component tab to define its basic settings.
and in the Query field, input this sql
-- sql
"
SELECT TO_CHAR(TO_DATE(START_DATE,'YYYYMMDD')-1,'YYYYMMDD')
FROM ZZ$BUG
"

then, you can see.
"warning : schema is different from the query"
of course, if Press F6 then execute it
and this job result is success.
just, i see "the waring icon!! "

is it bugs??
how is it fixed??

Re: warning : schema is different from the query

Anonymous — Wed, 23 Jan 2013 10:07:37 GMT

Hi,
The warning message shows the query is different from the schema, for example, if we define two columns:id and name on the schema, but the query select one or more than two fields like:
"select id, name, age from person"
then, the warning appears. The component always split the query to fields by comma. In this case, the component consider the query select two fields, but there is only column on the schema. That's why the warning appears, anyway, the job works fine, don't take care about it.

Best regards
Sabrina

Re: warning : schema is different from the query

dgreenx — Fri, 22 Nov 2013 21:51:57 GMT

if Talend cannot see "TO_CHAR(TO_DATE(START_DATE,'YYYYMMDD')-1,'YYYYMMDD')" as a single field result to compare with the schema of one fields, then this truly is a bug. I have the same issue with queries that have complex formulas with commas. If Talend can "Guess schema" correctly and produce the correct number of fields, then Talend can correctly count the number of fields it has just created in "Guess schema". Your explanation admits there is a bug. I am also ignoring the warning, but it would be nice to only have warnings when there is a real problem.

Re: warning : schema is different from the query

Anonymous — Mon, 25 Nov 2013 02:05:37 GMT

Hi, dgreen
Thanks for your question. It is welcome to open a jira issue of DI project on jira bug for your concern. Our developer will check it to see if there is any better optimistic solution.
Best regards
Sabrina