title: BigQuery: SPLIT() returns only one value
body: <p>I have a page URL column components of which are delimited by <code>/</code>. I tried to run the <code>SPLIT()</code> function in BigQuery but it only gives the first value. I want all values in specific columns.</p>
  
  <p>I don't understand how to use the <code>Regexp_extract()</code> example mentioned in <a href="https://stackoverflow.com/questions/22154275/split-string-into-multiple-columns-with-bigquery">Split string into multiple columns with bigquery</a>.</p>
  
  <p>I need something similar to <code>REGEX_SPLIT_TO_TABLE(&lt;String&gt;, &lt;DELIMITER&gt;)</code> which converts a single string into multiple columns.</p>
  
  <p><strong>Query:</strong></p>
  
  <pre><code>SELECT PK, 
  DATE(TIMESTAMP(CONCAT(SUBSTR(date,1,4),'-',SUBSTR(date,5,2),'-',SUBSTR(date,7,2),' 00:00:00'))) as visit_date,
  hits_page_pagePath,
  split(hits_page_pagePath,'/')
  FROM [Intent.All2mon] limit 100
  </code></pre>