がんばってやってみました！ SELECT JSON_EXTRACT (logdata, '$.userno') AS userno, "{"+ REGEXP_REPLACE ( SPLIT ( JSON_EXTRACT (json, '$.friends'), "},{"), "^\\[\\{|\\}\\]$","") + "}" AS friend FROM serverlog_20150831 これの結果が以下です。 Row userno friend 1 12345 {"userno":1,"nickname":"hogehoge"} 2 12345 {"userno":1,"nickname":"fugafuga"} そして、更にここからjsonをばらしていって SELECT JSON_EXTRACT (logdata, '$.userno') AS userno, JSON_EX
