topic Re: Getting different No of Columns on same postgres cross join query in Talend Studio

Getting different No of Columns on same postgres cross join query

Anonymous — Tue, 26 Nov 2019 09:26:41 GMT

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:-

Re: Getting different No of Columns on same postgres cross join query

Anonymous — Wed, 27 Nov 2019 01:17:00 GMT

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

Re: Getting different No of Columns on same postgres cross join query

Anonymous — Mon, 02 Dec 2019 08:40:48 GMT

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

Re: Getting different No of Columns on same postgres cross join query

Anonymous — Mon, 02 Dec 2019 14:29:08 GMT

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