query running in big query and talend gives different results

Five Stars

query running in big query and talend gives different results

I am running a query in big query and I get around four hundred thousand rows of data. 

But when I run the same query in Talend tBigQueryInput I get millions of rows of data. 

What could be the difference in both ? 

Fifteen Stars TRF
Fifteen Stars

Re: query running in big query and talend gives different results

Not the same db targe?

Problem in query construction if it is build at runtime?


TRF
Five Stars

Re: query running in big query and talend gives different results

It is the same database and same query. 

Strange thing is if I choose only 2-3 columns in Talend then I get the same amount of rows. 

But if I choose all the rows that I need ( I choose the same rows in big query console) I get different results.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now