I have a page URL column components of which are delimited by
/. I tried to run the
SPLIT() function in BigQuery but it only gives the first value. I want all values in specific columns.
I don't understand how to use the
Regexp_extract() example mentioned in Split string into multiple columns with bigquery.
I need something similar to
REGEX_SPLIT_TO_TABLE(<String>, <DELIMITER>) which converts a single string into multiple columns.
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