Google Big Query gives Cannot Access Field page on a value with type ARRAY
<p>I am working on getting the qulifiedVisitor count. the qulifiedVisitor will be the user who searched 'apple' on the website. </p>

<p>but I am getting this Error:</p>

<pre><code>Cannot access filed page on a value with type ARRAY&lt;STRUCT&lt;hitNumber INT64,timeITN64, time64,..&gt;&gt;
</code></pre>

<p>I tried the method that other people provided before, such as using UNNEST(hits), or exist(). However, it still not working.</p>

<p>Please let me know if you have any thoughts.</p>

<p><a href="https://i.stack.imgur.com/ADJDG.png" rel="nofollow noreferrer">Screenshot of the code and error</a>.</p>