Working with JSON, Arrays, and Structs in BigQuery Reviews

Dmytro K. · Reviewed yaklaşık 3 yıl ago

Ng Y. · Reviewed yaklaşık 3 yıl ago

Saheli D. · Reviewed yaklaşık 3 yıl ago

Soundaranayaki K. · Reviewed yaklaşık 3 yıl ago

nice

Aaisha F. · Reviewed yaklaşık 3 yıl ago

Sadhana P. · Reviewed yaklaşık 3 yıl ago

Jonathan W. · Reviewed yaklaşık 3 yıl ago

nice

Prajakta P. · Reviewed yaklaşık 3 yıl ago

Jerome G. · Reviewed yaklaşık 3 yıl ago

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. · Reviewed yaklaşık 3 yıl ago

Martin Emilio R. · Reviewed yaklaşık 3 yıl ago

great

Ashlesha k. · Reviewed yaklaşık 3 yıl ago

great

Ashlesha k. · Reviewed yaklaşık 3 yıl ago

Akshaya Poornitha A. · Reviewed yaklaşık 3 yıl ago

Plabani P. · Reviewed yaklaşık 3 yıl ago

Gaurav P. · Reviewed yaklaşık 3 yıl ago

Suprotik P. · Reviewed yaklaşık 3 yıl ago

POULOMI B. · Reviewed yaklaşık 3 yıl ago

Muthulakshmi L. · Reviewed yaklaşık 3 yıl ago

Dhana LakshmiParvathi P. · Reviewed yaklaşık 3 yıl ago

Naragana H. · Reviewed yaklaşık 3 yıl ago

Adeola O. · Reviewed yaklaşık 3 yıl ago

Cláudio N. · Reviewed yaklaşık 3 yıl ago

good

Anjali C. · Reviewed yaklaşık 3 yıl ago

Sagar R. · Reviewed yaklaşık 3 yıl ago