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