unnest() used, but still cannot access field text on a value with type ARRAY>, big query

Question

I'm using bigquery to search for patents that contain the word 'metal' in the title. My query:

Then I got the following error message:

I checked the data structure for title_localized: The title_localized array

What I'm doing wrong?

Welcome to Stackoverflow. Please refer https://stackoverflow.com/help/how-to-ask. Share the relevant code snippets you have tried so far. — Nagama Inamdar, Feb 14 '19 at 08:55

score 4 · Accepted Answer · answered Feb 14 '19 at 11:34

4

You can use UNNEST this way to query nested fields:

SELECT
  DISTINCT country_code
FROM
  `patents-public-data.patents.publications`,
  UNNEST(title_localized) AS t
WHERE
  t.text LIKE '%metal%'

answered Feb 14 '19 at 11:34

Juta

1 Answers1