Como trabalhar com dados dos tipos JSON, matriz e struct no BigQuery avaliações

Yash G. · Revisado há over 2 years

Nice

Arghya B. · Revisado há over 2 years

Siyad A. · Revisado há over 2 years

Azmat S. · Revisado há over 2 years

Shantanu S. · Revisado há over 2 years

Dwayne G. · Revisado há over 2 years

Ayush J. · Revisado há over 2 years

sidda G. · Revisado há over 2 years

Artem L. · Revisado há over 2 years

PALASH D. · Revisado há over 2 years

Palash D. · Revisado há over 2 years

Pardha K. · Revisado há over 2 years

Quique A. · Revisado há over 2 years

nice

Argha D. · Revisado há over 2 years

Amol T. · Revisado há over 2 years

very good

Safalta K. · Revisado há over 2 years

It's a little unclear why the UNNEST() is necessary in correlated cross join. When I ran the queries in the last couple of steps without UNNESTING (simply filtering, grouping and ordering, I still got the correct answer. Similarly, I did UNNEST on step 7 where Cross JOIN was introduced and got the correct answer. It's a strong lab, I think I'd just like to see more about some of the nuanced differences between UNNESTing and CROSS JOINING

Anthony C. · Revisado há over 2 years

Manshi R. · Revisado há over 2 years

Rajesh R. · Revisado há over 2 years

Ribca N. · Revisado há over 2 years

Nirmala J. · Revisado há over 2 years

JVS T. · Revisado há over 2 years

asa

Uday Pratap S. · Revisado há over 2 years

Pri P. · Revisado há over 2 years