topic Re: TBigqueryInput Limit error in Talend Studio

TBigqueryInput Limit error

Anonymous — Sat, 16 Nov 2024 11:10:05 GMT

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

Re: TBigqueryInput Limit error

Anonymous — Thu, 02 Jul 2015 09:01:16 GMT

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

Re: TBigqueryInput Limit error

_AnonymousUser — Thu, 02 Jul 2015 09:13:16 GMT

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

Re: TBigqueryInput Limit error

Anonymous — Thu, 01 Oct 2015 10:51:42 GMT

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

Re: TBigqueryInput Limit error

Anonymous — Thu, 06 Oct 2016 03:14:26 GMT

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 !

Re: TBigqueryInput Limit error

Anonymous — Mon, 05 Nov 2018 06:06:44 GMT

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