Como otimizar suas consultas do BigQuery para um melhor desempenho 2.5 avaliações

Please review now some points are don't work like this SELECT author.tz_offset, ARRAY_AGG(STRUCT(author, committer, subject, message, trailer, difference, encoding) ORDER BY author.date.seconds) FROM `bigquery-public-data.github_repos.commits` GROUP BY author.tz_offset ; I have an error: Cannot query rows larger than 100MB limit.

Grzegorz W. · Revisado há about 1 year

Too wordy and learning not clear

Eroms U. · Revisado há about 1 year

Swapnil B. · Revisado há about 1 year

Vinicius Nobre M. · Revisado há about 1 year

ANUSHREE S. · Revisado há about 1 year

Donna S. · Revisado há about 1 year

Jun Sheng Tan -. · Revisado há about 1 year

Tyrone King M. · Revisado há about 1 year

it could be a little bit longer, it has interesting topics and i had the feeling i was running out of time trying to get all the details

Aaron D. · Revisado há about 1 year

Narasimhaswamy V. · Revisado há about 1 year

Warissara N. · Revisado há about 1 year

Rupali P. · Revisado há about 1 year

Jagadeesh H. · Revisado há about 1 year

Sai T. · Revisado há about 1 year

Jorge Q. · Revisado há about 1 year

Atul Y. · Revisado há about 1 year

ok

Bernat K. · Revisado há about 1 year

kirandeep k. · Revisado há about 1 year

i did not get the same numbers on the last lab lol

Sharon Saphira R. · Revisado há about 1 year

Bhushan G. · Revisado há about 1 year

Dmitry I. · Revisado há about 1 year

Sathish K. · Revisado há about 1 year

pavel b. · Revisado há about 1 year

Akshay Sekar C. · Revisado há about 1 year

Prashun V. · Revisado há about 1 year