Cannot access field in Big Query with type ARRAY<STRUCT<hitNumber INT64, time INT64, hour INT64, ...>>
<p>I'm trying to run a query using Standard SQL Dialect (ie not Legacy SQL) on BigQuery. My query is:</p>

<pre><code>SELECT
date, hits.referer
FROM `refresh.ga_sessions_xxxxxx*`
LIMIT 1000
</code></pre>

<p>But keep getting the error </p>

<pre><code>Error: Cannot access field referer on a value with type 
ARRAY&lt;STRUCT&lt;hitNumber INT64, time INT64, hour INT64, ...&gt;&gt; at [2:12]
</code></pre>

<p>Anyone know the proper syntax? </p>