{"id":2047,"date":"2023-06-22T07:34:35","date_gmt":"2023-06-21T23:34:35","guid":{"rendered":"http:\/\/viplao.com\/?p=2047"},"modified":"2023-06-22T07:34:37","modified_gmt":"2023-06-21T23:34:37","slug":"flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/","title":{"rendered":"Flink SQL &#8211; \u552f\u54c1\u4f1aflink\u5b9e\u8df5\u4e0e\u4f18\u5316"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_71 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u6587\u7ae0\u76ee\u5f55<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/#%E4%B8%80_%E3%80%81%E5%8F%91%E5%B1%95%E6%A6%82%E8%A7%88\" title=\"\u4e00 \u3001\u53d1\u5c55\u6982\u89c8\">\u4e00 \u3001\u53d1\u5c55\u6982\u89c8<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/#%E4%BA%8C%E3%80%81Flink_%E5%AE%B9%E5%99%A8%E5%8C%96%E5%AE%9E%E8%B7%B5\" title=\"\u4e8c\u3001Flink \u5bb9\u5668\u5316\u5b9e\u8df5\">\u4e8c\u3001Flink \u5bb9\u5668\u5316\u5b9e\u8df5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/#%E4%B8%89%E3%80%81Flink_SQL_%E5%B9%B3%E5%8F%B0%E5%8C%96%E5%BB%BA%E8%AE%BE\" title=\"\u4e09\u3001Flink SQL \u5e73\u53f0\u5316\u5efa\u8bbe\">\u4e09\u3001Flink SQL \u5e73\u53f0\u5316\u5efa\u8bbe<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/#%E5%9B%9B%E3%80%81%E5%BA%94%E7%94%A8%E6%A1%88%E4%BE%8B\" title=\"\u56db\u3001\u5e94\u7528\u6848\u4f8b\">\u56db\u3001\u5e94\u7528\u6848\u4f8b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/#%E4%BA%94%E3%80%81%E6%9C%AA%E6%9D%A5%E8%A7%84%E5%88%92\" title=\"\u4e94\u3001\u672a\u6765\u89c4\u5212\">\u4e94\u3001\u672a\u6765\u89c4\u5212<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%80_%E3%80%81%E5%8F%91%E5%B1%95%E6%A6%82%E8%A7%88\"><\/span>\u4e00 \u3001\u53d1\u5c55\u6982\u89c8<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5e73\u53f0\u652f\u6301\u516c\u53f8\u5185\u90e8\u6240\u6709\u90e8\u95e8\u7684\u5b9e\u65f6\u8ba1\u7b97\u5e94\u7528\u3002\u4e3b\u8981\u7684\u4e1a\u52a1\u5305\u62ec\u5b9e\u65f6\u5927\u5c4f\u3001\u63a8\u8350\u3001\u5b9e\u9a8c\u5e73\u53f0\u3001\u5b9e\u65f6\u76d1\u63a7\u548c\u5b9e\u65f6\u6570\u636e\u6e05\u6d17\u7b49\u3002<\/p>\n\n\n\n<p><strong>1.1 \u96c6\u7fa4\u89c4\u6a21<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-4eac44737e99f30b1cbee2d28ea4b920_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5e73\u53f0\u73b0\u6709\u5f02\u5730\u53cc\u673a\u623f\u53cc\u96c6\u7fa4\uff0c\u5177\u6709 2000 \u591a\u7684\u7269\u7406\u673a\u8282\u70b9\uff0c\u5229\u7528 k8s \u7684 namespaces\uff0clabels \u548c taints \u7b49\uff0c\u5b9e\u73b0\u4e1a\u52a1\u9694\u79bb\u4ee5\u53ca\u521d\u6b65\u7684\u8ba1\u7b97\u8d1f\u8f7d\u9694\u79bb\u3002\u76ee\u524d\u7ebf\u4e0a\u5b9e\u65f6\u5e94\u7528\u6709\u5927\u6982 1000 \u4e2a\uff0c\u5e73\u53f0\u6700\u8fd1\u4e3b\u8981\u652f\u6301 Flink SQL \u4efb\u52a1\u7684\u4e0a\u7ebf\u3002<\/p>\n\n\n\n<p><strong>1.2 \u5e73\u53f0\u67b6\u6784<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-01535eda41fdf8dc3b5eb16795feb559_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<ul>\n<li>\u4e0a\u56fe\u662f\u552f\u54c1\u4f1a\u5b9e\u65f6\u8ba1\u7b97\u5e73\u53f0\u7684\u6574\u4f53\u67b6\u6784\u3002<\/li>\n\n\n\n<li>\u6700\u5e95\u5c42\u662f\u8ba1\u7b97\u4efb\u52a1\u8282\u70b9\u7684\u8d44\u6e90\u8c03\u5ea6\u5c42\uff0c\u5b9e\u9645\u662f\u4ee5 deployment \u7684\u6a21\u5f0f\u8fd0\u884c\u5728 k8s \u4e0a\uff0c\u5e73\u53f0\u867d\u7136\u652f\u6301 yarn \u8c03\u5ea6\uff0c\u4f46\u662f yarn \u8c03\u5ea6\u662f\u4e0e\u6279\u4efb\u52a1\u5171\u4eab\u8d44\u6e90\uff0c\u6240\u4ee5\u4e3b\u6d41\u4efb\u52a1\u8fd8\u662f\u8fd0\u884c\u5728 k8s \u4e0a\u3002<\/li>\n\n\n\n<li>\u5b58\u50a8\u5c42\u8fd9\u4e00\u5c42\uff0c\u652f\u6301\u516c\u53f8\u5185\u90e8\u57fa\u4e8e kafka \u5b9e\u65f6\u6570\u636e vms\uff0c\u57fa\u4e8e binlog \u7684 vdp \u6570\u636e\u548c\u539f\u751f kafka \u4f5c\u4e3a\u6d88\u606f\u603b\u7ebf\uff0c\u72b6\u6001\u5b58\u50a8\u5728 hdfs \u4e0a\uff0c\u6570\u636e\u4e3b\u8981\u5b58\u5165 redis\uff0cmysql\uff0chbase\uff0ckudu\uff0cclickhouse \u7b49\u3002<\/li>\n\n\n\n<li>\u8ba1\u7b97\u5f15\u64ce\u5c42\uff0c\u5e73\u53f0\u652f\u6301 Flink\uff0cSpark\uff0cStorm \u4e3b\u6d41\u6846\u67b6\u5bb9\u5668\u5316\uff0c\u63d0\u4f9b\u4e86\u4e00\u4e9b\u6846\u67b6\u7684\u5c01\u88c5\u548c\u7ec4\u4ef6\u7b49\u3002\u6bcf\u4e2a\u6846\u67b6\u4f1a\u90fd\u4f1a\u652f\u6301\u51e0\u4e2a\u7248\u672c\u7684\u955c\u50cf\u6ee1\u8db3\u4e0d\u540c\u7684\u4e1a\u52a1\u9700\u6c42\u3002<\/li>\n\n\n\n<li>\u5e73\u53f0\u5c42\u63d0\u4f9b\u4f5c\u4e1a\u914d\u7f6e\u3001\u8c03\u5ea6\u3001\u7248\u672c\u7ba1\u7406\u3001\u5bb9\u5668\u76d1\u63a7\u3001job \u76d1\u63a7\u3001\u544a\u8b66\u3001\u65e5\u5fd7\u7b49\u529f\u80fd\uff0c\u63d0\u4f9b\u591a\u79df\u6237\u7684\u8d44\u6e90\u7ba1\u7406\uff08quota\uff0clabel \u7ba1\u7406\uff09\uff0c\u63d0\u4f9b kafka \u76d1\u63a7\u3002\u5728 Flink 1.11 \u7248\u672c\u4e4b\u524d\uff0c\u5e73\u53f0\u81ea\u5efa\u5143\u6570\u636e\u7ba1\u7406\u7cfb\u7edf\u4e3a Flink SQL \u7ba1\u7406 schema\uff0c1.11 \u7248\u672c\u5f00\u59cb\uff0c\u901a\u8fc7 hive metastore \u4e0e\u516c\u53f8\u5143\u6570\u636e\u7ba1\u7406\u7cfb\u7edf\u878d\u5408\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u6700\u4e0a\u5c42\u5c31\u662f\u5404\u4e2a\u4e1a\u52a1\u7684\u5e94\u7528\u5c42\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BA%8C%E3%80%81Flink_%E5%AE%B9%E5%99%A8%E5%8C%96%E5%AE%9E%E8%B7%B5\"><\/span>\u4e8c\u3001Flink \u5bb9\u5668\u5316\u5b9e\u8df5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>2.1 \u5bb9\u5668\u5316\u5b9e\u8df5<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-955c20464f2f3dc192a317b888432b2f_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4e0a\u56fe\u662f\u5b9e\u65f6\u5e73\u53f0 Flink \u5bb9\u5668\u5316\u7684\u67b6\u6784\u3002Flink \u5bb9\u5668\u5316\u662f\u57fa\u4e8e standalone \u6a21\u5f0f\u90e8\u7f72\u7684\u3002<\/p>\n\n\n\n<ul>\n<li>\u90e8\u7f72\u6a21\u5f0f\u5171\u6709 client\uff0cjobmanager \u548c taskmanager \u4e09\u4e2a\u89d2\u8272\uff0c\u6bcf\u4e00\u4e2a\u89d2\u8272\u90fd\u7531\u4e00\u4e2a deployment \u63a7\u5236\u3002<\/li>\n\n\n\n<li>\u7528\u6237\u901a\u8fc7\u5e73\u53f0\u4e0a\u4f20\u4efb\u52a1 jar \u5305\uff0c\u914d\u7f6e\u7b49\uff0c\u5b58\u50a8\u4e8e hdfs \u4e0a\u3002\u540c\u65f6\u7531\u5e73\u53f0\u7ef4\u62a4\u7684\u914d\u7f6e\uff0c\u4f9d\u8d56\u7b49\u4e5f\u5b58\u50a8\u5728 hdfs \u4e0a\uff0c\u5f53 pod \u542f\u52a8\u65f6\uff0c\u4f1a\u8fdb\u884c\u62c9\u53d6\u7b49\u521d\u59cb\u5316\u64cd\u4f5c\u3002<\/li>\n\n\n\n<li>client \u4e2d\u4e3b\u8fdb\u7a0b\u662f\u4e00\u4e2a\u7531 go \u5f00\u53d1\u7684 agent\uff0c\u5f53 client \u542f\u52a8\u65f6\uff0c\u4f1a\u9996\u5148\u68c0\u67e5\u96c6\u7fa4\u72b6\u6001\uff0c\u5f53\u96c6\u7fa4 ready \u540e\uff0c\u4ece hdfs \u4e0a\u62c9\u53d6 jar \u5305\u5411 Flink \u96c6\u7fa4\u63d0\u4ea4\u4efb\u52a1\u3002\u540c\u65f6\uff0cclient \u7684\u4e3b\u8981\u529f\u80fd\u8fd8\u6709\u76d1\u63a7\u4efb\u52a1\u72b6\u6001\uff0c\u505a savepoint \u7b49\u64cd\u4f5c\u3002<\/li>\n\n\n\n<li>\u901a\u8fc7\u90e8\u7f72\u5728\u6bcf\u53f0\u7269\u7406\u673a\u4e0a\u7684 smart &#8211; agent \u91c7\u96c6\u5bb9\u5668\u7684\u6307\u6807\u5199\u5165 m3\uff0c\u4ee5\u53ca\u901a\u8fc7 Flink \u66b4\u6f0f\u7684\u63a5\u53e3\u5c06 metrics \u5199\u5165 prometheus\uff0c\u7ed3\u5408 grafana \u5c55\u793a\u3002\u540c\u6837\u901a\u8fc7\u90e8\u7f72\u5728\u6bcf\u53f0\u7269\u7406\u673a\u4e0a\u7684 vfilebeat \u91c7\u96c6\u6302\u8f7d\u51fa\u6765\u7684\u76f8\u5173\u65e5\u5fd7\u5199\u5165 es\uff0c\u5728 dragonfly \u53ef\u4ee5\u5b9e\u73b0\u65e5\u5fd7\u68c0\u7d22\u3002<\/li>\n<\/ul>\n\n\n\n<p>Flink \u5e73\u53f0\u5316<\/p>\n\n\n\n<p>\u5728\u5b9e\u8df5\u8fc7\u7a0b\u4e2d\uff0c\u7ed3\u5408\u5177\u4f53\u573a\u666f\u4ee5\u53ca\u6613\u7528\u6027\u8003\u8651\uff0c\u505a\u4e86\u5e73\u53f0\u5316\u5de5\u4f5c\u3002<\/p>\n\n\n\n<ul>\n<li>\u5e73\u53f0\u7684\u4efb\u52a1\u914d\u7f6e\u4e0e\u955c\u50cf\uff0cFlink \u914d\u7f6e\uff0c\u81ea\u5b9a\u4e49\u7ec4\u4ef6\u7b49\u89e3\u8026\u5408\uff0c\u73b0\u9636\u6bb5\u5e73\u53f0\u652f\u6301 1.7\u30011.9\u30011.11\u30011.12 \u7b49\u7248\u672c\u3002<\/li>\n\n\n\n<li>\u5e73\u53f0\u652f\u6301\u6d41\u6c34\u7ebf\u7f16\u8bd1\u6216\u4e0a\u4f20 jar\u3001\u4f5c\u4e1a\u914d\u7f6e\u3001\u544a\u8b66\u914d\u7f6e\u3001\u751f\u547d\u5468\u671f\u7ba1\u7406\u7b49\uff0c\u4ece\u800c\u51cf\u5c11\u7528\u6237\u7684\u5f00\u53d1\u6210\u672c\u3002<\/li>\n\n\n\n<li>\u5e73\u53f0\u5f00\u53d1\u4e86\u5bb9\u5668\u7ea7\u522b\u7684\u5982\u706b\u7130\u56fe\u7b49\u8c03\u4f18\u8bca\u65ad\u7684\u9875\u9762\u5316\u529f\u80fd\uff0c\u4ee5\u53ca\u767b\u9646\u5bb9\u5668\u7684\u529f\u80fd\uff0c\u652f\u6301\u7528\u6237\u8fdb\u884c\u4f5c\u4e1a\u8bca\u65ad\u3002<\/li>\n<\/ul>\n\n\n\n<p>Flink \u7a33\u5b9a\u6027<\/p>\n\n\n\n<p>\u5728\u5e94\u7528\u90e8\u7f72\u548c\u8fd0\u884c\u8fc7\u7a0b\u4e2d\uff0c\u4e0d\u53ef\u907f\u514d\u7684\u4f1a\u51fa\u73b0\u5f02\u5e38\u3002\u4ee5\u4e0b\u662f\u5e73\u53f0\u4fdd\u8bc1\u4efb\u52a1\u5728\u51fa\u73b0\u5f02\u5e38\u72b6\u51b5\u540e\u7684\u7a33\u5b9a\u6027\u505a\u7684\u7b56\u7565\u3002<\/p>\n\n\n\n<ul>\n<li>pod \u7684\u5065\u5eb7\u548c\u53ef\u7528\uff0c\u7531 livenessProbe \u548c readinessProbe \u68c0\u6d4b\uff0c\u540c\u65f6\u6307\u5b9a pod \u7684\u91cd\u542f\u7b56\u7565\u3002<\/li>\n\n\n\n<li>Flink \u4efb\u52a1\u5f02\u5e38\u65f6\uff1a<\/li>\n\n\n\n<li>1.Flink \u539f\u751f\u7684 restart \u7b56\u7565\u548c failover \u673a\u5236\uff0c\u4f5c\u4e3a\u7b2c\u4e00\u5c42\u7684\u4fdd\u8bc1\u3002<br>2.\u5728 client \u4e2d\u4f1a\u5b9a\u65f6\u76d1\u63a7 Flink \u72b6\u6001\uff0c\u540c\u65f6\u5c06\u6700\u65b0\u7684 checkpoint \u5730\u5740\u66f4\u65b0\u5230\u81ea\u5df1\u7684\u7f13\u5b58\u4e2d\uff0c\u5e76\u6c47\u62a5\u5230\u5e73\u53f0\uff0c\u56fa\u5316\u5230 MySQL \u4e2d\u3002\u5f53 Flink \u65e0\u6cd5\u518d\u91cd\u542f\u65f6\uff0c\u7531 client \u91cd\u65b0\u4ece\u6700\u65b0\u7684\u6210\u529f checkpoint \u63d0\u4ea4\u4efb\u52a1\u3002\u4f5c\u4e3a\u7b2c\u4e8c\u5c42\u4fdd\u8bc1\u3002\u8fd9\u4e00\u5c42\u5c06 checkpoint \u56fa\u5316\u5230 MySQL \u4e2d\u540e\uff0c\u5c31\u4e0d\u518d\u4f7f\u7528 Flink HA \u673a\u5236\u4e86\uff0c\u5c11\u4e86 zk \u7684\u7ec4\u4ef6\u4f9d\u8d56\u30023.\u5f53\u524d\u4e24\u5c42\u65e0\u6cd5\u91cd\u542f\u65f6\u6216\u96c6\u7fa4\u51fa\u73b0\u5f02\u5e38\u65f6\uff0c\u7531\u5e73\u53f0\u81ea\u52a8\u4ece\u56fa\u5316\u5230 MySQL \u4e2d\u7684\u6700\u65b0 chekcpoint \u91cd\u65b0\u62c9\u8d77\u4e00\u4e2a\u96c6\u7fa4\uff0c\u63d0\u4ea4\u4efb\u52a1\uff0c\u4f5c\u4e3a\u7b2c\u4e09\u5c42\u4fdd\u8bc1\u3002<\/li>\n\n\n\n<li>\u673a\u623f\u5bb9\u707e\uff1a\u7528\u6237\u7684 jar \u5305\uff0ccheckpoint \u90fd\u505a\u4e86\u5f02\u5730\u53cc HDFS \u5b58\u50a8\u5f02\u5730\u53cc\u673a\u623f\u53cc\u96c6\u7fa4<\/li>\n<\/ul>\n\n\n\n<p><strong>2.2 kafka \u76d1\u63a7\u65b9\u6848<\/strong><\/p>\n\n\n\n<p>kafka \u76d1\u63a7\u662f\u6211\u4eec\u7684\u4efb\u52a1\u76d1\u63a7\u91cc\u76f8\u5bf9\u91cd\u8981\u7684\u4e00\u90e8\u5206\uff0c\u6574\u4f53\u76d1\u63a7\u6d41\u7a0b\u5982\u4e0b\u6240\u793a\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-309e27fa6d63cdff62f04a764551545b_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5e73\u53f0\u63d0\u4f9b\u76d1\u63a7 kafka \u5806\u79ef\uff0c\u6d88\u8d39 message \u7b49\u914d\u7f6e\u4fe1\u606f\uff0c\u4ece MySQL \u4e2d\u5c06\u7528\u6237 kafka \u76d1\u63a7\u914d\u7f6e\u63d0\u53d6\u540e\uff0c\u901a\u8fc7 jmx \u76d1\u63a7 kafka\uff0c\u5199\u5165\u4e0b\u6e38 kafka\uff0c\u518d\u901a\u8fc7\u53e6\u4e00\u4e2a Flink \u4efb\u52a1\u5b9e\u65f6\u76d1\u63a7\uff0c\u540c\u65f6\u5c06\u8fd9\u4e9b\u6570\u636e\u5199\u5165 ck\uff0c\u4ece\u800c\u5c55\u793a\u7ed9\u7528\u6237\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%89%E3%80%81Flink_SQL_%E5%B9%B3%E5%8F%B0%E5%8C%96%E5%BB%BA%E8%AE%BE\"><\/span>\u4e09\u3001Flink SQL \u5e73\u53f0\u5316\u5efa\u8bbe<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u57fa\u4e8e k8s \u7684 Flink \u5bb9\u5668\u5316\u5b9e\u73b0\u4ee5\u540e\uff0c\u65b9\u4fbf\u4e86 Flink api \u5e94\u7528\u7684\u53d1\u5e03\uff0c\u4f46\u662f\u5bf9\u4e8e Flink SQL \u7684\u4efb\u52a1\u4ecd\u7136\u4e0d\u591f\u4fbf\u6377\u3002\u4e8e\u662f\u5e73\u53f0\u63d0\u4f9b\u4e86\u66f4\u52a0\u65b9\u4fbf\u7684\u5728\u7ebf\u7f16\u8f91\u53d1\u5e03\u3001SQL \u7ba1\u7406\u7b49\u4e00\u6808\u5f0f\u5f00\u53d1\u5e73\u53f0\u3002<\/p>\n\n\n\n<p><strong>3.1 Flink SQL \u65b9\u6848<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/80\/v2-0ca4d44ca459f8eeea7b108a6a7ee436_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5e73\u53f0\u7684 Flink SQL \u65b9\u6848\u5982\u4e0a\u56fe\u6240\u793a\uff0c\u4efb\u52a1\u53d1\u5e03\u7cfb\u7edf\u4e0e\u5143\u6570\u636e\u7ba1\u7406\u7cfb\u7edf\u5b8c\u5168\u89e3\u8026\u3002<\/p>\n\n\n\n<p>Flink SQL \u4efb\u52a1\u53d1\u5e03\u5e73\u53f0\u5316<\/p>\n\n\n\n<p>\u5728\u5b9e\u8df5\u8fc7\u7a0b\u4e2d\uff0c\u7ed3\u5408\u6613\u7528\u6027\u8003\u8651\uff0c\u505a\u4e86\u5e73\u53f0\u5316\u5de5\u4f5c\uff0c\u4e3b\u64cd\u4f5c\u754c\u9762\u5982\u4e0b\u56fe\u6240\u793a:<\/p>\n\n\n\n<ul>\n<li>Flink SQL \u7684\u7248\u672c\u7ba1\u7406\uff0c\u8bed\u6cd5\u6821\u9a8c\uff0c\u62d3\u6251\u56fe\u7ba1\u7406\u7b49\uff1b<\/li>\n\n\n\n<li>UDF \u901a\u7528\u548c\u4efb\u52a1\u7ea7\u522b\u7684\u7ba1\u7406\uff0c\u652f\u6301\u7528\u6237\u81ea\u5b9a\u4e49 UDF\uff1b<\/li>\n\n\n\n<li>\u63d0\u4f9b\u53c2\u6570\u5316\u7684\u914d\u7f6e\u754c\u9762\uff0c\u65b9\u4fbf\u7528\u6237\u4e0a\u7ebf\u4efb\u52a1\u3002<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-efc2bbc9ddab71a20c03b1e2c4331205_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/80\/v2-b34d0a2309246f867340d749235420ca_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u5143\u6570\u636e\u7ba1\u7406<\/p>\n\n\n\n<p>\u5e73\u53f0\u5728 1.11 \u4e4b\u524d\u901a\u8fc7\u6784\u5efa\u81ea\u5df1\u7684\u5143\u6570\u636e\u7ba1\u7406\u7cfb\u7edf UDM\uff0cMySQL \u5b58\u50a8 kafka\uff0credis \u7b49 schema\uff0c\u901a\u8fc7\u81ea\u5b9a\u4e49 catalog \u6253\u901a Flink \u4e0e UDM\uff0c\u4ece\u800c\u5b9e\u73b0\u5143\u6570\u636e\u7ba1\u7406\u30021.11 \u4e4b\u540e\uff0cFlink \u96c6\u6210 hive \u9010\u6e10\u5b8c\u5584\uff0c\u5e73\u53f0\u91cd\u6784\u4e86 FlinkSQL \u6846\u67b6\uff0c\u901a\u8fc7\u90e8\u7f72\u4e00\u4e2a SQL &#8211; gateway service \u670d\u52a1\uff0c\u4e2d\u95f4\u8c03\u7528\u81ea\u5df1\u7ef4\u62a4\u7684 SQL &#8211; client jar \u5305\uff0c\u4ece\u800c\u4e0e\u79bb\u7ebf\u5143\u6570\u636e\u6253\u901a\uff0c\u5b9e\u73b0\u4e86\u5b9e\u65f6\u79bb\u7ebf\u5143\u6570\u636e\u7edf\u4e00\uff0c\u4e3a\u4e4b\u540e\u7684\u6d41\u6279\u4e00\u4f53\u505a\u597d\u5de5\u4f5c\u3002\u5728\u5143\u6570\u636e\u7ba1\u7406\u7cfb\u7edf\u521b\u5efa\u7684 Flink \u8868\u64cd\u4f5c\u754c\u9762\u5982\u4e0b\u6240\u793a\uff0c\u521b\u5efa Flink \u8868\u7684\u5143\u6570\u636e\uff0c\u6301\u4e45\u5316\u5230 hive\u91cc\uff0cFlink SQL \u542f\u52a8\u65f6\u4ece hive \u91cc\u8bfb\u53d6\u5bf9\u5e94\u8868\u7684 table schema \u4fe1\u606f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-8dbe1b2f9b224ac9ee34884ca47d462c_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong>3.2 Flink SQL \u76f8\u5173\u5b9e\u8df5<\/strong><\/p>\n\n\n\n<p>\u5e73\u53f0\u5bf9\u4e8e\u5b98\u65b9\u539f\u751f\u652f\u6301\u6216\u8005\u4e0d\u652f\u6301\u7684 connector \u8fdb\u884c\u6574\u5408\u548c\u5f00\u53d1\uff0c\u955c\u50cf\u548c connector\uff0cformat \u7b49\u76f8\u5173\u4f9d\u8d56\u8fdb\u884c\u89e3\u8026\uff0c\u53ef\u4ee5\u5feb\u6377\u7684\u8fdb\u884c\u66f4\u65b0\u4e0e\u8fed\u4ee3\u3002<\/p>\n\n\n\n<p>FLINK SQL \u76f8\u5173\u5b9e\u8df5<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-49814f71f6ea0b7397face92f8f462fc_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<ul>\n<li>connector \u5c42\uff0c\u73b0\u9636\u6bb5\u5e73\u53f0\u652f\u6301\u5b98\u65b9\u652f\u6301\u7684 connector\uff0c\u5e76\u4e14\u6784\u5efa\u4e86 redis\uff0ckudu\uff0cclickhouse\uff0cvms\uff0cvdp \u7b49\u5e73\u53f0\u5185\u90e8\u7684 connector\u3002\u5e73\u53f0\u6784\u5efa\u4e86\u5185\u90e8\u7684 pb format\uff0c\u652f\u6301 protobuf \u5b9e\u65f6\u6e05\u6d17\u6570\u636e\u7684\u8bfb\u53d6\u3002\u5e73\u53f0\u6784\u5efa\u4e86 kudu\uff0cvdp \u7b49\u5185\u90e8 catalog\uff0c\u652f\u6301\u76f4\u63a5\u8bfb\u53d6\u76f8\u5173\u7684 schema\uff0c\u4e0d\u7528\u518d\u521b\u5efa ddl\u3002<\/li>\n\n\n\n<li>\u5e73\u53f0\u5c42\u4e3b\u8981\u662f\u5728 UDF\u3001\u5e38\u7528\u8fd0\u884c\u53c2\u6570\u8c03\u6574\u3001\u4ee5\u53ca\u5347\u7ea7 hadoop3\u3002<\/li>\n\n\n\n<li>runntime \u5c42\u4e3b\u8981\u662f\u652f\u6301\u62d3\u6251\u56fe\u6267\u884c\u8ba1\u5212\u4fee\u6539\u3001\u7ef4\u8868\u5173\u8054 keyBy cache \u4f18\u5316\u7b49<\/li>\n<\/ul>\n\n\n\n<p>\u62d3\u6251\u56fe\u6267\u884c\u8ba1\u5212\u4fee\u6539<\/p>\n\n\n\n<p>\u9488\u5bf9\u73b0\u9636\u6bb5 SQL \u751f\u6210\u7684 stream graph \u5e76\u884c\u5ea6\u65e0\u6cd5\u4fee\u6539\u7b49\u95ee\u9898\uff0c\u5e73\u53f0\u63d0\u4f9b\u53ef\u4fee\u6539\u7684\u62d3\u6251\u9884\u89c8\u4fee\u6539\u76f8\u5173\u53c2\u6570\u3002\u5e73\u53f0\u4f1a\u5c06\u89e3\u6790\u540e\u7684 FlinkSQL \u7684 excution plan json \u63d0\u4f9b\u7ed9\u7528\u6237\uff0c\u5229\u7528 uid \u4fdd\u8bc1\u7b97\u5b50\u7684\u552f\u4e00\u6027\uff0c\u4fee\u6539\u6bcf\u4e2a\u7b97\u5b50\u7684\u5e76\u884c\u5ea6\uff0cchain \u7b56\u7565\u7b49\uff0c\u4e5f\u4e3a\u7528\u6237\u89e3\u51b3\u53cd\u538b\u95ee\u9898\u63d0\u4f9b\u65b9\u6cd5\u3002\u4f8b\u5982\u9488\u5bf9 clickhouse sink \u5c0f\u5e76\u53d1\u5927\u6279\u6b21\u7684\u573a\u666f\uff0c\u6211\u4eec\u652f\u6301\u4fee\u6539 clickhouse sink \u5e76\u884c\u5ea6\uff0csource \u5e76\u884c\u5ea6 = 72\uff0csink \u5e76\u884c\u5ea6 = 24\uff0c\u63d0\u9ad8 clickhouse sink tps\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-07e5ea25243a1f74e96bc650cd7e2867_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u7ef4\u8868\u5173\u8054 keyBy \u4f18\u5316 cache<\/p>\n\n\n\n<p>\u9488\u5bf9\u7ef4\u8868\u5173\u8054\u7684\u60c5\u51b5\uff0c\u4e3a\u4e86\u964d\u4f4e IO \u8bf7\u6c42\u6b21\u6570\uff0c\u964d\u4f4e\u7ef4\u8868\u6570\u636e\u5e93\u8bfb\u538b\u529b\uff0c\u4ece\u800c\u964d\u4f4e\u5ef6\u8fdf\uff0c\u63d0\u9ad8\u541e\u5410\uff0c\u6709\u4ee5\u4e0b\u51e0\u79cd\u63aa\u65bd\uff1a<\/p>\n\n\n\n<ul>\n<li>\u5f53\u7ef4\u8868\u6570\u636e\u91cf\u4e0d\u5927\u65f6\uff0c\u901a\u8fc7\u5168\u91cf\u7ef4\u8868\u6570\u636e\u7f13\u5b58\u5728\u672c\u5730\uff0c\u540c\u65f6 ttl \u63a7\u5236\u7f13\u5b58\u5237\u65b0\u7684\u65f6\u5019\uff0c\u8fd9\u53ef\u4ee5\u6781\u5927\u7684\u964d\u4f4e IO \u8bf7\u6c42\u6b21\u6570\uff0c\u4f46\u4f1a\u8981\u6c42\u66f4\u591a\u7684\u5185\u5b58\u7a7a\u95f4\u3002<\/li>\n\n\n\n<li>\u5f53\u7ef4\u8868\u6570\u636e\u91cf\u5f88\u5927\u65f6\uff0c\u901a\u8fc7 async \u548c LRU cache \u7b56\u7565\uff0c\u540c\u65f6 ttl \u548c size \u6765\u63a7\u5236\u7f13\u5b58\u6570\u636e\u7684\u5931\u6548\u65f6\u95f4\u548c\u7f13\u5b58\u5927\u5c0f\uff0c\u53ef\u4ee5\u63d0\u9ad8\u541e\u5410\u7387\u5e76\u964d\u4f4e\u6570\u636e\u5e93\u7684\u8bfb\u538b\u529b\u3002<\/li>\n\n\n\n<li>\u5f53\u7ef4\u8868\u6570\u636e\u91cf\u5f88\u5927\u540c\u65f6\u4e3b\u6d41 qps \u5f88\u9ad8\u65f6\uff0c\u53ef\u4ee5\u5f00\u542f\u628a\u7ef4\u8868 join \u7684 key \u4f5c\u4e3a hash \u7684\u6761\u4ef6\uff0c\u5c06\u6570\u636e\u8fdb\u884c\u5206\u533a\uff0c\u5373\u5728 calc \u8282\u70b9\u7684\u5206\u533a\u7b56\u7565\u662f hash\uff0c\u8fd9\u6837\u4e0b\u6e38\u7b97\u5b50\u7684 subtask \u7684\u7ef4\u8868\u6570\u636e\u662f\u72ec\u7acb\u7684\uff0c\u4e0d\u4ec5\u53ef\u4ee5\u63d0\u9ad8\u547d\u4e2d\u7387\uff0c\u4e5f\u53ef\u964d\u4f4e\u5185\u5b58\u4f7f\u7528\u7a7a\u95f4\u3002<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/80\/v2-6ed1decf81722878845b808734676842_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4f18\u5316\u4e4b\u524d\u7ef4\u8868\u5173\u8054 LookupJoin \u7b97\u5b50\u548c\u6b63\u5e38\u7b97\u5b50 chain \u5728\u4e00\u8d77\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-a468b190172f549900282a5dd1ca20e7_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u4f18\u5316\u4e4b\u95f4\u7ef4\u8868\u5173\u8054 LookupJoin \u7b97\u5b50\u548c\u6b63\u5e38\u7b97\u5b50\u4e0d chain \u5728\u4e00\u8d77\uff0c\u5c06 join key \u4f5c\u4e3a hash \u7b56\u7565\u7684 key\u3002\u91c7\u7528\u8fd9\u79cd\u65b9\u5f0f\u4f18\u5316\u4e4b\u540e\uff0c\u4f8b\u5982\u539f\u5148 3000W \u6570\u636e\u91cf\u7684\u7ef4\u8868\uff0c10 \u4e2a TM \u8282\u70b9\uff0c\u6bcf\u4e2a\u8282\u70b9\u90fd\u8981\u7f13\u5b58 3000W \u7684\u6570\u636e\uff0c\u603b\u5171\u9700\u8981\u7f13\u5b58 3000W * 10 = 3 \u4ebf\u7684\u91cf\u3002\u800c\u7ecf\u8fc7 keyBy \u4f18\u5316\u4e4b\u540e\uff0c\u6bcf\u4e2a TM \u8282\u70b9\u53ea\u9700\u8981\u7f13\u5b58 3000W \/ 10 = 300W \u7684\u6570\u636e\u91cf\uff0c\u603b\u5171\u7f13\u5b58\u7684\u6570\u636e\u91cf\u53ea\u6709 3000W\uff0c\u5927\u5927\u51cf\u5c11\u7f13\u5b58\u6570\u636e\u91cf\u3002<\/p>\n\n\n\n<p>\u7ef4\u8868\u5173\u8054\u5ef6\u8fdf join<\/p>\n\n\n\n<p>\u7ef4\u8868\u5173\u8054\u4e2d\uff0c\u6709\u5f88\u591a\u4e1a\u52a1\u573a\u666f\uff0c\u5728\u7ef4\u8868\u6570\u636e\u65b0\u589e\u6570\u636e\u4e4b\u524d\uff0c\u4e3b\u6d41\u6570\u636e\u5df2\u7ecf\u53d1\u751f join \u64cd\u4f5c\uff0c\u4f1a\u51fa\u73b0\u5173\u8054\u4e0d\u4e0a\u7684\u60c5\u51b5\u3002\u56e0\u6b64\uff0c\u4e3a\u4e86\u4fdd\u8bc1\u6570\u636e\u7684\u6b63\u786e\uff0c\u5c06\u5173\u8054\u4e0d\u4e0a\u7684\u6570\u636e\u8fdb\u884c\u7f13\u5b58\uff0c\u8fdb\u884c\u5ef6\u8fdf join\u3002<\/p>\n\n\n\n<p>\u6700\u7b80\u5355\u7684\u505a\u6cd5\u662f\uff0c\u5728\u7ef4\u8868\u5173\u8054\u7684 function \u91cc\u8bbe\u7f6e\u91cd\u8bd5\u6b21\u6570\u548c\u91cd\u8bd5\u95f4\u9694\uff0c\u8fd9\u4e2a\u65b9\u6cd5\u4f1a\u589e\u5927\u6574\u4e2a\u6d41\u7684\u5ef6\u8fdf\uff0c\u4f46\u4e3b\u6d41 qps \u4e0d\u9ad8\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u4ee5\u89e3\u51b3\u95ee\u9898\u3002<\/p>\n\n\n\n<p>\u589e\u52a0\u5ef6\u8fdf join \u7684\u7b97\u5b50\uff0c\u5f53 join \u7ef4\u8868\u672a\u5173\u8054\u65f6\uff0c\u5148\u7f13\u5b58\u8d77\u6765\uff0c\u6839\u636e\u8bbe\u7f6e\u91cd\u8bd5\u6b21\u6570\u548c\u91cd\u8bd5\u95f4\u9694\u4ece\u800c\u8fdb\u884c\u5ef6\u8fdf\u7684 join\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%9B%9B%E3%80%81%E5%BA%94%E7%94%A8%E6%A1%88%E4%BE%8B\"><\/span>\u56db\u3001\u5e94\u7528\u6848\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>4.1 \u5b9e\u65f6\u6570\u4ed3<\/strong><\/p>\n\n\n\n<p>\u5b9e\u65f6\u6570\u636e\u5165\u4ed3<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-c95c0f2c29909fb0a6f1144e2a5ae225_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<ul>\n<li>\u6d41\u91cf\u6570\u636e\u4e00\u7ea7 kafka \u901a\u8fc7\u5b9e\u65f6\u6e05\u6d17\u4e4b\u540e\uff0c\u5199\u5230\u4e8c\u7ea7\u6e05\u6d17 kafka\uff0c\u4e3b\u8981\u662f protobuf \u683c\u5f0f\uff0c\u518d\u901a\u8fc7 Flink SQL \u5199\u5165 hive 5min \u8868\uff0c\u4ee5\u4fbf\u505a\u540e\u7eed\u7684\u51c6\u5b9e\u65f6 ETL\uff0c\u52a0\u901f ods \u5c42\u6570\u636e\u6e90\u7684\u51c6\u5907\u65f6\u95f4\u3002<\/li>\n\n\n\n<li>MySQL \u4e1a\u52a1\u5e93\u7684\u6570\u636e\uff0c\u901a\u8fc7 VDP \u89e3\u6790\u5f62\u6210 binlog cdc \u6d88\u606f\u6d41\uff0c\u518d\u901a\u8fc7 Flink SQL \u5199\u5165 hive 5min \u8868\u3002<\/li>\n\n\n\n<li>\u4e1a\u52a1\u7cfb\u7edf\u901a\u8fc7 VMS API \u4ea7\u751f\u4e1a\u52a1 kafka \u6d88\u606f\u6d41\uff0c\u901a\u8fc7 Flink SQL \u89e3\u6790\u4e4b\u540e\u5199\u5165 hive 5min \u8868\u3002\u652f\u6301 string\u3001json\u3001csv \u7b49\u6d88\u606f\u683c\u5f0f\u3002<\/li>\n\n\n\n<li>\u4f7f\u7528 Flink SQL \u505a\u6d41\u5f0f\u6570\u636e\u5165\u4ed3\uff0c\u975e\u5e38\u7684\u65b9\u4fbf\uff0c\u800c\u4e14 1.12 \u7248\u672c\u5df2\u7ecf\u652f\u6301\u4e86\u5c0f\u6587\u4ef6\u7684\u81ea\u52a8\u5408\u5e76\uff0c\u89e3\u51b3\u4e86\u5c0f\u6587\u4ef6\u7684\u75db\u70b9\u3002<\/li>\n\n\n\n<li>\u6211\u4eec\u81ea\u5b9a\u4e49\u5206\u533a\u63d0\u4ea4\u7b56\u7565\uff0c\u5f53\u524d\u5206\u533a ready \u65f6\u5019\u4f1a\u8c03\u4e00\u4e0b\u5b9e\u65f6\u5e73\u53f0\u7684\u5206\u533a\u63d0\u4ea4 api\uff0c\u5728\u79bb\u7ebf\u8c03\u5ea6\u5b9a\u65f6\u8c03\u5ea6\u901a\u8fc7\u8fd9\u4e2a api \u68c0\u67e5\u5206\u533a\u662f\u5426 ready\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u91c7\u7528 Flink SQL \u7edf\u4e00\u5165\u4ed3\u65b9\u6848\u4ee5\u540e\uff0c\u6211\u4eec\u53ef\u4ee5\u83b7\u5f97\u7684\u6536\u76ca\uff1a\u53ef\u89e3\u51b3\u4ee5\u524d Flume \u65b9\u6848\u4e0d\u7a33\u5b9a\u7684\u95ee\u9898\uff0c\u800c\u4e14\u7528\u6237\u53ef\u81ea\u52a9\u5165\u4ed3\uff0c\u5927\u5927\u964d\u4f4e\u5165\u4ed3\u4efb\u52a1\u7684\u7ef4\u62a4\u6210\u672c\u3002\u63d0\u5347\u4e86\u79bb\u7ebf\u6570\u4ed3\u7684\u65f6\u6548\u6027\uff0c\u4ece\u5c0f\u65f6\u7ea7\u964d\u4f4e\u81f3 5min \u7c92\u5ea6\u5165\u4ed3\u3002<\/p>\n\n\n\n<p>\u5b9e\u65f6\u6307\u6807\u8ba1\u7b97<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-a5256b5948fd22794c39ecd7761c1b51_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<ul>\n<li>\u5b9e\u65f6\u5e94\u7528\u6d88\u8d39\u6e05\u6d17\u540e kafka\uff0c\u901a\u8fc7 redis \u7ef4\u8868\u3001api \u7b49\u65b9\u5f0f\u5173\u8054\uff0c\u518d\u901a\u8fc7 Flink window \u589e\u91cf\u8ba1\u7b97 UV\uff0c\u6301\u4e45\u5316\u5199\u5230 Hbase \u91cc\u3002<\/li>\n\n\n\n<li>\u5b9e\u65f6\u5e94\u7528\u6d88\u8d39 VDP \u6d88\u606f\u6d41\u4e4b\u540e\uff0c\u901a\u8fc7 redis \u7ef4\u8868\u3001api \u7b49\u65b9\u5f0f\u5173\u8054\uff0c\u518d\u901a\u8fc7 Flink SQL \u8ba1\u7b97\u51fa\u9500\u552e\u989d\u7b49\u76f8\u5173\u6307\u6807\uff0c\u589e\u91cf upsert \u5230 kudu \u91cc\uff0c\u65b9\u4fbf\u6839\u636e range \u5206\u533a\u6279\u91cf\u67e5\u8be2\uff0c\u6700\u7ec8\u901a\u8fc7\u6570\u636e\u670d\u52a1\u5bf9\u5b9e\u65f6\u5927\u5c4f\u63d0\u4f9b\u6700\u7ec8\u670d\u52a1\u3002<\/li>\n<\/ul>\n\n\n\n<p>\u4ee5\u5f80\u6307\u6807\u8ba1\u7b97\u901a\u5e38\u91c7\u7528 Storm \u65b9\u5f0f\uff0c\u9700\u8981\u901a\u8fc7 api \u5b9a\u5236\u5316\u5f00\u53d1\uff0c\u91c7\u7528\u8fd9\u6837 Flink \u65b9\u6848\u4ee5\u540e\uff0c\u6211\u4eec\u53ef\u4ee5\u83b7\u5f97\u7684\u6536\u76ca\uff1a\u5c06\u8ba1\u7b97\u903b\u8f91\u5207\u5230 Flink SQL \u4e0a\uff0c\u964d\u4f4e\u8ba1\u7b97\u4efb\u52a1\u53e3\u5f84\u53d8\u5316\u5feb\uff0c\u4fee\u6539\u4e0a\u7ebf\u5468\u671f\u6162\u7b49\u95ee\u9898\u3002\u5207\u6362\u81f3 Flink SQL \u53ef\u4ee5\u505a\u5230\u5feb\u901f\u4fee\u6539\uff0c\u5feb\u901f\u4e0a\u7ebf\uff0c\u964d\u4f4e\u7ef4\u62a4\u6210\u672c\u3002<\/p>\n\n\n\n<p>\u5b9e\u65f6\u79bb\u7ebf\u4e00\u4f53\u5316 ETL \u6570\u636e\u96c6\u6210<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-efb4ed56871bb9086af99bf237411a27_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>Flink SQL \u5728\u6700\u8fd1\u7684\u7248\u672c\u4e2d\u6301\u7eed\u5f3a\u5316\u4e86\u7ef4\u8868 join \u7684\u80fd\u529b\uff0c\u4e0d\u4ec5\u53ef\u4ee5\u5b9e\u65f6\u5173\u8054\u6570\u636e\u5e93\u4e2d\u7684\u7ef4\u8868\u6570\u636e\uff0c\u73b0\u5728\u8fd8\u80fd\u5173\u8054 Hive \u548c Kafka \u4e2d\u7684\u7ef4\u8868\u6570\u636e\uff0c\u80fd\u7075\u6d3b\u6ee1\u8db3\u4e0d\u540c\u5de5\u4f5c\u8d1f\u8f7d\u548c\u65f6\u6548\u6027\u7684\u9700\u6c42\u3002<\/p>\n\n\n\n<p>\u57fa\u4e8e Flink \u5f3a\u5927\u7684\u6d41\u5f0f ETL \u7684\u80fd\u529b\uff0c\u6211\u4eec\u53ef\u4ee5\u7edf\u4e00\u5728\u5b9e\u65f6\u5c42\u505a\u6570\u636e\u63a5\u5165\u548c\u6570\u636e\u8f6c\u6362\uff0c\u7136\u540e\u5c06\u660e\u7ec6\u5c42\u7684\u6570\u636e\u56de\u6d41\u5230\u79bb\u7ebf\u6570\u4ed3\u4e2d\u3002<\/p>\n\n\n\n<p>\u6211\u4eec\u901a\u8fc7\u5c06 presto \u5185\u90e8\u4f7f\u7528\u7684 HyperLogLog ( \u540e\u9762\u7b80\u79f0 HLL ) \u5b9e\u73b0\u5f15\u5165\u5230 Spark UDAF \u51fd\u6570\u91cc\uff0c\u6253\u901a HLL \u5bf9\u8c61\u5728 Spark SQL \u4e0e presto \u5f15\u64ce\u4e4b\u95f4\u7684\u4e92\u901a\uff0c\u5982 Spark SQL \u901a\u8fc7 prepare \u51fd\u6570\u751f\u6210\u7684 HLL \u5bf9\u8c61\uff0c\u4e0d\u4ec5\u53ef\u4ee5\u5728 Spark SQL \u91cc merge \u67e5\u8be2\u800c\u4e14\u53ef\u4ee5\u5728 presto \u91cc\u8fdb\u884c merge \u67e5\u8be2\u3002\u5177\u4f53\u6d41\u7a0b\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-206166e8437e42bd03a86df0fd1f96ad_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>UV \u8fd1\u4f3c\u8ba1\u7b97\u793a\u4f8b:<\/p>\n\n\n\n<p><strong>Step 1: Spark SQL \u751f\u6210 HLL \u5bf9\u8c61<\/strong><\/p>\n\n\n\n<p>insert overwrite dws_goods_uv partition (dt=&#8217;${dt}&#8217;,hm=&#8217;${hm}&#8217;) AS select goods_id, estimate_prepare(mid) as pre_hll from dwd_table_goods group by goods_id where dt = ${dt} and hm = ${hm}<\/p>\n\n\n\n<p><strong>Step 2: Spark SQL \u901a\u8fc7 goods_id \u7ef4\u5ea6\u7684 HLL \u5bf9\u8c61 merge \u6210\u54c1\u724c\u7ef4\u5ea6<\/strong><\/p>\n\n\n\n<p>insert overwrite dws_brand_uv partition (dt=&#8217;${dt}&#8217;,hm=&#8217;${hm}&#8217;) AS select b.brand_id, estimate_merge(pre_hll) as merge_hll from dws_table_brand A left join dim_table_brand_goods B on A.goods_id = B.goods_id where dt = ${dt} and hm = ${hm}<\/p>\n\n\n\n<p><strong>Step 3: Spark SQL \u67e5\u8be2\u54c1\u724c\u7ef4\u5ea6\u7684 UV<\/strong><\/p>\n\n\n\n<p>select brand_id, estimate_compute(merge_hll ) as uv from dws_brand_uv where dt = ${dt}<\/p>\n\n\n\n<p><strong>Step 4: presto merge \u67e5\u8be2 park \u751f\u6210\u7684 HLL \u5bf9\u8c61<\/strong><\/p>\n\n\n\n<p>select brand_id,cardinality(merge(cast(merge_hll AS HyperLogLog))) uv from dws_brand_uv group by brand_id<\/p>\n\n\n\n<p>\u6240\u4ee5\u57fa\u4e8e\u5b9e\u65f6\u79bb\u7ebf\u4e00\u4f53\u5316ETL\u6570\u636e\u96c6\u6210\u7684\u67b6\u6784\uff0c\u6211\u4eec\u80fd\u83b7\u5f97\u7684\u6536\u76ca:<\/p>\n\n\n\n<ul>\n<li>\u7edf\u4e00\u4e86\u57fa\u7840\u516c\u5171\u6570\u636e\u6e90\uff1b<\/li>\n\n\n\n<li>\u63d0\u5347\u4e86\u79bb\u7ebf\u6570\u4ed3\u7684\u65f6\u6548\u6027\uff1b<\/li>\n\n\n\n<li>\u51cf\u5c11\u4e86\u7ec4\u4ef6\u548c\u94fe\u8def\u7684\u7ef4\u62a4\u6210\u672c\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>4.2 \u5b9e\u9a8c\u5e73\u53f0\uff08Flink \u5b9e\u65f6\u6570\u636e\u5165 OLAP\uff09<\/strong><\/p>\n\n\n\n<p>\u552f\u54c1\u4f1a\u5b9e\u9a8c\u5e73\u53f0\u662f\u901a\u8fc7\u914d\u7f6e\u591a\u7ef4\u5ea6\u5206\u6790\u548c\u4e0b\u94bb\u5206\u6790\uff0c\u63d0\u4f9b\u6d77\u91cf\u6570\u636e\u7684 A \/ B &#8211; test \u5b9e\u9a8c\u6548\u679c\u5206\u6790\u7684\u4e00\u4f53\u5316\u5e73\u53f0\u3002\u4e00\u4e2a\u5b9e\u9a8c\u662f\u7531\u4e00\u80a1\u6d41\u91cf\uff08\u6bd4\u5982\u7528\u6237\u8bf7\u6c42\uff09\u548c\u5728\u8fd9\u80a1\u6d41\u91cf\u4e0a\u8fdb\u884c\u7684\u76f8\u5bf9\u5bf9\u6bd4\u5b9e\u9a8c\u7684\u4fee\u6539\u7ec4\u6210\u3002\u5b9e\u9a8c\u5e73\u53f0\u5bf9\u4e8e\u6d77\u91cf\u6570\u636e\u67e5\u8be2\u6709\u7740\u4f4e\u5ef6\u8fdf\u3001\u4f4e\u54cd\u5e94\u3001\u8d85\u5927\u89c4\u6a21\u6570\u636e(\u767e\u4ebf\u7ea7)\u7684\u9700\u6c42\u3002\u6574\u4f53\u6570\u636e\u67b6\u6784\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-4fccaff2de7827e49cef9a8ffc8c5b50_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u901a\u8fc7 Flink SQL \u5c06 kafka \u91cc\u7684\u6570\u636e\u6e05\u6d17\u89e3\u6790\u5c55\u5f00\u7b49\u64cd\u4f5c\u4e4b\u540e\uff0c\u901a\u8fc7 redis \u7ef4\u8868\u5173\u8054\u5546\u54c1\u5c5e\u6027\uff0c\u901a\u8fc7\u5206\u5e03\u5f0f\u8868\u5199\u5165\u5230 clickhouse\uff0c\u7136\u540e\u901a\u8fc7\u6570\u636e\u670d\u52a1 adhoc \u67e5\u8be2\u3002\u4e1a\u52a1\u6570\u636e\u6d41\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/80\/v2-97760f8ab5f1b4473cd3fe21593623f2_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u6211\u4eec\u901a\u8fc7 Flink SQL redis connector\uff0c\u652f\u6301 redis \u7684 sink \u3001source \u7ef4\u8868\u5173\u8054\u7b49\u64cd\u4f5c\uff0c\u53ef\u4ee5\u5f88\u65b9\u4fbf\u7684\u8bfb\u5199 redis\uff0c\u5b9e\u73b0\u7ef4\u8868\u5173\u8054\uff0c\u7ef4\u8868\u5173\u8054\u5185\u53ef\u914d\u7f6e cache \uff0c\u6781\u5927\u63d0\u9ad8\u5e94\u7528\u7684 TPS\u3002\u901a\u8fc7 Flink SQL \u5b9e\u73b0\u5b9e\u65f6\u6570\u636e\u6d41\u7684 pipeline\uff0c\u6700\u7ec8\u5c06\u5927\u5bbd\u8868 sink \u5230 CK \u91cc\uff0c\u5e76\u6309\u7167\u67d0\u4e2a\u5b57\u6bb5\u7c92\u5ea6\u505a murmurHash3_64 \u5b58\u50a8\uff0c\u4fdd\u8bc1\u76f8\u540c\u7528\u6237\u7684\u6570\u636e\u90fd\u5b58\u5728\u540c\u4e00 shard \u8282\u70b9\u7ec4\u5185\uff0c\u4ece\u800c\u4f7f\u5f97 ck \u5927\u8868\u4e4b\u95f4\u7684 join \u53d8\u6210 local \u672c\u5730\u8868\u4e4b\u95f4\u7684 join,\u51cf\u5c11\u6570\u636e shuffle \u64cd\u4f5c\uff0c\u63d0\u5347 join \u67e5\u8be2\u6548\u7387\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BA%94%E3%80%81%E6%9C%AA%E6%9D%A5%E8%A7%84%E5%88%92\"><\/span>\u4e94\u3001\u672a\u6765\u89c4\u5212<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>5.1 \u63d0\u9ad8 Flink SQL \u6613\u7528\u6027<\/strong><\/p>\n\n\n\n<p>\u5f53\u524d\u6211\u4eec\u7684 Flink SQL \u8c03\u8bd5\u8d77\u6765\u5f88\u6709\u5f88\u591a\u4e0d\u65b9\u4fbf\u7684\u5730\u65b9\uff0c\u5bf9\u4e8e\u505a\u79bb\u7ebf hive \u7528\u6237\u6765\u8bf4\u8fd8\u6709\u4e00\u5b9a\u7684\u4f7f\u7528\u95e8\u69db\uff0c\u4f8b\u5982\u624b\u52a8\u914d\u7f6e kafka \u76d1\u63a7\u3001\u4efb\u52a1\u7684\u538b\u6d4b\u8c03\u4f18\uff0c\u5982\u4f55\u80fd\u8ba9\u7528\u6237\u7684\u4f7f\u7528\u95e8\u69db\u964d\u4f4e\u81f3\u6700\u4f4e\uff0c\u662f\u4e00\u4e2a\u6bd4\u8f83\u5927\u7684\u6311\u6218\u3002\u5c06\u6765\u6211\u4eec\u8003\u8651\u505a\u4e00\u4e9b\u667a\u80fd\u76d1\u63a7\u544a\u8bc9\u7528\u6237\u5f53\u524d\u4efb\u52a1\u5b58\u5728\u7684\u95ee\u9898\uff0c\u5c3d\u53ef\u80fd\u81ea\u52a8\u5316\u5e76\u7ed9\u7528\u6237\u4e00\u4e9b\u4f18\u5316\u5efa\u8bae\u3002<\/p>\n\n\n\n<p><strong>5.2 \u6570\u636e\u6e56 CDC \u5206\u6790\u65b9\u6848\u843d\u5730<\/strong><\/p>\n\n\n\n<p>\u76ee\u524d\u6211\u4eec\u7684 VDP binlog \u6d88\u606f\u6d41\uff0c\u901a\u8fc7 Flink SQL \u5199\u5165\u5230 hive ods \u5c42\uff0c\u4ee5\u52a0\u901f ods \u5c42\u6570\u636e\u6e90\u7684\u51c6\u5907\u65f6\u95f4\uff0c\u4f46\u662f\u4f1a\u4ea7\u751f\u5927\u91cf\u91cd\u590d\u6d88\u606f\u53bb\u91cd\u5408\u5e76\u3002\u6211\u4eec\u4f1a\u8003\u8651 Flink + \u6570\u636e\u6e56\u7684 cdc \u5165\u4ed3\u65b9\u6848\u6765\u505a\u589e\u91cf\u5165\u4ed3\u3002\u6b64\u5916\uff0c\u50cf\u8ba2\u5355\u6253\u5bbd\u4e4b\u540e\u7684 kafka \u6d88\u606f\u6d41\u3001\u4ee5\u53ca\u805a\u5408\u7ed3\u679c\u90fd\u9700\u8981\u975e\u5e38\u5f3a\u7684\u5b9e\u65f6 upsert \u80fd\u529b\uff0c\u76ee\u524d\u6211\u4eec\u4e3b\u8981\u662f\u7528 kudu\uff0c\u4f46\u662f kudu \u96c6\u7fa4\uff0c\u6bd4\u8f83\u72ec\u7acb\u5c0f\u4f17\uff0c\u7ef4\u62a4\u6210\u672c\u9ad8\uff0c\u6211\u4eec\u4f1a\u8c03\u7814\u6570\u636e\u6e56\u7684\u589e\u91cf upsert \u80fd\u529b\u6765\u66ff\u6362 kudu \u589e\u91cf upsert \u573a\u666f\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/zhuanlan.zhihu.com\/p\/368185515\">https:\/\/zhuanlan.zhihu.com\/p\/368185515<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00 \u3001\u53d1\u5c55\u6982\u89c8 \u5e73\u53f0\u652f\u6301\u516c\u53f8\u5185\u90e8\u6240\u6709\u90e8\u95e8\u7684\u5b9e\u65f6\u8ba1\u7b97\u5e94\u7528\u3002\u4e3b\u8981\u7684\u4e1a\u52a1\u5305\u62ec\u5b9e\u65f6\u5927\u5c4f\u3001\u63a8\u8350\u3001\u5b9e\u9a8c\u5e73\u53f0\u3001\u5b9e\u65f6&hellip; <a href=\"http:\/\/viplao.com\/index.php\/2023\/06\/22\/flink-sql-%e5%94%af%e5%93%81%e4%bc%9aflink%e5%ae%9e%e8%b7%b5%e4%b8%8e%e4%bc%98%e5%8c%96\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">Flink SQL &#8211; \u552f\u54c1\u4f1aflink\u5b9e\u8df5\u4e0e\u4f18\u5316<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[25],"views":1118,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2047"}],"collection":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/comments?post=2047"}],"version-history":[{"count":1,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2047\/revisions"}],"predecessor-version":[{"id":2048,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2047\/revisions\/2048"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=2047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=2047"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=2047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}