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

Florian H. · Revisado há about 1 year

Scott W. · Revisado há about 1 year

Vaishnavi S. · Revisado há about 1 year

Raul S. · Revisado há about 1 year

super, need little more time to do

hemalatha s. · Revisado há about 1 year

Khanh T. · Revisado há about 1 year

Khanh T. · Revisado há about 1 year

Ronaldo M. · Revisado há about 1 year

Sameer K. · Revisado há about 1 year

Antoine B. · Revisado há about 1 year

Nitin D. · Revisado há about 1 year

Ritesh S. · Revisado há about 1 year

Alagappan V. · Revisado há about 1 year

Jorge M. · Revisado há about 1 year

Christof R. · Revisado há about 1 year

dharanikumar p. · Revisado há about 1 year

Thiago M. · Revisado há about 1 year

Saptarshi G. · Revisado há about 1 year

Thaneesh R. · Revisado há about 1 year

Diego G. · Revisado há about 1 year

Erick S. · Revisado há about 1 year

Great hand-ons

alvaro a. · Revisado há about 1 year

Sasa T. · Revisado há about 1 year

Time was very tight Also confused about the necessity of the "UNNEST" operator, as the following two queries produced the same output: #standardSQL 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; #standardSQL SELECT p.name, split_time FROM racing.race_results AS r , r.participants AS p , p.splits AS split_time WHERE split_time = 23.2;

Georg M. · Revisado há about 1 year

Jan H. · Revisado há about 1 year