Como trabalhar com dados dos tipos JSON, matriz e struct no BigQuery avaliações

Dmytro K. · Revisado há about 3 years

Ng Y. · Revisado há about 3 years

Saheli D. · Revisado há about 3 years

Soundaranayaki K. · Revisado há about 3 years

nice

Aaisha F. · Revisado há about 3 years

Sadhana P. · Revisado há about 3 years

Jonathan W. · Revisado há about 3 years

nice

Prajakta P. · Revisado há about 3 years

Jerome G. · Revisado há about 3 years

i have doubt with this querys: #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; 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; From querys above, i Think the second one should send an error (i think) in BigQuery but it doesnt, I say this because the second one should have UNNEST like the first one, however returns the same output, ¿why is this? im thinking because BQ, interprets this implicitly. Can you guys tell me? e-mail: daniel_stolz@hotmail.com

Daniel M. · Revisado há about 3 years

Martin Emilio R. · Revisado há about 3 years

great

Ashlesha k. · Revisado há about 3 years

great

Ashlesha k. · Revisado há about 3 years

Akshaya Poornitha A. · Revisado há about 3 years

Plabani P. · Revisado há about 3 years

Gaurav P. · Revisado há about 3 years

Suprotik P. · Revisado há about 3 years

POULOMI B. · Revisado há about 3 years

Muthulakshmi L. · Revisado há about 3 years

Dhana LakshmiParvathi P. · Revisado há about 3 years

Naragana H. · Revisado há about 3 years

Adeola O. · Revisado há about 3 years

Cláudio N. · Revisado há about 3 years

good

Anjali C. · Revisado há about 3 years

Sagar R. · Revisado há about 3 years