TBigqueryInput Limit error

[Anonymous]

Hi Team,
Whenever I am fetching data from Bigquery table with specifying more than 100000 records, its giving me below error
Running Query : SELECT  action_payout FROM LIMIT 1000000
Exception in component tBigQueryInput_1
com.google.api.client.googleapis.json.GoogleJsonResponseException: 404 Not Found
{
  "code" : 404,
  "errors" : ,
  "message" : "Not found: Table igneous-study-87009:_165c6d3f4b2c1dbd0d644a1155ebebf7f2dbacfd.anon22fbed90bfc239ef84ee0345744d6cda6052a060"
}
Even if I dont specify the limit its giving me error. Its working fine for less than 100000 records

[Anonymous]

Hi manoj.kumar1,
On which official version did you get that?

Have you already checked a fixed jira issue: https://jira.talendforge.org/browse/TDI-28445?

Best regards
Sabrina

[_AnonymousUser]

I am Facing the issue on 5.6.2 version. Its not a issue. Its basically a feature that i suppose is not there .
Google Bigquery has a property i.e. Allowlargeresults but its not there in TBigqueryinput. 
Thanks
Manoj

[Anonymous]

I am facing the same issue 
Is there any solution if I want to use Talend for extracting large BigQuary tables?

[Anonymous]

Hi there - I am currently using Talend open studio v6.1.1 and this issue still exists.
Exception in component tBigQueryInput_4
com.google.api.client.googleapis.json.GoogleJsonResponseException: 404 Not Found
{
  "code" : 404,
  "errors" : ,
  "message" : "Not found: Table rand-cap:_f000fcf374688fc5e7da50a4c0c04ba228d993c3.anon87ee8f47e036c843a84a722c2f70972e6ddd286a"
}
Like others have mentioned, the "allowLargeResults" option isn't available yet even in 6.1.1. Any ideas on when this will be fixed/added ?
Thanks in advance !

[Anonymous]

Hello,

We have added new dropdownlist named Result Size, which contains three options, Small/Large/Auto since 6.4.

https://jira.talendforge.org/browse/TBD-4538

Best regards

Sabrina