{"title":"group\u5358\u4f4d\u3067\u307e\u3068\u3081\u3066\u3001\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u6587\u5b57\u5217\u306b\u7d50\u5408","height":"190","published":"2017-04-15 16:54:53","url":"https://aitaka.hatenablog.jp/entry/2017/04/15/165453","type":"rich","width":"100%","blog_title":"\u6280\u8853\u30e1\u30e2","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Faitaka.hatenablog.jp%2Fentry%2F2017%2F04%2F15%2F165453\" title=\"group\u5358\u4f4d\u3067\u307e\u3068\u3081\u3066\u3001\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u6587\u5b57\u5217\u306b\u7d50\u5408 - \u6280\u8853\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"aitaka","provider_url":"https://hatena.blog","image_url":null,"categories":["hiveql"],"blog_url":"https://aitaka.hatenablog.jp/","description":"mysql\u3067\u3044\u3046\u300cGROUP_CONCAT\u300d\u3092hiveql\u3067\u3084\u308a\u305f\u3044\u3002 GROUP_CONCAT\u95a2\u6570\u306e\u4fbf\u5229\u3055\u306f\u7570\u5e38 - \u958b\u767a\u306e\u98a8\u666f \u301cKKZ\u306eSE\u65e5\u8a18\u301c \u3053\u306e\u8907\u6570\u884c\u306e\u7d50\u679c\u3092\u3064\u306a\u3052\u3066\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u6587\u5b57\u5217\u306b\u3057\u305f\u3044\u5834\u5408\u3001GROUP_CONCAT\u95a2\u6570\u304c\u4fbf\u5229\u3067\u3059\u3002\u3053\u308c\u3092\u4f7f\u3046\u3068group by\u5358\u4f4d\u3067\u307e\u3068\u3081\u3066\u3001\u30ab\u30f3\u30de\u533a\u5207\u308a\u306e\u6587\u5b57\u5217\u306b\u7d50\u5408\u3057\u3066\u304f\u308c\u307e\u3059\u3002GROUP_CONCAT\u5185\u3067distinct\u3084ordey by\u3082\u304b\u3051\u3089\u308c\u308b\u306e\u3067\u5927\u534a\u306e\u8981\u4ef6\u306f\u6e80\u305f\u305b\u308b\u306f\u305a\u3067\u3059\u3002 \u8a72\u5f53\u3059\u308b\u5024\u3092\u914d\u5217\u306b\u307e\u3068\u3081\u308b\u95a2\u6570\u3092\u4f7f\u3046\u3002collect_list(Col) \u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u51fa\u529b\u3055\u308c\u308b\u5024\u306f\u30e6\u30cb\u30fc\u30af\u5316\u3055\u308c\u306a\u3044\u3002collect_set(Col\u2026","provider_name":"Hatena Blog","version":"1.0","author_url":"https://blog.hatena.ne.jp/aitaka/"}