Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error. SELECT person FROM `project1.example.table1` WHERE city = "London" How would you correct the error?
A) Add ", UNNEST(person)" before the WHERE clause.
B) Change "person" to "person.city".
C) Change "person" to "city.person".
D) Add ", UNNEST(city)" before the WHERE clause.

Question

Quizplus · Accepted Answer

To access a nested field in BigQuery, you need to use the UNNEST function to flatten the nested structure.

Suppose You Have a Table That Includes a Nested Column