Getting different No of Columns on same postgres cross join query

Highlighted
Five Stars

Getting different No of Columns on same postgres cross join query

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

cross join.PNG

 

PgAdmin4 Output:-

query.PNG

Tags (1)
Highlighted
Employee

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

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

 

 

Highlighted
Five Stars

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

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

Highlighted
Employee

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

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog