Getting different No of Columns on same postgres cross join query

[Anonymous]

I am trying to execute cross join query in tDbInput but it is showing different no of columns in output than the same query i executed in PgAdmin 4.

Query:-

select q.date,p.personid,p.timestamp,q.voucherno 
from person p 
cross join purchase q 

Talend Output:-

PgAdmin4 Output:-

[Anonymous]

Hi,

    I believe you are trying to say row count is different when you run query (instead of difference in column count as mentioned in your above).

    Did you print the data from both systems and try to check the output data? Also please check whether you are connecting to same DB.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

yes i wanted to say row count i checked both databases and schema as well. but still there is difference in rows when executing query in pgAdmin and in dbRow

[Anonymous]

Hi,

   Did you check the data for missing records? Are they having same primary key or are they having null values? Any patterns you could find from the data?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved