{"id":45136,"date":"2025-06-22T13:19:44","date_gmt":"2025-06-22T05:19:44","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/45136.html"},"modified":"2025-06-22T13:19:44","modified_gmt":"2025-06-22T05:19:44","slug":"%e9%98%bf%e9%87%8c%e4%ba%91acp%e8%ae%a4%e8%af%81-%e6%95%b0%e6%8d%ae%e4%bb%93%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/45136.html","title":{"rendered":"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93"},"content":{"rendered":"<h2>\u6570\u636e\u4ed3\u5e93<\/h2>\n<p>Kappa\u67b6\u6784&#xff1a;\u5c06\u5b9e\u65f6\u548c\u79bb\u7ebf\u4ee3\u7801\u7edf\u4e00&#xff08;\u4f18\u5316lambda\u67b6\u6784&#xff09;&#xff0c;\u4f46\u662f\u4e0d\u597d\u4fee\u6b63\u6570\u636e&#xff0c;\u5f00\u53d1\u5468\u671f\u957f&#xff0c;\u6210\u672c\u6d6a\u8d39&#xff0c;\u5bf9\u4e8e\u5386\u53f2\u6570\u636e\u7684\u9ad8\u541e\u5410\u91cf\u529b\u4e0d\u4ece\u5fc3 \u539f\u4e00\u4ee3\u6570\u636e\u4ed3\u5e93&#xff1a;<\/p>\n<ul>\n<li>\u79bb\u7ebf&#xff1a;hive&#043;maxcompute<\/li>\n<li>\u5b9e\u65f6&#xff1a;clickhouse&#043;driud<\/li>\n<li>\u6574\u5408\u79bb\u7ebf\u548c\u5b9e\u65f6&#xff1a;drill&#043;presto<\/li>\n<li>\u4fdd\u5b58&#xff1a;mysql&#043;redis<\/li>\n<li>\u6700\u540eAPI<\/li>\n<\/ul>\n<p>\u4e0b\u4e00\u4ee3&#xff1a;<\/p>\n<ul>\n<li>\u8981\u5b9e\u65f6&#xff0c;\u5f88\u5b9e\u65f6<\/li>\n<li>\u79bb\u7ebf\u548c\u5b9e\u65f6\u4e00\u4f53\u5316&#xff0c;\u51cf\u5c11\u6570\u636e\u79fb\u52a8<\/li>\n<li>\u901a\u7528\u6027&#xff0c;\u8981\u89e3\u8026<\/li>\n<li>\u4e91\u539f\u751f&#xff0c;\u6807\u51c6\u4e14\u751f\u6001<\/li>\n<\/ul>\n<table>\n<tr>\u7279\u70b9\u6570\u636e\u5e93\u7f3a\u70b9<\/tr>\n<tbody>\n<tr>\n<td>\u652f\u6301\u4e8b\u52a1&#043;ACID<\/td>\n<td>Mysql&#043;presetSQL<\/td>\n<td>\u5f39\u6027\u4f38\u7f29\u96be\u505a\u5230PD\u7ea7\u522b&#xff0c;\u4e14\u4e0d\u80fd\u505a\u590d\u6742\u67e5\u8be2<\/td>\n<\/tr>\n<tr>\n<td>\u5206\u6790\u52a0\u901f,\u5206\u5e03\u5f0f<\/td>\n<td>presto&#043;druid&#043;hive&#043;clickhouse\u2026<\/td>\n<td>\u9762\u5411\u5206\u6790\u5e08<\/td>\n<\/tr>\n<tr>\n<td>\u9762\u5411\u670d\u52a1\u4ea7\u54c1&#xff0c;\u9ad8\u5e76\u53d1&#xff0c;\u67e5\u8be2\u7b80\u5355<\/td>\n<td>hbase&#043;redis&#043;casandra<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u65e2\u53ef\u4ee5\u652f\u6301\u5206\u6790\u4e5f\u53ef\u4ee5\u652f\u6301\u4e8b\u52a1&#xff1a;HTAP\u6df7\u5408\u4e8b\u52a1\u5206\u6790\u7cfb\u7edf<\/p>\n<ul>\n<li>\u9700\u8981\u4e8b\u52a1\u673a\u5236\u4fdd\u8bc1ACID &#043; \u9002\u5408\u6a21\u578b\u7b80\u5355&#xff0c;\u7b80\u5355\u5206\u6790\u573a\u666f&#xff0c;TP\u89e3\u51b3AP\u95ee\u9898<\/li>\n<\/ul>\n<p>\u65e2\u53ef\u4ee5\u5206\u6790\u4e5f\u53ef\u4ee5\u670d\u52a1&#xff1a;HSAP\u670d\u52a1\/\u5206\u6790\u4e00\u4f53\u5316&#xff1a;Hologres<\/p>\n<ul>\n<li>\u65e0\u4e8b\u52a1\u5f00\u9500&#xff08;\u5206\u5e03\u5f0f\u9501\u3001\u540c\u6b65&#xff09;<\/li>\n<li>\u4ee5\u6570\u636e\u4ed3\u5e93\u6a21\u578b&#xff08;\u62bd\u8c61\u3001\u670d\u7528\u3001\u6807\u51c6&#xff09;\u89e3\u51b3\u6570\u636e\u670d\u52a1\u95ee\u9898<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051938-6857926a59685.png\" alt=\"\u4e0b\u4e00\u4ee3\u67b6\u6784\" \/><\/p>\n<h2>Hologres<\/h2>\n<p>\u4ea7\u54c1\u7279\u6027&#xff1a;<\/p>\n<ul>\n<li>\u5206\u6790\u670d\u52a1\u4e00\u4f53\u5316&#xff1a;point&#xff08;\u70b9\u67e5\u8be2hbase\/redis\u9047\u5230\u7684&#xff09; \/Ad-hoc&#xff08;\u5373\u5e2d\u5206\u6790clickhouse&#xff09;\/OLAP&#xff08;\u8054\u673a\u5206\u6790&#xff09; \u5206\u6790<\/li>\n<li>\u4ee5\u5b9e\u65f6\u4e3a\u4e2d\u5fc3&#xff1a;\u5f88\u5feb&#xff0c;\u6570\u636e\u5b9e\u65f6\u5199\u5165\u548c\u66f4\u65b0&#xff0c;\u4e0eFlink\u539f\u751f\u96c6\u6210&#xff0c;\u5199\u5165\u5373\u53ef\u89c1<\/li>\n<li>\u8ba1\u7b97\u5b58\u50a8\u5206\u79bb&#xff1a;\u5b58\u50a8\u8d44\u6e90\u548c\u8ba1\u7b97\u8d44\u6e90\u5206\u79bb\u90e8\u7f72\u5e76\u72ec\u7acb\u6269\u5c55&#043;\u548cMaxcompute\u65e0\u7f1d\u6253\u901a<\/li>\n<li>\u5f00\u653e\u751f\u6001&#xff1a;\u517c\u5bb9PF\u751f\u6001&#043;\u5bf9\u63a5PG\u5f00\u53d1\u5de5\u5177&#043;\u5bf9\u63a5BI<\/li>\n<\/ul>\n<p>Flink&#043;hologres\u7ec4\u5408&#xff1a;\u5b9e\u65f6\u5927\u5c4f\u7b49 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051938-6857926a8ebc7.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> hologres&#xff1a;\u62a5\u8868\u7b49\u79bb\u7ebf\u52a0\u901f <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051938-6857926ab2c35.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>Flink&#043;hologres&#043;maxcompute&#xff1a;\u6570\u636e\u4e2d\u53f0&#043;\u7cbe\u51c6\u8425\u9500&#043;\u591a\u7ef4\u5206\u6790 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051938-6857926ae98ff.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h3>Hologres\u67b6\u6784\u539f\u7406<\/h3>\n<p>\u8ba1\u7b97\u548c\u5b58\u50a8\u76f8\u5206\u79bb <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051939-6857926b18c95.png\" alt=\"\u903b\u8f91\u67b6\u6784\u56fe\" \/> \u8ba1\u7b97:<\/p>\n<ul>\n<li>\u63a5\u5165\u8282\u70b9Frontend&#xff08;FE&#xff09;&#xff1a;SQL\u8ba4\u8bc1\u89e3\u6790\u548c\u4f18\u5316&#xff0c;\u53ef\u4ee5\u5305\u542b\u591a\u4e2a&#xff0c;\u517c\u5bb9postgres11<\/li>\n<li>worker&#xff1a;\u6267\u884c\u5f15\u64ceHQE&#xff08;hologres query engine&#xff0c;\u6781\u81f4\u67e5\u8be2&#xff09;\/PQE&#xff08;postgres query engine&#xff0c;\u517c\u5bb9postgres&#xff09;\/SQE&#xff08;\u5bf9\u63a5maxcompute&#xff0c;\u672c\u5730\u517c\u5bb9\u8bbf\u95eemaxcompute&#xff09;&#043;\u5b58\u50a8\u5f15\u64ce&#xff08;SH&#xff0c;shard&#xff0c;CURD&#xff09;&#043;\u7f13\u5b58&#043;\u8c03\u5ea6&#xff08;HOS\u8f7b\u91cf\u7ea7&#xff09;<\/li>\n<li>MetraService&#xff08;\u7ba1\u7406\u5143\u6570\u636e\u4fe1\u606f&#xff0c;\u540c\u65f6\u63d0\u4f9b\u7ed9FE&#xff09;&#043;Holo Master&#xff08;\u62c9\u8d77Worker&#xff09;<\/li>\n<\/ul>\n<p>\u5b58\u50a8&#xff1a;<\/p>\n<ul>\n<li>\u76d8\u53e4\u6587\u4ef6\u7cfb\u7edf<\/li>\n<li>\u6570\u636e\u6e56<\/li>\n<\/ul>\n<p>SQL\u53d1\u9001\u8bf7\u6c42-frontend\u89e3\u6790\u5206\u53d1-worker\u6267\u884c-\u8d70\u4e0d\u540c\u8def\u5f84-SE\u5b58\u50a8\u83b7\u53d6\u6570\u636e&#xff0c;\u5408\u5e76\u540e\u8fd4\u56de\u7ed9FE &#xff08;\u70b9\u67e5\u76f4\u63a5\u641cFixed FE&#xff09; <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051939-6857926b7777a.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>HSAP\u6311\u6218\u548cHologres\u5e94\u5bf9\u7b56\u7565 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051939-6857926bb7ad3.png\" alt=\"\u7279\u70b9\" \/><\/p>\n<p>\u5b58\u50a8\u8ba1\u7b97\u5206\u79bb&#xff1a;\u4e09\u79cd \u5b58\u50a8\u4f7f\u7528\u76d8\u53e4 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051940-6857926c08a61.png\" alt=\"hologres\u5b58\u50a8\" \/> \u6d41\u6279\u7edf\u4e00&#xff1a;\u5e95\u5c42\u652f\u6301\u884c&#xff08;PK&#xff09;\u3001\u5217&#xff08;OLAP&#xff09;\u3001\u884c\u5217\u5171\u5b58 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051940-6857926c5c85e.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u6267\u884c\u5f15\u64ce&#043;\u4f18\u5316\u5668 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051940-6857926cc9727.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u540d\u8bcd\u89e3\u91ca&#xff1a; <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051941-6857926d0b163.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>hologres\u5f00\u53d1\u5de5\u5177&#xff1a; <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051941-6857926d60dd9.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>PSQL\u5ba2\u6237\u7aef <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051941-6857926dac13d.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> JDBC\u8fde\u63a5hologres <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051942-6857926e0656d.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u6570\u636e\u540c\u6b65<\/h4>\n<p>\u652f\u6301\u591a\u79cd\u5f02\u6784\u6570\u636e\u6e90\u7684\u79bb\u7ebf\u3001\u5b9e\u65f6\u5199\u5165 <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051942-6857926ea69fa.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>\u5b9e\u65f6\u5199\u5165\u6570\u636e\u5230hologres \u8fdb\u5165hologres\u63a7\u5236\u53f0\u2013\u5efa\u5e93\u5efa\u8868&#xff08;1&#xff09;-\u8fdb\u5165\u5b9e\u65f6\u8ba1\u7b97Flink\u63a7\u5236\u53f0-\u4f5c\u4e1a\u5f00\u53d1-\u65b0\u5efa\u4f5c\u4e1a-\u521b\u5efa\u539f\u8868\u548c\u76ee\u6807\u8868&#xff08;2&#xff09;-\u6267\u884c-\u4e0a\u7ebf-\u8fd0\u7ef4-\u8fdb\u5165\u4f5c\u4e1a\u8fd0\u7ef4\u53ef\u4ee5\u770b\u5230\u63d0\u4ea4\u7684\u4f5c\u4e1a-\u542f\u52a8\u4f5c\u4e1a\u5373\u53ef-\u5728holoweb\u63a7\u5236\u53f0\u67e5\u770b\u662f\u5426\u6210\u529f&#xff08;3&#xff09; &#xff08;1&#xff09;create table if not exists test1(a int ,b bigint ,c text,d timestamp); &#xff08;2_1&#xff09;create temporary table datagen_source(a int ,b bigint,c string,proctime as proctime()) with (&#039;connector&#039;&#061;&#039;datagen&#039;)flink\u968f\u673a\u6e90 &#xff08;2_2&#xff09;create temporary table holo_sink(a int,b bigint,c varchar,d timestamp) with (&#039;connector&#039;&#061;&#039;hologres&#039;,&#039;endpoint&#039;&#061;&#039;XXX&#xff08;hologres\u5b9e\u4f8b\u5217\u8868\u63a7\u5236\u53f0\u67e5\u770b&#xff09;&#039;,&#039;username&#039;&#061;&#039;XX&#039;,&#039;password&#039;&#061;&#039;XX&#039;,&#039;dbname&#039;&#061;&#039;XX&#039;,&#039;tablename&#039;&#061;&#039;test1&#xff08;\u4e0a\u9762\u5efa\u7684\u8868&#xff09;&#039;)holo\u76ee\u6807\u8868 &#xff08;2_3&#xff09;insert into holo_sink select * from datagen_source;\u6570\u636e\u5b9e\u65f6\u5199\u5165\u76ee\u6807\u8868 &#xff08;3&#xff09;select * from test1 order by d limit 2;\/select count(1) from test1; <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051942-6857926eca95e.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>Maxcompute\u79bb\u7ebf\u52a0\u901f\u67e5\u8be2<\/h4>\n<p>\u5355\u8868\u521b\u5efa\/\u6279\u91cf\u5916\u8868\u521b\u5efa <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051942-6857926edd989.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> dataworks\u63a7\u5236\u53f0<\/p>\n<ul>\n<li>\u6570\u636e\u5f00\u53d1<\/li>\n<li>\u4e34\u65f6\u67e5\u8be2-\u65b0\u5efa\u6570\u636e\u6e90<\/li>\n<li>\u521b\u5efa\u8868\u5e76\u63d2\u5165\u6570\u636e<\/li>\n<\/ul>\n<p>create table <span class=\"token keyword\">if<\/span> not exists odps_test<span class=\"token punctuation\">(<\/span><br \/>\nshop_name string,<br \/>\ncustomer_id string,<br \/>\ntotal_price int<br \/>\n<span class=\"token punctuation\">)<\/span><br \/>\npartitioned by <span class=\"token punctuation\">(<\/span><br \/>\nsale_date string<br \/>\n<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token comment\">#\u63d2\u5165\u6570\u636e<\/span><br \/>\ninsert into odps_test partition<span class=\"token punctuation\">(<\/span>sale_date<span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;20221111&#039;<\/span><span class=\"token punctuation\">)<\/span> values<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;a&#039;<\/span>,<span class=\"token string\">&#039;\u5f20\u4e09&#039;<\/span>,50<span class=\"token punctuation\">)<\/span>,<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;b&#039;<\/span>,<span class=\"token string\">&#039;\u674e\u56db&#039;<\/span>,55<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\"># \u67e5\u770b\u6570\u636e<\/span><br \/>\n<span class=\"token builtin class-name\">read<\/span> odps_test&#xff1b;<\/p>\n<ul>\n<li>\u521b\u5efaholoweb\u5916\u90e8\u8868&#xff08;\u5143\u6570\u636e\u7ba1\u7406\u53ef\u89c6\u5316\u521b\u5efa\/sql\u521b\u5efa&#xff09;<\/li>\n<\/ul>\n<p><span class=\"token keyword\">create<\/span> <span class=\"token keyword\">foreign<\/span> <span class=\"token keyword\">table<\/span> t_odps<span class=\"token punctuation\">(<\/span><br \/>\nshop_name <span class=\"token keyword\">text<\/span><span class=\"token punctuation\">,<\/span><br \/>\ncustomer_id <span class=\"token keyword\">text<\/span><span class=\"token punctuation\">,<\/span><br \/>\ntotal_price int8<span class=\"token punctuation\">,<\/span><br \/>\nsale_date <span class=\"token keyword\">text<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><br \/>\nserver odps_server<br \/>\noptions<span class=\"token punctuation\">(<\/span>project_name <span class=\"token string\">&#039;XXX\u9879\u76ee\u7a7a\u95f4\u540d&#039;<\/span><span class=\"token punctuation\">,<\/span>table_name <span class=\"token string\">&#039;odps_test&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\"># \u9a8c\u8bc1\u662f\u5426\u521b\u5efa,\u76f8\u5e94\u4f1a\u5f88\u5feb&#xff0c;dataworks\u6162&#xff0c;hologres\u52a0\u901f\u67e5\u8be2&#xff01;<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> t_odps<span class=\"token punctuation\">;<\/span><\/p>\n<ul>\n<li>\u5916\u8868\u5b8c\u6210\u52a0\u901f\u67e5\u8be2\u5b8c\u6210<\/li>\n<\/ul>\n<h4>COPY\u547d\u4ee4\u5bfc\u5165\u5bfc\u51fa\u6570\u636e<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051943-6857926f08cfb.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u5728psql\u91cc\u9762&#xff0c;\u8fde\u63a5\u540e\u6d4b\u8bd5copy\u547d\u4ee4<\/p>\n<p><span class=\"token comment\">#\\\\d\u67e5\u770b\u6570\u636e\u8868<\/span><br \/>\n<span class=\"token comment\">#\u5efa\u8868<\/span><br \/>\n<span class=\"token keyword\">create<\/span> <span class=\"token keyword\">table<\/span> copy_test<span class=\"token punctuation\">(<\/span><br \/>\nid <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">,<\/span><br \/>\nage <span class=\"token keyword\">int<\/span><span class=\"token punctuation\">,<\/span><br \/>\nname <span class=\"token keyword\">text<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token comment\"># \u4ece\u63a7\u5236\u53f0&#xff08;stdin&#xff09;\u8f93\u5165\u6570\u636e\u5e76\u590d\u5236\u5230\u8868<\/span><br \/>\ncopy copy_test <span class=\"token keyword\">from<\/span> stdin <span class=\"token keyword\">with<\/span> <span class=\"token keyword\">delimiter<\/span> <span class=\"token keyword\">as<\/span> <span class=\"token string\">&#039;,&#039;<\/span> <span class=\"token boolean\">null<\/span> <span class=\"token keyword\">as<\/span> <span class=\"token string\">&#039;&#039;<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token comment\"># \u9a8c\u8bc1<\/span><br \/>\n<span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> copy_test<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">#\u4ecetxt\u6587\u4ef6\u5bfc\u5165\u6570\u636e<\/span><br \/>\ncmd<br \/>\npsql <span class=\"token operator\">&#8211;<\/span>U XXX <span class=\"token operator\">&#8211;<\/span>p <span class=\"token number\">80<\/span> <span class=\"token operator\">&#8211;<\/span>h XX <span class=\"token operator\">&#8211;<\/span>d X\u6570\u636e\u5e93\u540dX <span class=\"token operator\">&#8211;<\/span>c <span class=\"token string\">&#034;copy copy_test from stdin with delimiter &#039;,&#039;; &#034;<\/span> <span class=\"token operator\">&lt;<\/span> X\u6587\u4ef6\u8def\u5f84X<\/p>\n<p><span class=\"token comment\">#COPY N,\u4ee3\u8868\u5199\u5165\u4e86\u591a\u5c11\u6761\u6570\u636e<\/span><\/p>\n<p><span class=\"token comment\"># \u4e0b\u8f7d\u6570\u636e\u5230\u672c\u5730<\/span><br \/>\npsql<br \/>\n\\\\copy <span class=\"token punctuation\">(<\/span><span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">from<\/span> copy_test<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">to<\/span> <span class=\"token string\">&#039;\u672c\u5730\u8def\u5f84\/\u5199\u5165OSS&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">#\u4e0b\u8f7d\u6570\u636e\u5230OSS<\/span><br \/>\npsql<span class=\"token operator\">\/<\/span>HoloWEB <span class=\"token keyword\">SQL<\/span>\u7f16\u8f91\u5668<br \/>\n\\\\copy <span class=\"token punctuation\">(<\/span><span class=\"token keyword\">select<\/span> <span class=\"token operator\">*<\/span> copy_test <span class=\"token keyword\">limit<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">to<\/span> program <span class=\"token string\">&#039;<br \/>\nhg_dump_to_odd<br \/>\n&#8211;AccessKeyId XX<br \/>\n&#8211;AccessKeySecret XX<br \/>\n&#8211;BucketName XX<br \/>\n&#8211;DirName X\u8def\u5f84X<br \/>\n&#8211;FileName X\u6587\u4ef6\u540dX<br \/>\n&#8211;BatchSize X\u591a\u5c11\u8bb0\u5f55X<br \/>\n&#039;<\/span><br \/>\n<span class=\"token comment\"># \u6700\u540e\u5230OSS\u67e5\u770b\u9a8c\u8bc1\u5373\u53ef<\/span><\/p>\n<h3>Hologres\u6570\u636e\u5f00\u53d1<\/h3>\n<p>\u6570\u636e\u7c7b\u578b&#xff1a;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051943-6857926f5a516.png\" alt=\"\u6570\u636e\u7c7b\u578b\" \/> Maxcompute\u4e0eHologres\u6570\u636e\u7c7b\u578b\u6620\u5c04&#xff1a; <img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051943-6857926f7eba7.png\" alt=\"\u6570\u636e\u7c7b\u578b\u6620\u5c04\" \/> Flink\u4e0eHologres\u6570\u636e\u7c7b\u578b\u6620\u5c04&#xff1a;<\/p>\n<p><img decoding=\"async\" src=\"2025-06-224ncuvitwi1d.png\" alt=\"Flink\u548cHologres\u6570\u636e\u7c7b\u578b\u6620\u5c04\" \/><\/p>\n<p>PG\u53c2\u8003\u6587\u6863-\u51fd\u6570<\/p>\n<p>Hologres\u6269\u5c55\u51fd\u6570 <img decoding=\"async\" src=\"2025-06-225lxzwd4ffzi.png\" alt=\"\u6269\u5c55\u51fd\u6570\" \/> DDL&#xff08;\u8868\u64cd\u4f5c&#xff09;\u548cDML\u3001DQL&#xff08;\u8868\u6570\u636e\u64cd\u4f5c&#xff09; <img decoding=\"async\" src=\"2025-06-22mthbqogka42.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> Hologres\u5efa\u8868\u8bed\u6cd5&#xff1a;&#xff08;\u548cPG\u4e00\u81f4&#xff0c;\u4f46\u662f\u8868\u5c5e\u6027\u6709\u5dee\u5f02&#xff08;CALL set_table_property&#xff09;&#xff09; <img decoding=\"async\" src=\"2025-06-22exdvwvtqyya.png\" alt=\"\u5efa\u8868\" \/> \u5206\u533a\u8868<\/p>\n<p>\u9759\u6001\u5206\u533a \u53ea\u80fd\u5411\u5b50\u8868\u63d2\u5165\u6570\u636e attach&#xff1a;\u7ed1\u5b9a\u7236\u8868 detach&#xff1a;\u89e3\u7ed1\u7236\u8868 <img decoding=\"async\" src=\"2025-06-22hb0h1dgbrl5.png\" alt=\"\u5206\u533a\u8868\" \/> \u52a8\u6001\u5206\u533a<\/p>\n<table>\n<tr>\u914d\u7f6e\u9879\u542b\u4e49<\/tr>\n<tbody>\n<tr>\n<td>auto_partitioning.enable<\/td>\n<td>\u5f00\u53bb\u52a8\u6001\u5206\u533a&#xff08;true\/false&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>auto_partitioning.time_unit<\/td>\n<td>\u65f6\u95f4\u5355\u4f4d&#xff0c;\u5c0f\u65f6\u3001\u5929DAY\u3001\u6708\u3001\u5b63\u5ea6\u3001\u5e74&#xff1a;\u6bcf\u5c0f\u65f6\u7b2c\u4e00\u79d2\/\u6bcf\u5929\u51cc\u6668\u7b2c\u4e00\u79d2\u8fdb\u884c\u5206\u533a\u521b\u5efa\u6216\u5220\u9664<\/td>\n<\/tr>\n<tr>\n<td>auto_partitioning.time_zone<\/td>\n<td>\u65f6\u533a&#xff08;Asia\/Shanghai&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>auto_partitioning.num_precreate<\/td>\n<td>\u521b\u5efa\u5206\u533a\u6570\u503c&#xff08;0-512&#xff0c;0\u8868\u793a\u4e0d\u8fdb\u884c\u9884\u521b\u5efa&#xff0c;4\u4ee3\u8868\u521b\u5efa4\u4e2a&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>auto_partitioning.num_retention<\/td>\n<td>\u4fdd\u7559\u5386\u53f2\u5206\u533a\u6570\u91cf&#xff08;0\u4e0d\u4fdd\u7559&#xff0c;-1\u4e0d\u6e05\u7406&#xff0c;\u6b63\u6570\u4fdd\u7559\u5386\u53f2\u5206\u533a\u4e2a\u6570&#xff0c;\u4e0d\u8d85\u8fc7512&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>keep_alive<\/td>\n<td>true\/false:\u4e0d\u5220\u9664\u8fc7\u671f\u6570\u636e\/\u7acb\u5373\u89e6\u53d1\u5220\u9664\u8fc7\u671f\u6570\u636e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u81ea\u52a8\u521b\u5efa\u5220\u9664\u5206\u533a <img decoding=\"async\" src=\"2025-06-22kkelo4v3sig.png\" alt=\"\u52a8\u6001\u5206\u533a\" \/> \u5916\u90e8\u8868 <img decoding=\"async\" src=\"2025-06-22felzseg20xs.png\" alt=\"\u5916\u90e8\u8868\" \/> \u89c6\u56fe\u64cd\u4f5c <img decoding=\"async\" src=\"2025-06-22epiozpa2pym.png\" alt=\"\u89c6\u56fe\" \/> \u63d2\u5165insert\u64cd\u4f5c&#xff1a; <img decoding=\"async\" src=\"2025-06-22xir4uke2wft.png\" alt=\"\u63d2\u5165\" \/> \u5220\u9664\u548c\u66f4\u65b0\u64cd\u4f5c <img decoding=\"async\" src=\"2025-06-22c1topwv3an5.png\" alt=\"\u5220\u9664\u548c\u66f4\u65b0\" \/> insert on conflict \u63d2\u5165\u6570\u636e\u7684\u65f6\u5019&#xff0c;\u4e3b\u952e\u6709\u91cd\u590d\u503c&#xff0c;\u9009\u62e9\u66f4\u65b0\u8fd8\u662f\u8df3\u8fc7 <img decoding=\"async\" src=\"2025-06-22t4wpp0tl0nb.png\" alt=\"insert on conflict\" \/> truncate\u6e05\u7a7a\u76ee\u6807\u8868 countinue identity \u52a0\u4e0a\u4ee3\u8868\u7ee7\u7eed\u6392\u5e8f&#xff0c;\u5e8f\u53f7\u4e0d\u6e05\u7a7a<\/p>\n<p><img decoding=\"async\" src=\"2025-06-22wkmhf2u3j1f.png\" alt=\"truncate\" \/><\/p>\n<h3>HologresSQL\u9ad8\u9636\u8bed\u6cd5<\/h3>\n<p>SQL-partition-Shard-Segment-Row-Block <img decoding=\"async\" src=\"2025-06-22aiag2nlwnv2.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> <img decoding=\"async\" src=\"2025-06-22rymazp0vgip.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u5b58\u50a8\u5c5e\u6027 <img decoding=\"async\" src=\"2025-06-22pkskzmbhsxm.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u884c\u5b58&#xff1a;\u4e3b\u952e\u70b9\u67e5\u8be2 \u5217\u5b58&#xff1a;\u6570\u636e\u5206\u6790OLAP \u884c\u5217\u5171\u5b58&#xff1a;\u90fd\u6709\u4f46\u5b58\u50a8\u5f00\u9500\u5927&#xff0c;\u4e5f\u9700\u8981\u4e3b\u952e<\/p>\n<p>\u5206\u5e03\u952e <img decoding=\"async\" src=\"2025-06-22mo3efhujwcp.png\" alt=\"\u5206\u5e03\" \/> \u5206\u6bb5\u952e <img decoding=\"async\" src=\"2025-06-22qsztxrx02ay.png\" alt=\"\u5206\u6bb5\" \/> \u805a\u7c07\u7d22\u5f15 <img decoding=\"async\" src=\"2025-06-22b34ourvzaq2.png\" alt=\"\u805a\u7c07\" \/><\/p>\n<p>\u5b57\u5178\u7f16\u7801 <img decoding=\"async\" src=\"2025-06-22jo00al5zxkt.png\" alt=\"\u5b57\u5178\u7f16\u7801\" \/> \u4f4d\u56fe\u7d22\u5f15 \u5411\u91cf\u8fdb\u884c\u9ad8\u6548\u8ba1\u7b97 <img decoding=\"async\" src=\"2025-06-22s13bxadtkaq.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u751f\u547d\u5468\u671f <img decoding=\"async\" src=\"2025-06-221vhuo0r3sf0.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>Binlog\u64cd\u4f5c<\/h4>\n<p><img decoding=\"async\" src=\"2025-06-22yargugop2y2.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> binglog\u683c\u5f0f<\/p>\n<p><img decoding=\"async\" src=\"2025-06-223lxe51g5m0k.png\" alt=\"\u683c\u5f0f\" \/> \u67e5\u8be2binlog <img decoding=\"async\" src=\"2025-06-225bqtwnuxe5o.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h4>\u6027\u80fd\u8c03\u4f18<\/h4>\n<p><img decoding=\"async\" src=\"2025-06-22dsnnupvdqza.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> \u66f4\u65b0\u7edf\u8ba1\u4fe1\u606f analyze <img decoding=\"async\" src=\"2025-06-22wl1g4uqaybq.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/> hologres\u6570\u636e\u5b58\u5728\u76d8\u53e4\u4e0a\u9762&#xff0c;\u4e00\u5f20\u8868\u6570\u636e\u5b58\u50a8\u5728\u56fa\u5b9a\u4e00\u7ec4\u8868\u4e0b&#xff0c;\u6839\u636e\u952e\u5206\u53d1\u5728\u4e0d\u540cshard\u4e0a\u9762<\/p>\n<p><img decoding=\"async\" src=\"2025-06-224q2lciwdejg.png\" alt=\"shard\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb218\u6b21\uff0c\u70b9\u8d5e3\u6b21\uff0c\u6536\u85cf2\u6b21\u3002Kappa\u67b6\u6784\uff1a\u5c06\u5b9e\u65f6\u548c\u79bb\u7ebf\u4ee3\u7801\u7edf\u4e00\uff08\u4f18\u5316lambda\u67b6\u6784\uff09\uff0c\u4f46\u662f\u4e0d\u597d\u4fee\u6b63\u6570\u636e\uff0c\u5f00\u53d1\u5468\u671f\u957f\uff0c\u6210\u672c\u6d6a\u8d39\uff0c\u5bf9\u4e8e\u5386\u53f2\u6570\u636e\u7684\u9ad8\u541e\u5410\u91cf\u529b\u4e0d\u4ece\u5fc3\u65e2\u53ef\u4ee5\u652f\u6301\u5206\u6790\u4e5f\u53ef\u4ee5\u652f\u6301\u4e8b\u52a1\uff1aHTAP\u6df7\u5408\u4e8b\u52a1\u5206\u6790\u7cfb\u7edf\u65e2\u53ef\u4ee5\u5206\u6790\u4e5f\u53ef\u4ee5\u670d\u52a1\uff1aHSAP\u670d\u52a1\/\u5206\u6790\u4e00\u4f53\u5316\uff1aHologres\u3002<\/p>\n","protected":false},"author":2,"featured_media":45116,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3249],"topic":[],"class_list":["post-45136","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-3249"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/45136.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb218\u6b21\uff0c\u70b9\u8d5e3\u6b21\uff0c\u6536\u85cf2\u6b21\u3002Kappa\u67b6\u6784\uff1a\u5c06\u5b9e\u65f6\u548c\u79bb\u7ebf\u4ee3\u7801\u7edf\u4e00\uff08\u4f18\u5316lambda\u67b6\u6784\uff09\uff0c\u4f46\u662f\u4e0d\u597d\u4fee\u6b63\u6570\u636e\uff0c\u5f00\u53d1\u5468\u671f\u957f\uff0c\u6210\u672c\u6d6a\u8d39\uff0c\u5bf9\u4e8e\u5386\u53f2\u6570\u636e\u7684\u9ad8\u541e\u5410\u91cf\u529b\u4e0d\u4ece\u5fc3\u65e2\u53ef\u4ee5\u652f\u6301\u5206\u6790\u4e5f\u53ef\u4ee5\u652f\u6301\u4e8b\u52a1\uff1aHTAP\u6df7\u5408\u4e8b\u52a1\u5206\u6790\u7cfb\u7edf\u65e2\u53ef\u4ee5\u5206\u6790\u4e5f\u53ef\u4ee5\u670d\u52a1\uff1aHSAP\u670d\u52a1\/\u5206\u6790\u4e00\u4f53\u5316\uff1aHologres\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/45136.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-22T05:19:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051938-6857926a59685.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/45136.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/45136.html\",\"name\":\"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-06-22T05:19:44+00:00\",\"dateModified\":\"2025-06-22T05:19:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/45136.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/45136.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/45136.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/45136.html","og_locale":"zh_CN","og_type":"article","og_title":"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb218\u6b21\uff0c\u70b9\u8d5e3\u6b21\uff0c\u6536\u85cf2\u6b21\u3002Kappa\u67b6\u6784\uff1a\u5c06\u5b9e\u65f6\u548c\u79bb\u7ebf\u4ee3\u7801\u7edf\u4e00\uff08\u4f18\u5316lambda\u67b6\u6784\uff09\uff0c\u4f46\u662f\u4e0d\u597d\u4fee\u6b63\u6570\u636e\uff0c\u5f00\u53d1\u5468\u671f\u957f\uff0c\u6210\u672c\u6d6a\u8d39\uff0c\u5bf9\u4e8e\u5386\u53f2\u6570\u636e\u7684\u9ad8\u541e\u5410\u91cf\u529b\u4e0d\u4ece\u5fc3\u65e2\u53ef\u4ee5\u652f\u6301\u5206\u6790\u4e5f\u53ef\u4ee5\u652f\u6301\u4e8b\u52a1\uff1aHTAP\u6df7\u5408\u4e8b\u52a1\u5206\u6790\u7cfb\u7edf\u65e2\u53ef\u4ee5\u5206\u6790\u4e5f\u53ef\u4ee5\u670d\u52a1\uff1aHSAP\u670d\u52a1\/\u5206\u6790\u4e00\u4f53\u5316\uff1aHologres\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/45136.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-06-22T05:19:44+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250622051938-6857926a59685.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/45136.html","url":"https:\/\/www.wsisp.com\/helps\/45136.html","name":"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-06-22T05:19:44+00:00","dateModified":"2025-06-22T05:19:44+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/45136.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/45136.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/45136.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u963f\u91cc\u4e91ACP\u8ba4\u8bc1-\u6570\u636e\u4ed3\u5e93"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/45136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=45136"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/45136\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/45116"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=45136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=45136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=45136"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=45136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}