{"id":2194,"date":"2026-05-17T13:37:24","date_gmt":"2026-05-17T05:37:24","guid":{"rendered":"http:\/\/www.821121.com\/?p=2194"},"modified":"2026-05-27T23:40:06","modified_gmt":"2026-05-27T15:40:06","slug":"26ai%e6%96%b0%e7%89%b9%e6%80%a7%e4%b9%8b%e5%8f%af%e7%9b%b4%e6%8e%a5%e8%af%bb%e5%86%99%e5%a4%96%e9%83%a8-iceberg-%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=2194","title":{"rendered":"26ai\u65b0\u7279\u6027\u4e4b\u53ef\u76f4\u63a5\u8bfb\u5199\u5916\u90e8 Iceberg \u6570\u636e"},"content":{"rendered":"<p>Apache Iceberg \u4f5c\u4e3a\u5f00\u6e90\u5f00\u653e\u7684\u8868\u683c\u5f0f\u6807\u51c6\uff0c\u51ed\u501f ACID \u4e8b\u52a1\u3001Schema \u6f14\u8fdb\u3001\u65f6\u95f4\u65c5\u884c\u3001\u591a\u5f15\u64ce\u517c\u5bb9\u80fd\u529b\uff0c\u6210\u4e3a\u6253\u901a\u5f02\u6784\u6570\u636e\u5e73\u53f0\u7684\u6838\u5fc3\u57fa\u77f3\u3002\u800c\u5168\u65b0 Oracle AI Database\uff0823ai\/26ai\uff09\u91cd\u78c5\u843d\u5730\u539f\u751f Iceberg \u53cc\u5411\u8bfb\u5199\u80fd\u529b\uff0c\u5f7b\u5e95\u7ec8\u7ed3\u8de8\u5e73\u53f0\u6570\u636e\u642c\u8fd0\u96be\u9898\u3002<\/p>\n<h4>\u524d\u7f6e\u914d\u7f6e<\/h4>\n<p>\u914d\u7f6e\u5bf9\u8c61\u5b58\u50a8\u8bbf\u95ee\u51ed\u8bc1\u3001\u7ed1\u5b9a\u5bf9\u5e94 Iceberg Catalog\uff08Unity Catalog \/ Polaris\uff09\uff0c\u901a\u8fc7 Oracle \u5185\u7f6e DBMS_CATALOG \u5305\u5b8c\u6210\u6ce8\u518c\u3002<\/p>\n<h4>\u521b\u5efa Iceberg \u5916\u90e8\u8868\uff08\u8bfb\u5199\u901a\u7528\uff09<\/h4>\n<pre><code class=\"language-sql\">-- \u521b\u5efa\u6307\u5411\u5916\u90e8Iceberg\u8868\u7684\u5916\u90e8\u8868\uff08\u81ea\u52a8\u9002\u914dDatabricks\/Snowflake\u751f\u6210\u7684Iceberg\u7ed3\u6784\uff09\nCREATE EXTERNAL TABLE ORACLE_ICEBERG_SALE (\n    SALE_ID    NUMBER,\n    USER_ID    VARCHAR2(64),\n    AMOUNT     NUMBER(18,2),\n    SALE_TIME  TIMESTAMP\n)\nORGANIZATION EXTERNAL\n(\n  TYPE ICEBERG\n  DEFAULT DIRECTORY OBJ_STORE_BUCKET\n  ACCESS PARAMETERS\n  (\n    CATALOG_NAME &#039;UNITY_CATALOG&#039; -- \u5bf9\u63a5Databricks Unity Catalog\n    DATABASE_NAME &#039;DB_LAKE&#039;\n    TABLE_NAME &#039;SALE_DETAIL&#039;\n  )\n)\nREJECT LIMIT UNLIMITED;<\/code><\/pre>\n<h4>\u53cc\u5411\u8bfb\u5199\u64cd\u4f5c\uff08\u5b8c\u5168\u517c\u5bb9\u6807\u51c6SQL\uff09<\/h4>\n<pre><code class=\"language-sql\">-- 1. \u67e5\u8be2Databricks\/Snowflake\u751f\u6210\u7684Iceberg\u6570\u636e\nSELECT * FROM ORACLE_ICEBERG_SALE WHERE SALE_TIME &gt; SYSDATE-7;\n\n-- 2. \u76f4\u63a5\u5199\u5165\u6570\u636e\uff08\u81ea\u52a8\u66f4\u65b0Iceberg\u5143\u6570\u636e\uff0c\u8de8\u5e73\u53f0\u5b9e\u65f6\u53ef\u89c1\uff09\nINSERT INTO ORACLE_ICEBERG_SALE VALUES(1001,&#039;U2026001&#039;,99.90,SYSDATE);\n\n-- 3. \u66f4\u65b0\u3001\u5220\u9664\u6e56\u4ed3\u6570\u636e\uff08\u652f\u6301\u4e8b\u52a1\u4e00\u81f4\u6027\uff09\nUPDATE ORACLE_ICEBERG_SALE SET AMOUNT=89.90 WHERE SALE_ID=1001;\nDELETE FROM ORACLE_ICEBERG_SALE WHERE SALE_ID=1001;\n\n-- 4. \u652f\u6301Iceberg\u4e13\u5c5e\u80fd\u529b\uff1a\u65f6\u95f4\u65c5\u884c\u67e5\u8be2\nSELECT * FROM ORACLE_ICEBERG_SALE\nFOR ICEBERG AS OF TIMESTAMP TO_TIMESTAMP(&#039;2026-05-27 10:00:00&#039;,&#039;YYYY-MM-DD HH24:MI:SS&#039;);<\/code><\/pre>\n<p>\u6240\u6709\u8bfb\u5199\u64cd\u4f5c\u5b8c\u5168\u9075\u5faa Iceberg \u4e8b\u52a1\u89c4\u8303\uff0c\u4fee\u6539\u540e\u7684\u6570\u636e\u53ef\u5728 Databricks\u3001Snowflake \u4e2d\u76f4\u63a5\u67e5\u8be2\uff0c\u65e0\u9700\u4efb\u4f55\u540c\u6b65\u64cd\u4f5c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Apache Iceberg \u4f5c\u4e3a\u5f00\u6e90\u5f00\u653e\u7684\u8868\u683c\u5f0f<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,76],"tags":[],"class_list":["post-2194","post","type-post","status-publish","format-standard","hentry","category-oracle-26ai","category--oracle-26ai"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2194"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2194\/revisions"}],"predecessor-version":[{"id":2195,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/2194\/revisions\/2195"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2194"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}