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