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