{"id":1853,"date":"2022-08-12T17:10:01","date_gmt":"2022-08-12T09:10:01","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=1853"},"modified":"2022-08-12T17:10:01","modified_gmt":"2022-08-12T09:10:01","slug":"inceptor-%e4%b8%ad%e5%88%97%e8%bd%ac%e8%a1%8c%e7%9a%84%e5%ae%9e%e7%8e%b0%e6%96%b9%e5%bc%8f","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=1853","title":{"rendered":"inceptor \u4e2d\u5217\u8f6c\u884c\u7684\u5b9e\u73b0\u65b9\u5f0f"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>\u672c\u7ae0\u4e3b\u8981\u7b80\u5355\u4ecb\u7ecd\u5728 inceptor \u4e2d\u5982\u4f55\u5b9e\u73b0\u5217\u8f6c\u884c\uff0c\u4ee5\u4f9b\u9700\u8981\u65f6\u53c2\u8003\u3002<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<hr \/>\n<p><strong>\u95ee\u9898\uff1a<\/strong><\/p>\n<p>\u5047\u5982\u8868 test_concat \u6709\u5982\u4e0b\u6570\u636e\uff1a<\/p>\n<pre><code>id          code\n1             A\n2             B\n3             C\n1             B\n2             C\n3             A\n1             C\n2             A\n3             B<\/code><\/pre>\n<p>\u60f3\u8981\u5b9e\u73b0\u5982\u4e0b\u6240\u793a\u7ed3\u679c<\/p>\n<pre><code>id         code_map\n1           A-B-C\n2           A-B-C\n3           A-B-C<\/code><\/pre>\n<p><\/br><\/p>\n<p><strong>\u5b9e\u73b0\uff1a<\/strong><\/p>\n<pre><code class=\"language-sql\">-- \u6784\u9020\u6d4b\u8bd5\u6570\u636e\nCREATE TABLE IF NOT EXISTS test_concat(id INT, code STRING)\nCLUSTERED BY (id) INTO 3 BUCKETS \nSTORED AS ORC_TRANSACTION;\n\nBATCHINSERT INTO test_concat BATCHVALUES (\nVALUES (1,'A'), VALUES (2,'B'), VALUES (3,'C'),\nVALUES (1,'B'), VALUES (2,'C'), VALUES (3,'A'),\nVALUES (1,'C'), VALUES (2,'A'), VALUES (3,'B'));<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2020\/02\/image-1581577081740.png\" alt=\"file\" \/><\/p>\n<ol>\n<li>\n<p><strong>\u901a\u8fc7 GROUP_CONCAT  \u5b9e\u73b0<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT id, GROUP_CONCAT(code,'-') code_map FROM test_concat GROUP BY id ORDER BY id;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2020\/02\/image-1581577394219.png\" alt=\"file\" \/><\/p>\n<\/li>\n<li>\n<p><strong>\u901a\u8fc7 CONCAT_WS \u5b9e\u73b0<\/strong><br \/>\n\u5047\u8bbe id \u5bf9\u5e94\u7684 code \u5217\u6570\u636e\u6709\u91cd\u590d\u7684\uff0c\u5982\u4e0b\u56fe<br \/>\n<img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2020\/02\/image-1581577759678.png\" alt=\"file\" \/><\/p>\n<ul>\n<li>\n<p>\u5217\u8f6c\u884c\u65f6\u4e0d\u53bb\u91cd &#8211; COLLECT_LIST<\/p>\n<pre><code class=\"language-sql\">SELECT id, CONCAT_WS('-', COLLECT_LIST(code)) code_map FROM test_concat GROUP BY id ORDER BY id;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2020\/02\/image-1581578001460.png\" alt=\"file\" \/><\/p>\n<\/li>\n<li>\n<p>\u5217\u8f6c\u884c\u65f6\u53bb\u91cd &#8211; COLLECT_SET<\/p>\n<pre><code class=\"language-sql\">SELECT id, CONCAT_WS('-', COLLECT_SET(code)) code_map FROM test_concat GROUP BY id ORDER BY id;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2020\/02\/image-1581578150558.png\" alt=\"file\" \/><\/p>\n<\/li>\n<li>\n<p>\u5217\u8f6c\u884c\u65f6\u53bb\u91cd\u5e76\u6392\u5e8f &#8211; SORT_ARRAY<\/p>\n<pre><code class=\"language-sql\">SELECT id, CONCAT_WS('-', SORT_ARRAY(COLLECT_SET(code))) code_map FROM test_concat GROUP BY id ORDER BY id;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/.\/wp-content\/uploads\/2020\/02\/image-1581578330719.png\" alt=\"file\" \/><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 \u672c\u7ae0\u4e3b\u8981\u7b80\u5355\u4ecb\u7ecd\u5728 inceptor \u4e2d\u5982\u4f55\u5b9e\u73b0\u5217\u8f6c\u884c\uff0c\u4ee5\u4f9b\u9700\u8981\u65f6\u53c2\u8003\u3002 \u8be6\u7ec6\u8bf4\u660e \u95ee\u9898\uff1a \u5047\u5982\u8868  ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=1853\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[115,116,117],"class_list":["post-1853","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-115","tag-concat_ws","tag-group_concat"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1853"}],"version-history":[{"count":1,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1853\/revisions"}],"predecessor-version":[{"id":3450,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1853\/revisions\/3450"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}