BigQuery is a scalable and highly efficient data warehouse solution. As we move more and more existing databases into BigQuery with existing structure, some data types are little difficult to query and manipulate, such as “struct” data type.
For example, we may get a data row that may look like this.
In order to query and filter records based on Field, we can use a query similar to below –
SELECT * FROM TABLE_NAME WHERE (SELECT c.value FROM UNNEST(Field) AS c WHERE c.key='key1') = 'value1'
Published by
Ravi Kumar (RK) Yadav
I am machine learning researcher. Currently working on building customer navigation solutions to help customer express intent faster and easier. Such systems are designed to make customer journey faster from search to checkout.
I spend my spare time working on vision projects.
In spring and summer, I spend my time on growing Cayenne pepper.
I graduated from North Carolina State University – Raleigh, with a master’s degree in computer science in the Spring of 2016. Prior to this, I completed my bachelor’s degree in electronics and communication engineering.
RAVI K YADAV 
Leave a Reply