title: Query Failed Error: Resources exceeded during query execution: The query could not be executed in the allotted memory
body: <p>I am using Standard SQL.Even though its a basic query it is still throwing errors. Any suggestions pls</p>
  
  <pre><code>SELECT 
    fullVisitorId,
    CONCAT(CAST(fullVisitorId AS string),CAST(visitId AS string)) AS session,
    date,
    visitStartTime,
    hits.time,
    hits.page.pagepath
  FROM
    `XXXXXXXXXX.ga_sessions_*`,
    UNNEST(hits) AS hits
  WHERE
    _TABLE_SUFFIX BETWEEN "20160801"
    AND "20170331"
  ORDER BY
    fullVisitorId,
    date,
    visitStartTime
  </code></pre>