Valid GCP-DE Dumps shared by ExamDiscuss.com for Helping Passing GCP-DE Exam! ExamDiscuss.com now offer the newest GCP-DE exam dumps, the ExamDiscuss.com GCP-DE exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com GCP-DE dumps with Test Engine here:
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?
Correct Answer: A
To access the person.city column, you need to "UNNEST(person)" and JOIN it to table1 using a comma. Reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql#nested_repeated_resu