Como trabalhar com dados JSON e de matriz no BigQuery avaliações

Felipe G. · Revisado há over 5 years

too long

Helaine F. · Revisado há over 5 years

Luis A. · Revisado há over 5 years

this code would work even without the UNNEST function, is it really necessary? if so, what is the difference? SELECT p.name, split_time FROM racing.race_results AS r , UNNEST(r.participants) AS p , UNNEST(p.splits) AS split_time WHERE split_time = 23.2; also, the difference between struct and array is not very clear, wish we had another example with screenshots

Thomás Antonio B. · Revisado há over 5 years

Esmeralda Danae C. · Revisado há over 5 years

Jesús Pérez G. · Revisado há over 5 years

Atsuhiro H. · Revisado há over 5 years

Camy L. · Revisado há over 5 years

Mario R. · Revisado há over 5 years

Andrei B. · Revisado há over 5 years

Madhuri M. · Revisado há over 5 years

Ashish [Outlook] B. · Revisado há over 5 years

richard f. · Revisado há over 5 years

Rakesh N (IT) P. · Revisado há over 5 years

Murilo A. · Revisado há over 5 years

Lauren Y. · Revisado há over 5 years

Dikshith G. · Revisado há over 5 years

Luka K. · Revisado há over 5 years

Vladan B. · Revisado há over 5 years

Bintang A. · Revisado há over 5 years

Amit S. · Revisado há over 5 years

Daria P. · Revisado há over 5 years

Aldo N. · Revisado há over 5 years

Amit P. · Revisado há over 5 years

Amel A. · Revisado há over 5 years