Bekerja dengan JSON, Array, dan Struct di BigQuery Ulasan

Rishav C. · Diulas sekitar 1 bulan lalu

Farheen F. · Diulas sekitar 1 bulan lalu

Ketan S. · Diulas sekitar 1 bulan lalu

Suvojeet P. · Diulas sekitar 1 bulan lalu

Yashpal Singh C. · Diulas sekitar 1 bulan lalu

There was a typo in one of the bullet points in the STRUCTS section where it says "It's own alias" but since it is being used as a possessive pronoun, there should not be a comma and the correct typing would be "Its own alias". Also, the control+F nor the schema filters were working to find the correct count of structs or arrays in the schema within the lab. Not sure if this was an incognito window issue, something do do with the way Chrome loads the data in the page on a MacBook or something else. Either way, I couldn't seem to find the right numbers without guessing. Even my manual scrolling and counting didn't seem to match what the lab questions expected. And one of the last questions/challenges involved finding the racer with a 23.2 split_time. The solution required me to use UNNEST() but it worked without this. Gemini says that's because the comma implicitly UNNESTS but I don't recall seeing that explanation in the lab. I remember seeing that on implicitly cross joining, but not for unnesting.

Andrew F. · Diulas sekitar 1 bulan lalu

Biswanath P. · Diulas sekitar 1 bulan lalu

Diptesh C. · Diulas sekitar 1 bulan lalu

Umair A. · Diulas sekitar 1 bulan lalu

Eitaro T. · Diulas sekitar 1 bulan lalu

Anjali K. · Diulas sekitar 1 bulan lalu

Cloud Storage バケットがなく、ファイルを参照できないためファイル構造を指定できなかったため、進行できないで終了した

秀人 Hideto Shibao 芝. · Diulas sekitar 1 bulan lalu

Marko P. · Diulas sekitar 1 bulan lalu

Martina C. · Diulas sekitar 1 bulan lalu

Ronald Alejandro R. · Diulas sekitar 1 bulan lalu

poornima S. · Diulas sekitar 1 bulan lalu

Chakka Chenna J. · Diulas sekitar 1 bulan lalu

Abdul Mazeed S. · Diulas sekitar 1 bulan lalu

Kaori S. · Diulas sekitar 1 bulan lalu

Aline A. · Diulas sekitar 1 bulan lalu

Dmitrii D. · Diulas sekitar 1 bulan lalu

Swastika M. · Diulas sekitar 1 bulan lalu

Devendra V. · Diulas sekitar 1 bulan lalu

Peng T. · Diulas sekitar 1 bulan lalu

david b. · Diulas sekitar 1 bulan lalu