Working with JSON, Arrays, and Structs in BigQuery Reviews

Dmytro K. · Reviewed حوالي 3 سنوات ago

Ng Y. · Reviewed حوالي 3 سنوات ago

Saheli D. · Reviewed حوالي 3 سنوات ago

Soundaranayaki K. · Reviewed حوالي 3 سنوات ago

nice

Aaisha F. · Reviewed حوالي 3 سنوات ago

Sadhana P. · Reviewed حوالي 3 سنوات ago

Jonathan W. · Reviewed حوالي 3 سنوات ago

nice

Prajakta P. · Reviewed حوالي 3 سنوات ago

Jerome G. · Reviewed حوالي 3 سنوات 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 حوالي 3 سنوات ago

Martin Emilio R. · Reviewed حوالي 3 سنوات ago

great

Ashlesha k. · Reviewed حوالي 3 سنوات ago

great

Ashlesha k. · Reviewed حوالي 3 سنوات ago

Akshaya Poornitha A. · Reviewed حوالي 3 سنوات ago

Plabani P. · Reviewed حوالي 3 سنوات ago

Gaurav P. · Reviewed حوالي 3 سنوات ago

Suprotik P. · Reviewed حوالي 3 سنوات ago

POULOMI B. · Reviewed حوالي 3 سنوات ago

Muthulakshmi L. · Reviewed حوالي 3 سنوات ago

Dhana LakshmiParvathi P. · Reviewed حوالي 3 سنوات ago

Naragana H. · Reviewed حوالي 3 سنوات ago

Adeola O. · Reviewed حوالي 3 سنوات ago

Cláudio N. · Reviewed حوالي 3 سنوات ago

good

Anjali C. · Reviewed حوالي 3 سنوات ago

Sagar R. · Reviewed حوالي 3 سنوات ago