BigQueryã§JSONæ–‡å—列をä¿å˜ã—ã¦é…列ã«ãªã£ã¦ã„る値を集計ã—ãŸã„å ´åˆã®ã‚„ã‚Šæ–¹ãŒã‚“ã°ã£ã¦ã‚„ã£ã¦ã¿ã¾ã—ãŸï¼ 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
Cloud Computing Services  | Google Cloud
GCP Next – A Google Cloud Platform Experience Tokyo #GCPNext
{{#tags}}- {{label}}
{{/tags}}