Splitting the column to multiple coulmns : `    SELECT
    STRFTIME_UTC_USEC(TimeStamp,"%Y-%m-%d %H:%M:%S") AS TimeStamp,
    Value.provided,
    __key__.app AS ProjectID,
    REGEXP_EXTRACT(__key__.path, r'"hostname"[, ]*"(.*?)"') AS hostname,
    REGEXP_EXTRACT(__key__.path, r'"machine"[, ]*"(.*?)"') AS machine,
    REGEXP_EXTRACT(__key__.path, r'"variable"[, ]*"(.*?)"') AS variable,
    IF(value.provided = 'integer', CAST(value.integer AS STRING),              CAST(value.boolean AS STRING)) AS value
    FROM [spark-test-project-152415:spark_machine_learning.spark_12272016]
    ORDER BY TimeStamp
    LIMIT 100000`


The Above Query extracts a Dataset as in the attached picture. I need to split variable column into multiple columns with values under it. I think it must be done using a sub-query. Could you please help me in getting this started.[enter image description here][1]


  [1]: https://i.stack.imgur.com/EfsoW.png