{"height":"190","title":"\u3010BigQuery\u3011string_agg\u306e\u4f7f\u3044\u65b9","blog_title":"\u3061\u3087\u3053\u3063\u3068Python","version":"1.0","provider_name":"Hatena Blog","type":"rich","author_name":"gotto50105010","provider_url":"https://hatena.blog","blog_url":"https://gotto50105010.hatenablog.com/","description":"BigQuery\u306b\u306f\u3001\u30c7\u30fc\u30bf\u52a0\u5de5\u306e\u305f\u3081\u306b\u4fbf\u5229\u306a\u95a2\u6570\u304c\u305f\u304f\u3055\u3093\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002 \u4eca\u56de\u306f\u3001\u8907\u6570\u884c\u306b\u307e\u305f\u304c\u308b\u6587\u5b57\u5217\u306e\u52a0\u5de5\u306b\u4fbf\u5229\u306aSTRING_AGG\u3068\u3044\u3046\u95a2\u6570\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 STRING_AGG\u306b\u3067\u304d\u308b\u3053\u3068 \u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u8cfc\u5165\u3057\u305f\u679c\u7269\u304c\u683c\u7d0d\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308a\u307e\u3059\u3002 \u30e6\u30fc\u30b6\u30fc \u679c\u7269 A \u308a\u3093\u3054 A \u30d0\u30ca\u30ca A \u3044\u3061\u3054 B \u30d0\u30ca\u30ca B \u3055\u304f\u3089\u3093\u307c \u3053\u306e\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u3001\u8cfc\u5165\u3057\u305f\u679c\u7269\u3092\u30e6\u30fc\u30b6\u30fc\u5358\u4f4d\u3067\u307e\u3068\u3081\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u96c6\u8a08\u3057\u305f\u3044\u3068\u304d\u306bSTRING_AGG\u3092\u4f7f\u3044\u307e\u3059\u3002 \u30e6\u30fc\u30b6\u30fc \u679c\u7269 A \u308a\u3093\u3054,\u30d0\u30ca\u30ca,\u3044\u3061\u3054 B \u30d0\u30ca\u30ca,\u3055\u3093\u304f\u3089\u3093\u307c STRING_AGG\u306e\u66f8\u304d\u65b9 \u30e6\u30fc\u30b6\u30fc\u5358\u4f4d\u306b\u8cfc\u5165\u3057\u305f\u679c\u7269\u3092\u2026","width":"100%","image_url":"https://m.media-amazon.com/images/I/61D0XQc0fwL._SL160_.jpg","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fgotto50105010.hatenablog.com%2Fentry%2F2020%2F03%2F28%2F105046\" title=\"\u3010BigQuery\u3011string_agg\u306e\u4f7f\u3044\u65b9 - \u3061\u3087\u3053\u3063\u3068Python\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":[],"url":"https://gotto50105010.hatenablog.com/entry/2020/03/28/105046","author_url":"https://blog.hatena.ne.jp/gotto50105010/","published":"2020-03-28 10:50:46"}