在 BigQuery 使用 JSON、陣列和結構體 Reviews

Dmytro K. · Reviewed about 3 years ago

Ng Y. · Reviewed about 3 years ago

Saheli D. · Reviewed about 3 years ago

Soundaranayaki K. · Reviewed about 3 years ago

nice

Aaisha F. · Reviewed about 3 years ago

Sadhana P. · Reviewed about 3 years ago

Jonathan W. · Reviewed about 3 years ago

nice

Prajakta P. · Reviewed about 3 years ago

Jerome G. · Reviewed about 3 years 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 about 3 years ago

Martin Emilio R. · Reviewed about 3 years ago

great

Ashlesha k. · Reviewed about 3 years ago

great

Ashlesha k. · Reviewed about 3 years ago

Akshaya Poornitha A. · Reviewed about 3 years ago

Plabani P. · Reviewed about 3 years ago

Gaurav P. · Reviewed about 3 years ago

Suprotik P. · Reviewed about 3 years ago

POULOMI B. · Reviewed about 3 years ago

Muthulakshmi L. · Reviewed about 3 years ago

Dhana LakshmiParvathi P. · Reviewed about 3 years ago

Naragana H. · Reviewed about 3 years ago

Adeola O. · Reviewed about 3 years ago

Cláudio N. · Reviewed about 3 years ago

good

Anjali C. · Reviewed about 3 years ago

Sagar R. · Reviewed about 3 years ago