TBigqueryInput Limit error

One Star

TBigqueryInput Limit error

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
Moderator

Re: TBigqueryInput Limit error

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TBigqueryInput Limit error

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
One Star

Re: TBigqueryInput Limit error

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

Re: TBigqueryInput Limit error

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 !