在磚ANSI的合規運行時|磚在穀歌的雲</t我tle> <link href="https://agao00.github.io/static/css/2.fb64e31e.chunk.css" rel="stylesheet"> <link href="https://agao00.github.io/static/css/main.06d416f3.chunk.css" rel="stylesheet"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/docs.gcp/_static/css/theme.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/docs.gcp/_static/css/custom.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/docs.gcp/_static/css/algolia.css" type="text/css"> <link rel="stylesheet" href="//www.eheci.com/docs.gcp/docs.gcp/_static/css/cloud-provider-selector.css" type="text/css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/searchbox.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/external_styles.css"> <link rel="stylesheet" href="https://databricks.searchunify.com/resources/search_clients_custom/80c8c516-6f89-11eb-883d-06d762ad9a62/feedback.css"> </head> <body class="wy-body-for-nav ANSI compliance in Databricks Runtime" role="document">  <noscript> <iframe src="https://www.eheci.com/ns.html?id=GTM-T85FQ33" height="0" width="0" style="display:none;visibility:hidden"></iframe> </noscript> <noscript> <iframe src="https://www.eheci.com/ns.html?id=GTM-TWTKQQ" height="0" width="0" style="display:none;visibility:hidden"></iframe> </noscript>  <nav class="wy-nav-top header su_header" role="navigation" aria-label="top navigation"> <nav class="wy-nav-top header su_header" role="navigation" aria-label="top navigation"> <div class="container-logo"> <ul class="mobile-menu-toggle"> <li class="menu-toggle"><i data-toggle="wy-nav-top" class="wy-nav-top-menu-button db-icon db-icon-menu pull-left"></i><a href="//www.eheci.com/" class="wy-nav-top-logo"><img src="//www.eheci.com/docs.gcp/docs.gcp/_static/databricks-logo-mobile.png" width="137" height="21" alt="磚"></a></li> </ul> <ul class="su_nav-menu"> <li class="menu-toggle"><i data-toggle="wy-nav-top" class="wy-nav-top-menu-button db-icon db-icon-menu pull-left"></i><a href="//www.eheci.com/" class="wy-nav-top-logo"><img src="//www.eheci.com/docs.gcp/docs.gcp/_static/databricks-logo-mobile.png" width="137" height="21" alt="磚"></a></li> </ul> </div> <div class="su_nav-right"> <ul class="su_link-mobile">  </ul> <ul class="right-try-list"> <li><a href="//www.eheci.com/help">支持</一個></li> <li><a href="mailto:doc-feedback@www.eheci.com?subject=Documentation Feedback">反饋</一個></li> <li class="try-databrick-item"><a href="//www.eheci.com/docs.gcp/try-databricks">試著磚</一個></li> </ul> </div> </nav> </nav> <div class="su_sub-header"> <div class="container"> <div class="su_sub-header-inner"> <div class="su_subnav-menu"> <ul> <li><a href="//www.eheci.com/help/s/">幫助中心</一個></li> <li class="active"><a href="//www.eheci.com/docs.gcp/">文檔</一個></li> <li><a href="//www.eheci.com/kb.gcp/">知識庫</一個></li> </ul> </div> <div class="su_subnav-menu-right"> <div id="auto" style="width: 100%"> <div ng-controller="SearchautoController"> <div bind-html-compile="autocompleteHtml"> <form class="su__search-box-1"> <input class="su__search-input" type="search" name="Search box" id="su__search-b" placeholder="Search here"> <button class="button button-success" type="submit" on> <svg width="20" height="20" viewbox="0 0 28 28"> <path fill="#fff" d="M1688.27,61.271a1.327,1.327,0,0,1,0,1.859l-1.54,1.531a1.25,1.25,0,0,1-.93.383,1.282,1.282,0,0,1-.93-0.383l-5.46-5.469a1.254,1.254,0,0,1-.39-0.93V57.388a11.4,11.4,0,0,1-12.71.875,11.5,11.5,0,0,1-4.13-4.129,11.438,11.438,0,0,1,0-11.43,11.5,11.5,0,0,1,4.13-4.129,11.431,11.431,0,0,1,11.43,0,11.5,11.5,0,0,1,4.13,4.129,11.4,11.4,0,0,1-.88,12.715h0.88a1.282,1.282,0,0,1,.93.383Zm-16.25-5.852a6.952,6.952,0,0,0,3.53-.93,6.772,6.772,0,0,0,2.54-2.543,7.154,7.154,0,0,0,0-7.055,6.772,6.772,0,0,0-2.54-2.543,7.147,7.147,0,0,0-7.05,0,6.8,6.8,0,0,0-2.55,2.543,7.154,7.154,0,0,0,0,7.055,6.8,6.8,0,0,0,2.55,2.543A6.916,6.916,0,0,0,1672.02,55.419Z" transform="translate(-1660.66 -37.031)"></path> </svg></button> </form> </div> </div> </div> </div> <div> <select name="cloud provider selector" id="cloud-provider-selector"><option value="aws">亞馬遜網絡服務</option><option value="azure">微軟Azure</option><option value="gcp" selected>穀歌雲平台Beplay体育安卓版本</option></select> </div> </div> </div> </div> <page class="js-page-container"> <nav data-toggle="wy-nav-shift" class="wy-nav-side su_nav-side"> <div class="wy-side-scroll"> <div class="wy-side-nav-search"></div> <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation"> <a href="//www.eheci.com/docs.gcp/docs.gcp/index.html" class="main-navigation-home">磚在穀歌的雲</一個><p class="caption"><span class="caption-text">開始</span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/getting-started/index.html">開始</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/introduction/index.html">磚是什麼?</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/getting-started/tutorials/index.html">教程和最佳實踐</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/release-notes/index.html">發布說明</一個></li> </ul> <p class="caption"><span class="caption-text">加載和管理數據</span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/ingestion/index.html">加載數據</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/exploratory-data-analysis/index.html">探索數據</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/data-preparation/index.html">準備數據</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/data-sharing/index.html">共享數據(δ共享)</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/marketplace/index.html">市場數據</一個></li> </ul> <p class="caption"><span class="caption-text">處理數據</span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/workspace-index.html">工程數據</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/machine-learning/index.html">機器學習</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/index.html">數據倉庫</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/delta/index.html">三角洲湖</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/dev-tools/index.html">開發人員工具</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/integrations/index.html">技術合作夥伴</一個></li> </ul> <p class="caption"><span class="caption-text">政府</span></p> <ul> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/administration-guide/index.html">賬戶和工作區管理</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/security/index.html">安全性和遵從性</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/data-governance/index.html">數據治理</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/lakehouse-architecture/index.html">Lakehouse架構</一個></li> </ul> <p class="caption"><span class="caption-text">引用和資源</span></p> <ul class="current"> <li class="toctree-l1 current"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/reference/api.html">參考</一個><ul class="current"> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/languages/index.html">Python, SparkR & Scala的介紹</一個></li> <li class="toctree-l2"><a class="reference external" href="//www.eheci.com/docs/api/gcp/workspace/introduction">REST API參考</一個></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/reference/mlflow-api.html">MLFlow API</一個></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/dev-tools/api/python/latest/index.html">Python API特性存儲</一個></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/reference/spark.html">Apache火花API</一個></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/reference/delta-lake.html">三角洲湖API</一個></li> <li class="toctree-l2"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/delta-live-tables/api-guide.html">三角洲生活表API</一個></li> <li class="toctree-l2 current"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/index.html">SQL語言參考</一個><ul class="current"> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/applies-to-info.html">“適用於”標簽</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-diagram.html">如何閱讀語法圖嗎</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-parameters.html">配置參數</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-datatypes.html">數據類型和文字</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-functions.html">功能</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-datatype-rules.html">SQL數據類型規則</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-datetime-pattern.html">Datetime模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-h3-geospatial-functions.html">H3地理空間功能</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-lambda-functions.html">Lambda函數</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-window-functions.html">窗口函數</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-identifiers.html">標識符</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-names.html">的名字</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-null-semantics.html">零語義</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-expression.html">表達式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-parameter-marker.html">參數標記</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-name-resolution.html">名稱解析</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-json-path-expression.html">JSON路徑表達式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-partition.html">分區</一個></li> <li class="toctree-l3 current"><a class="current reference internal" href="//www.eheci.com/docs.gcp/sql/language-manual/#">在磚ANSI的合規運行時</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-hive-compatibility.html">Apache蜂巢的兼容性</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-principal.html">校長</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-privileges.html">統一目錄中的特權和可獲得的對象</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-privileges-hms.html">在蜂巢metastore特權和可獲得的對象</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-external-locations.html">外部位置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-external-tables.html">外部表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-storage-credentials.html">存儲憑證</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-sharing.html">三角洲分享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-information-schema.html">信息模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-reserved-words.html">保留字</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-catalog.html">改變目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-credential.html">改變憑據</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-database.html">修改數據庫</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-location.html">改變位置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-provider.html">改變供應商</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-recipient.html">改變收件人</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-table-add-constraint.html">添加約束條款</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-table-drop-constraint.html">刪除約束條款</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-table.html">ALTER TABLE</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-schema.html">改變模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-share.html">改變分享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-alter-view.html">改變觀點</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-comment.html">評論</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-create-bloomfilter-index.html">創建BLOOMFILTER索引</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-catalog.html">創建目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-database.html">創建數據庫</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-sql-function.html">創建函數(SQL)</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-function.html">創建函數(外部)</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-location.html">創建位置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-recipient.html">創建收件人</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-schema.html">創建模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-share.html">創建共享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html">創建表(使用)</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-table-like.html">創建表像</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-table-constraint.html">約束條款</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-clone.html">創建表克隆</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-tblproperties.html">表屬性和表選項</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-table-hiveformat.html">用蜂巢創建表的格式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-table.html">創建表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-create-view.html">創建視圖</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-drop-bloomfilter-index.html">BLOOMFILTER指數下降</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-catalog.html">刪除目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-database.html">刪除數據庫</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-credential.html">把憑證</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-function.html">刪除函數</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-location.html">下降的位置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-provider.html">減少供應商</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-recipient.html">把收件人</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-schema.html">刪除模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-share.html">份額下降</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-table.html">刪除表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-drop-view.html">刪除視圖</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-repair-table.html">MSCK修理表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-sync.html">同步</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-truncate-table.html">截斷表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html">UNDROP表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-copy-into.html">複製到</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-delete-from.html">刪除從</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-dml-insert-into.html">插入</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-dml-insert-overwrite-directory.html">插入覆蓋目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-dml-insert-overwrite-directory-hive.html">插入覆蓋與蜂巢目錄格式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-dml-load.html">加載數據</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-merge-into.html">合並成</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-update.html">更新</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-qry-query.html">查詢</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-qry-select.html">選擇</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-qry-select-values.html">值</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-qry-explain.html">解釋</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-cache.html">緩存選擇</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-convert-to-delta.html">轉換為δ</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-describe-history.html">描述曆史</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-fsck.html">FSCK修理表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-generate.html">生成</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-optimize.html">優化</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-reorg-table.html">REORG表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-restore.html">恢複</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/delta-vacuum.html">真空</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-analyze-table.html">分析表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-cache-cache-table.html">緩存表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-cache-clear-cache.html">清除緩存</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-cache-refresh.html">刷新</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-cache-refresh-function.html">刷新功能</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-cache-refresh-table.html">刷新表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-cache-uncache-table.html">UNCACHE表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-catalog.html">描述目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-credential.html">描述了證書</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-database.html">描述數據庫</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-function.html">描述函數</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-location.html">描述位置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-provider.html">描述提供者</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-query.html">描述查詢</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-recipient.html">描述收件人</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-schema.html">描述模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-share.html">描述分享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-describe-table.html">描述表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-list.html">列表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-all-in-share.html">顯示所有股票</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-catalogs.html">顯示目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-columns.html">顯示列</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-create-table.html">顯示創建表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-credentials.html">顯示憑證</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-databases.html">顯示數據庫</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-functions.html">顯示功能</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-groups.html">顯示組</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-locations.html">顯示位置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-partitions.html">顯示分區</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-providers.html">節目提供者</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-recipients.html">顯示收件人</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-schemas.html">顯示模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-shares.html">顯示股票</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-shares-in-provider.html">節目提供者的股票</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-table.html">顯示表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-tables.html">顯示表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-tables-dropped.html">顯示表了</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-tblproperties.html">顯示TBLPROPERTIES</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-users.html">顯示用戶</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-show-views.html">顯示視圖</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-conf-mgmt-reset.html">重置</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-conf-mgmt-set.html">集</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-conf-mgmt-set-timezone.html">設置時區</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-use-catalog.html">使用目錄</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-usedb.html">使用數據庫</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-ddl-use-schema.html">使用模式</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-resource-mgmt-add-archive.html">添加歸檔</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-resource-mgmt-add-file.html">添加文件</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-resource-mgmt-add-jar.html">添加JAR</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-resource-mgmt-list-archive.html">檔案列表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-resource-mgmt-list-file.html">列表文件</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/sql-ref-syntax-aux-resource-mgmt-list-jar.html">JAR列表</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-alter-group.html">改變組</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-create-group.html">創建組</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-deny.html">否認</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-drop-group.html">降低集團</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-grant.html">格蘭特</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-grant-share.html">格蘭特分享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-msck.html">修複權限</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-revoke.html">撤銷</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-revoke-share.html">撤銷分享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-show-grant.html">秀獎助金</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-show-grant-on-share.html">資助的節目分享</一個></li> <li class="toctree-l3"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/security-show-grant-to-recipient.html">顯示贈款接受者</一個></li> </ul></li> </ul></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/resources/index.html">資源</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/whats-coming.html">未來是什麼?</一個></li> <li class="toctree-l1"><a class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/archive/index.html">文檔歸檔</一個></li> </ul> </div> <div role="contentinfo"> <p class="build_info" data-last-edit="March 27, 2023">2023年6月21日更新</p> <p><a id="feedbacklink" href="mailto:doc-feedback@www.eheci.com?subject=Documentation Feedback">給我們反饋</一個></p> </div> </div> </nav> <main class="wy-grid-for-nav su_nav-grid"> <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap"> <div class="wy-nav-content su__nav_content"> <div class="rst-content"> <div role="navigation" aria-label="breadcrumbs navigation" class="wy-breadcrumbs-wrapper"> <ul class="wy-breadcrumbs"> <li><a href="//www.eheci.com/docs.gcp/docs.gcp/index.html">文檔</一個><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs.gcp/docs.gcp/reference/api.html">磚參考文檔</一個><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs.gcp/docs.gcp/languages/index.html">特定於語言的介紹磚</一個><span class="db-icon db-icon-chevron-right"></span></li> <li><a href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/index.html">SQL語言參考</一個><span class="db-icon db-icon-chevron-right"></span></li> <li>在磚ANSI的合規運行時</li> <li class="wy-breadcrumbs-aside"></li> </ul> </div> <div role="main" class="document" itemscope itemtype="http://schema.org/Article"> <div itemprop="articleBody"> <div class="section" id="ansi-compliance-in-databricks-runtime"> <span id="ansi-compliance-in-dbr"></span> <h1>在磚ANSI的合規運行時<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#ansi-compliance-in-databricks-runtime" title=""></a></h1> <p><strong>適用於:</strong><img alt="檢查標記是的" src="//www.eheci.com/docs.gcp/docs.gcp/_images/check.png">磚運行時</p> <p>本文描述了在磚ANSI的合規運行時。ANSI SQL模式數據磚,請參閱<一個class="reference internal" href="//www.eheci.com/docs.gcp/docs.gcp/sql/language-manual/parameters/ansi_mode.html"><span class="doc">ANSI_MODE</span></a>。</p> <p>火花SQL有兩個選項支持符合ANSI SQL標準:<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>和<code class="docutils literal notranslate"><span class="pre">spark.sql.storeAssignmentPolicy</span></code>。</p> <p>當<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>被設置為<code class="docutils literal notranslate"><span class="pre">真正的</span></code>,火花SQL使用ANSI兼容的方言,而不是蜂巢兼容。例如,火花會在運行時拋出異常,而不是返回null結果如果輸入SQL操作符/函數是無效的。ANSI方言一些特性可能不是直接從ANSI SQL標準,但是他們的行為與ANSI SQL的風格一致。</p> <p>此外,火花SQL有獨立的選項來控製隱式鑄造行為當插入一個表中的記錄。鑄造的行為被定義為存儲分配規則的標準。</p> <p>當<code class="docutils literal notranslate"><span class="pre">spark.sql.storeAssignmentPolicy</span></code>被設置為<code class="docutils literal notranslate"><span class="pre">ANSI</span></code>,火花符合ANSI SQL存儲分配規則。這是一個單獨的配置,因為它的默認值<code class="docutils literal notranslate"><span class="pre">ANSI</span></code>,而配置<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>默認情況下是禁用的。</p> <p>下表總結了行為:</p> <table class="docutils align-default"> <colgroup> <col style="width: 33%"> <col style="width: 33%"> <col style="width: 33%"> </colgroup> <thead> <tr class="row-odd"> <th class="head"><p>屬性名</p></th> <th class="head"><p>默認的</p></th> <th class="head"><p>意義</p></th> </tr> </thead> <tbody> <tr class="row-even"> <td><p><code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code></p></td> <td><p>假</p></td> <td><p>時真的,火花嚐試符合ANSI SQL規範:</p> <ul class="simple"> <li><p>拋出一個運行時異常如果一個溢出發生在任何操作在一個整數或小數。</p></li> <li><p>禁止使用保留關鍵字標識符的ANSI SQL SQL解析器。</p></li> </ul></td> </tr> <tr class="row-odd"> <td><p><code class="docutils literal notranslate"><span class="pre">spark.sql.storeAssignmentPolicy</span></code></p></td> <td><p>ANSI</p></td> <td><p>當一個值插入一列有不同的數據類型,火花執行類型轉換。有三個政策強製類型轉換規則:<code class="docutils literal notranslate"><span class="pre">ANSI</span></code>,<code class="docutils literal notranslate"><span class="pre">遺產</span></code>,<code class="docutils literal notranslate"><span class="pre">嚴格的</span></code>。</p> <ul class="simple"> <li><p><code class="docutils literal notranslate"><span class="pre">ANSI</span></code>:火花執行類型強製按照ANSI SQL。在實踐中,主要是一樣的PostgreSQL的行為。它不允許某些不合理等類型轉換將字符串轉換為int或雙布爾。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">遺產</span></code>:火花允許強製類型轉換,隻要它是有效的,這是非常寬鬆。例如,將字符串轉換為int或雙布爾是被允許的。它也是唯一的行為引發2。x和兼容蜂巢。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">嚴格的</span></code>:火花不允許任何可能的精度損失或數據截斷的強製類型轉換,例如,將雙整數或小數雙是不允許的。</p></li> </ul></td> </tr> </tbody> </table> <p>下麵的小禮物的行為變化的算術運算,類型轉換,當ANSI SQL解析模式啟用。火花類型轉換的SQL,有三種,本文將介紹他們一個接一個:演員、存儲分配和強製類型轉換。</p> <div class="section" id="arithmetic-operations"> <h2>算術運算<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#arithmetic-operations" title=""></a></h2> <p>在火花SQL,算術運算進行數值類型(除了小數)不檢查默認溢出。這意味著如果一個操作導致溢出,結果都是一樣的,在Java或Scala程序中相應的操作(例如,如果兩個整數之和大於最大值可表示的,結果是負數)。另一方麵,火花SQL返回null十進製溢出。當<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>被設置為<code class="docutils literal notranslate"><span class="pre">真正的</span></code>和一個溢出發生在數字和區間算術運算,它在運行時拋出一個算術異常。</p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——“spark.sql.ansi.enabled = true”</span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="mi">2147483647</span><span class="w"></span><span class="o">+</span><span class="w"></span><span class="mi">1</span><span class="p">;</span><span class="w"></span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="nb">整數</span><span class="w"></span><span class="n">溢出</span><span class="w"></span><span class="c1">——“spark.sql.ansi.enabled = false”</span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="mi">2147483647</span><span class="w"></span><span class="o">+</span><span class="w"></span><span class="mi">1</span><span class="p">;</span><span class="w"></span><span class="w"></span><span class="o">- - - - - -</span><span class="mi">2147483648</span><span class="w"></span></pre> </div> </div> </div> <div class="section" id="cast"> <h2>投<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#cast" title=""></a></h2> <p>當<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>被設置為<code class="docutils literal notranslate"><span class="pre">真正的</span></code>顯式鑄造,<code class="docutils literal notranslate"><span class="pre">投</span></code>語法拋出一個運行時異常非法投模式中定義的標準,如將從一個字符串轉換為一個整數。</p> <p>的<code class="docutils literal notranslate"><span class="pre">投</span></code>火花ANSI模式遵循語法規則條款第6.13節“鑄規範”<一個class="reference external" href="https://www.iso.org/standard/53682.html">ISO / IEC 9075 - 2:2011信息技術——數據庫語言- SQL -第2部分:基礎(SQL /基金會)</一個>,除了它特別允許以下簡單類型轉換是不允許按照ANSI標準:</p> <ul class="simple"> <li><p>NumericType < = > BooleanType</p></li> <li><p>StringType < = > BinaryType</p></li> </ul> <p>有效的源和目標數據類型的組合<code class="docutils literal notranslate"><span class="pre">投</span></code>表達式由下表給出。“Y”表明,結合語法有效沒有限製和“N”表明,組合是無效的。</p> <table class="docutils align-default"> <colgroup> <col style="width: 18%"> <col style="width: 9%"> <col style="width: 8%"> <col style="width: 5%"> <col style="width: 12%"> <col style="width: 11%"> <col style="width: 9%"> <col style="width: 8%"> <col style="width: 7%"> <col style="width: 4%"> <col style="width: 8%"> </colgroup> <thead> <tr class="row-odd"> <th class="head"><p>SourceTarget</p></th> <th class="head"><p>數字</p></th> <th class="head"><p>字符串</p></th> <th class="head"><p>日期</p></th> <th class="head"><p>時間戳</p></th> <th class="head"><p>時間間隔</p></th> <th class="head"><p>布爾</p></th> <th class="head"><p>二進製</p></th> <th class="head"><p>數組</p></th> <th class="head"><p>地圖</p></th> <th class="head"><p>結構體</p></th> </tr> </thead> <tbody> <tr class="row-even"> <td><p>數字</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>字符串</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>日期</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>時間戳</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>時間間隔</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>布爾</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>二進製</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>數組</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>地圖</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>結構體</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> </tr> </tbody> </table> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——明確鑄造的例子</span><span class="c1">——“spark.sql.ansi.enabled = true”</span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">投</span><span class="p">(</span><span class="s1">“一個”</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">無效的</span><span class="w"></span><span class="k">輸入</span><span class="w"></span><span class="n">語法</span><span class="w"></span><span class="k">為</span><span class="w"></span><span class="k">類型</span><span class="w"></span><span class="nb">數字</span><span class="p">:</span><span class="w"></span><span class="n">一個</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">投</span><span class="p">(</span><span class="mi">2147483648</span><span class="n">l</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">鑄造</span><span class="w"></span><span class="mi">2147483648</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="nb">int</span><span class="w"></span><span class="n">原因</span><span class="w"></span><span class="n">溢出</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">投</span><span class="p">(</span><span class="nb">日期</span><span class="s1">“2020-01-01”</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="nb">INT</span><span class="p">)</span><span class="w"></span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">不能</span><span class="w"></span><span class="n">解決</span><span class="w"></span><span class="s1">“鑄(日期”</span><span class="mi">2020年</span><span class="o">- - - - - -</span><span class="mi">01</span><span class="o">- - - - - -</span><span class="mi">01</span><span class="s1">“INT)”</span><span class="w"></span><span class="n">由於</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="k">數據</span><span class="w"></span><span class="k">類型</span><span class="w"></span><span class="n">不匹配</span><span class="p">:</span><span class="w"></span><span class="n">不能</span><span class="w"></span><span class="k">投</span><span class="w"></span><span class="nb">日期</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="nb">int</span><span class="p">。</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="k">轉換</span><span class="w"></span><span class="k">值</span><span class="w"></span><span class="k">從</span><span class="w"></span><span class="nb">日期</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="nb">int</span><span class="p">,</span><span class="w"></span><span class="n">你</span><span class="w"></span><span class="n">可以</span><span class="w"></span><span class="n">使用</span><span class="w"></span><span class="k">函數</span><span class="w"></span><span class="n">UNIX_DATE</span><span class="w"></span><span class="k">而不是</span><span class="p">。</span><span class="w"></span><span class="c1">——“spark.sql.ansi.enabled = false”(This is a default behavior)</span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">投</span><span class="p">(</span><span class="s1">“一個”</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="k">零</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">投</span><span class="p">(</span><span class="mi">2147483648</span><span class="n">l</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="o">- - - - - -</span><span class="mi">2147483648</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">投</span><span class="p">(</span><span class="nb">日期</span><span class="s1">“2020-01-01”</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="k">零</span><span class="w"></span><span class="c1">——存儲分配規則的例子</span><span class="o">></span><span class="w"></span><span class="k">創建</span><span class="w"></span><span class="k">表</span><span class="w"></span><span class="n">t</span><span class="w"></span><span class="p">(</span><span class="n">v</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="c1">——“spark.sql.storeAssignmentPolicy = ANSI”</span><span class="o">></span><span class="w"></span><span class="k">插入</span><span class="w"></span><span class="k">成</span><span class="w"></span><span class="n">t</span><span class="w"></span><span class="k">值</span><span class="w"></span><span class="p">(</span><span class="s1">' 1 '</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">不能</span><span class="w"></span><span class="k">寫</span><span class="w"></span><span class="n">不兼容的</span><span class="w"></span><span class="k">數據</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="k">表</span><span class="w"></span><span class="s1">“違約”。“t”</span><span class="p">:</span><span class="w"></span><span class="o">- - - - - -</span><span class="w"></span><span class="n">不能</span><span class="w"></span><span class="n">安全</span><span class="w"></span><span class="k">投</span><span class="w"></span><span class="s1">“v”</span><span class="p">:</span><span class="w"></span><span class="n">字符串</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="nb">int</span><span class="p">;</span><span class="w"></span><span class="c1">——“spark.sql。storeAssignmentPolicy =遺產”(這是一個遺留的行為直到火花2. x)</span><span class="o">></span><span class="w"></span><span class="k">插入</span><span class="w"></span><span class="k">成</span><span class="w"></span><span class="n">t</span><span class="w"></span><span class="k">值</span><span class="w"></span><span class="p">(</span><span class="s1">' 1 '</span><span class="p">);</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="o">*</span><span class="w"></span><span class="k">從</span><span class="w"></span><span class="n">t</span><span class="p">;</span><span class="w"></span><span class="w"></span><span class="mi">1</span><span class="w"></span></pre> </div> </div> </div> <div class="section" id="store-assignment"> <h2>存儲分配<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#store-assignment" title=""></a></h2> <p>正如一開始所提到的,當<code class="docutils literal notranslate"><span class="pre">spark.sql.storeAssignmentPolicy</span></code>被設置為<code class="docutils literal notranslate"><span class="pre">ANSI</span></code>(這是默認值),火花符合ANSI SQL存儲分配規則表插入。源和目標的有效組合表插入數據類型由下表給出。</p> <table class="docutils align-default"> <colgroup> <col style="width: 18%"> <col style="width: 9%"> <col style="width: 8%"> <col style="width: 5%"> <col style="width: 12%"> <col style="width: 11%"> <col style="width: 9%"> <col style="width: 8%"> <col style="width: 7%"> <col style="width: 4%"> <col style="width: 8%"> </colgroup> <thead> <tr class="row-odd"> <th class="head"><p>SourceTarget</p></th> <th class="head"><p>數字</p></th> <th class="head"><p>字符串</p></th> <th class="head"><p>日期</p></th> <th class="head"><p>時間戳</p></th> <th class="head"><p>時間間隔</p></th> <th class="head"><p>布爾</p></th> <th class="head"><p>二進製</p></th> <th class="head"><p>數組</p></th> <th class="head"><p>地圖</p></th> <th class="head"><p>結構體</p></th> </tr> </thead> <tbody> <tr class="row-even"> <td><p>數字</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>字符串</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>日期</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>時間戳</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>時間間隔</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>布爾</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>二進製</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>數組</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y *</p></td> <td><p>N</p></td> <td><p>N</p></td> </tr> <tr class="row-even"> <td><p>地圖</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y *</p></td> <td><p>N</p></td> </tr> <tr class="row-odd"> <td><p>結構體</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>N</p></td> <td><p>Y *</p></td> </tr> </tbody> </table> <p>*數組/地圖/結構體類型、數據類型檢查規則遞歸地適用於它的組成元素。</p> <p>在表中插入,火花將拋出異常數值溢出。</p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="o">></span><span class="w"></span><span class="k">創建</span><span class="w"></span><span class="k">表</span><span class="w"></span><span class="n">測試</span><span class="p">(</span><span class="n">我</span><span class="w"></span><span class="nb">INT</span><span class="p">);</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">插入</span><span class="w"></span><span class="k">成</span><span class="w"></span><span class="n">測試</span><span class="w"></span><span class="k">值</span><span class="w"></span><span class="p">(</span><span class="mi">2147483648</span><span class="n">l</span><span class="p">);</span><span class="w"></span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">鑄造</span><span class="w"></span><span class="mi">2147483648</span><span class="w"></span><span class="k">來</span><span class="w"></span><span class="nb">int</span><span class="w"></span><span class="n">原因</span><span class="w"></span><span class="n">溢出</span><span class="w"></span></pre> </div> </div> </div> <div class="section" id="type-coercion"> <h2>強製類型轉換<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#type-coercion" title=""></a></h2> <div class="section" id="type-promotion-and-precedence"> <h3>促銷類型和優先級<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#type-promotion-and-precedence" title=""></a></h3> <p>當<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>被設置為<code class="docutils literal notranslate"><span class="pre">真正的</span></code>,火花SQL使用幾個規則管理數據類型之間的衝突如何解決。這個衝突解決的核心類型優先級列表定義是否一個給定的數據類型的值可以被提升到另一個數據類型隱式。</p> <table class="docutils align-default"> <colgroup> <col style="width: 13%"> <col style="width: 87%"> </colgroup> <thead> <tr class="row-odd"> <th class="head"><p>數據類型</p></th> <th class="head"><p>優先級列表(從窄到寬)</p></th> </tr> </thead> <tbody> <tr class="row-even"> <td><p>字節</p></td> <td><p>字節Int - >短- > - > - >長十進製- > * - >雙浮動</p></td> </tr> <tr class="row-odd"> <td><p>短</p></td> <td><p>短Int - > - > - >長十進製- > * - >雙浮動</p></td> </tr> <tr class="row-even"> <td><p>Int</p></td> <td><p>Int - > - >長十進製- > * - >雙浮動</p></td> </tr> <tr class="row-odd"> <td><p>長</p></td> <td><p>長- >十進製- > * - >雙浮動</p></td> </tr> <tr class="row-even"> <td><p>小數</p></td> <td><p>十進製- > * - >雙浮動</p></td> </tr> <tr class="row-odd"> <td><p>浮動</p></td> <td><p>浮- >雙</p></td> </tr> <tr class="row-even"> <td><p>雙</p></td> <td><p>雙</p></td> </tr> <tr class="row-odd"> <td><p>日期</p></td> <td><p>- >日期時間戳</p></td> </tr> <tr class="row-even"> <td><p>時間戳</p></td> <td><p>時間戳</p></td> </tr> <tr class="row-odd"> <td><p>字符串</p></td> <td><p>字符串</p></td> </tr> <tr class="row-even"> <td><p>二進製</p></td> <td><p>二進製</p></td> </tr> <tr class="row-odd"> <td><p>布爾</p></td> <td><p>布爾</p></td> </tr> <tr class="row-even"> <td><p>時間間隔</p></td> <td><p>時間間隔</p></td> </tr> <tr class="row-odd"> <td><p>地圖</p></td> <td><p>圖* *</p></td> </tr> <tr class="row-even"> <td><p>數組</p></td> <td><p>數組* *</p></td> </tr> <tr class="row-odd"> <td><p>結構體</p></td> <td><p>結構體* *</p></td> </tr> </tbody> </table> <p>*最常見解決浮動跳過避免精度的損失。</p> <p>* *一個複雜類型,優先規則遞歸地適用於它的組成元素。</p> <p>特殊規則申請字符串類型和無類型為空。空可以晉升為其他類型,雖然一個字符串可以推廣到任何簡單數據類型。</p> <p>這是一個圖形化描述的優先級列表作為指導樹:<我mg alt="優先規則的圖形表示形式" src="//www.eheci.com/docs.gcp/docs.gcp/_images/data-type-precedence.png"></p> </div> <div class="section" id="least-common-type-resolution"> <h3>最常見的決議<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#least-common-type-resolution" title=""></a></h3> <p>最常見的類型是最窄的類型可以從優先級列表的所有元素的集合類型。</p> <p>最常見的決議是用來:</p> <ul class="simple"> <li><p>決定是否期望函數的參數類型可以使用一個窄的類型的參數調用。</p></li> <li><p>推導出函數的參數類型,期望一個共享的參數類型為多個參數,如合並、最小或最大。</p></li> <li><p>推導出操作數類型運營商如算術運算或比較。</p></li> <li><p>獲得結果的類型等表情表達的情況。</p></li> <li><p>推導出元素、鍵或值類型數組和地圖構造函數。</p></li> </ul> <p>特殊規則應用如果最常見解決浮動。浮子式的值,如果任何類型是INT,長整型數字或十進製最常見的類型是推到避免潛在損失數字的兩倍。</p> <div class="highlight-sql notranslate"> <div class="highlight"> <pre><span></span><span class="c1">——合並函數接受任意設定的參數類型,隻要他們共享一個最常見的類型。</span><span class="c1">——結果類型是最常見的一種參數。</span><span class="o">></span><span class="w"></span><span class="k">集</span><span class="w"></span><span class="n">火花</span><span class="p">。</span><span class="k">sql</span><span class="p">。</span><span class="n">ansi</span><span class="p">。</span><span class="n">啟用</span><span class="o">=</span><span class="k">真正的</span><span class="p">;</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="n">typeof</span><span class="p">(</span><span class="k">合並</span><span class="p">(</span><span class="mi">1</span><span class="n">Y</span><span class="p">,</span><span class="w"></span><span class="mi">1</span><span class="n">l</span><span class="p">,</span><span class="w"></span><span class="k">零</span><span class="p">));</span><span class="w"></span><span class="nb">長整型數字</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="n">typeof</span><span class="p">(</span><span class="k">合並</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"></span><span class="nb">日期</span><span class="s1">“2020-01-01”</span><span class="p">));</span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">不兼容的</span><span class="w"></span><span class="n">類型</span><span class="w"></span><span class="p">(</span><span class="nb">INT</span><span class="p">,</span><span class="w"></span><span class="nb">日期</span><span class="p">]</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="n">typeof</span><span class="p">(</span><span class="k">合並</span><span class="p">(</span><span class="nb">數組</span><span class="p">(</span><span class="mi">1</span><span class="n">Y</span><span class="p">),</span><span class="w"></span><span class="nb">數組</span><span class="p">(</span><span class="mi">1</span><span class="n">l</span><span class="p">)));</span><span class="w"></span><span class="nb">數組</span><span class="o"><</span><span class="nb">長整型數字</span><span class="o">></span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="n">typeof</span><span class="p">(</span><span class="k">合並</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"></span><span class="mi">1</span><span class="n">F</span><span class="p">));</span><span class="w"></span><span class="n">雙</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="n">typeof</span><span class="p">(</span><span class="k">合並</span><span class="p">(</span><span class="mi">1</span><span class="n">l</span><span class="p">,</span><span class="w"></span><span class="mi">1</span><span class="n">F</span><span class="p">));</span><span class="w"></span><span class="n">雙</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="p">(</span><span class="n">typeof</span><span class="p">(</span><span class="k">合並</span><span class="p">(</span><span class="mi">1</span><span class="n">雙相障礙</span><span class="p">,</span><span class="w"></span><span class="mi">1</span><span class="n">F</span><span class="p">)));</span><span class="w"></span><span class="n">雙</span><span class="w"></span><span class="c1">——substring函數預計開始的整型參數和長度參數。</span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">子字符串</span><span class="p">(</span><span class="s1">“你好”</span><span class="p">,</span><span class="w"></span><span class="mi">1</span><span class="n">Y</span><span class="p">,</span><span class="w"></span><span class="mi">2</span><span class="p">);</span><span class="w"></span><span class="n">他</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">子字符串</span><span class="p">(</span><span class="s1">“你好”</span><span class="p">,</span><span class="w"></span><span class="s1">' 1 '</span><span class="p">,</span><span class="w"></span><span class="mi">2</span><span class="p">);</span><span class="w"></span><span class="n">他</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">子字符串</span><span class="p">(</span><span class="s1">“你好”</span><span class="p">,</span><span class="w"></span><span class="mi">1</span><span class="n">l</span><span class="p">,</span><span class="w"></span><span class="mi">2</span><span class="p">);</span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">論點</span><span class="w"></span><span class="mi">2</span><span class="w"></span><span class="n">需要</span><span class="w"></span><span class="n">一個</span><span class="w"></span><span class="nb">INT</span><span class="w"></span><span class="k">類型</span><span class="p">。</span><span class="w"></span><span class="o">></span><span class="w"></span><span class="k">選擇</span><span class="w"></span><span class="k">子字符串</span><span class="p">(</span><span class="s1">“你好”</span><span class="p">,</span><span class="w"></span><span class="n">str</span><span class="p">,</span><span class="w"></span><span class="mi">2</span><span class="p">)</span><span class="w"></span><span class="k">從</span><span class="w"></span><span class="k">值</span><span class="p">(</span><span class="k">投</span><span class="p">(</span><span class="s1">' 1 '</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="n">字符串</span><span class="p">))</span><span class="w"></span><span class="k">作為</span><span class="w"></span><span class="n">T</span><span class="p">(</span><span class="n">str</span><span class="p">);</span><span class="w"></span><span class="n">錯誤</span><span class="p">:</span><span class="w"></span><span class="n">論點</span><span class="w"></span><span class="mi">2</span><span class="w"></span><span class="n">需要</span><span class="w"></span><span class="n">一個</span><span class="w"></span><span class="nb">INT</span><span class="w"></span><span class="k">類型</span><span class="p">。</span><span class="w"></span></pre> </div> </div> </div> </div> <div class="section" id="sql-functions"> <h2>SQL函數<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#sql-functions" title=""></a></h2> <p>一些SQL函數可以是不同的行為在ANSI模式(<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled = true</span></code>)。</p> <ul class="simple"> <li><p><code class="docutils literal notranslate"><span class="pre">大小</span></code>:這個函數返回null ANSI下的零輸入模式。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">element_at</span></code>:</p> <ul> <li><p>這個函數拋出<code class="docutils literal notranslate"><span class="pre">ArrayIndexOutOfBoundsException</span></code>如果使用無效的指標。</p></li> <li><p>這個函數拋出<code class="docutils literal notranslate"><span class="pre">NoSuchElementException</span></code>如果映射的關鍵是不存在的。</p></li> </ul></li> <li><p><code class="docutils literal notranslate"><span class="pre">英語教學</span></code>:這個函數拋出<code class="docutils literal notranslate"><span class="pre">ArrayIndexOutOfBoundsException</span></code>如果使用無效的指標。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">make_date</span></code>:這個函數失敗,如果結果異常日期是無效的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">make_timestamp</span></code>:這個函數失敗,如果結果異常的時間戳是無效的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">make_interval</span></code>:這個函數失敗,如果結果異常間隔是無效的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">next_day</span></code>:這個函數拋出<code class="docutils literal notranslate"><span class="pre">IllegalArgumentException</span></code>如果沒有一個有效的輸入的一天。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">parse_url</span></code>:這個函數拋出<code class="docutils literal notranslate"><span class="pre">IllegalArgumentException</span></code>如果一個輸入字符串不是一個有效的url。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">to_date</span></code>與一個例外:這個函數失敗如果輸入字符串不能解析,或模式字符串是無效的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">to_timestamp</span></code>與一個例外:這個函數失敗如果輸入字符串不能解析,或模式字符串是無效的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">to_unix_timestamp</span></code>與一個例外:這個函數失敗如果輸入字符串不能解析,或模式字符串是無效的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">unix_timestamp</span></code>與一個例外:這個函數失敗如果輸入字符串不能解析,或模式字符串是無效的。</p></li> </ul> </div> <div class="section" id="sql-operators"> <h2>SQL操作符<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#sql-operators" title=""></a></h2> <p>一些SQL操作符可以是不同的行為在ANSI模式(<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled = true</span></code>)。</p> <ul class="simple"> <li><p><code class="docutils literal notranslate"><span class="pre">array_col(指數)</span></code>:這個操作符扔<code class="docutils literal notranslate"><span class="pre">ArrayIndexOutOfBoundsException</span></code>如果使用無效的指標。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">map_col(例子)</span></code>:這個操作符扔<code class="docutils literal notranslate"><span class="pre">NoSuchElementException</span></code>如果映射的關鍵是不存在的。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">鑄造(string_col</span><span class="pre">作為</span><span class="pre">時間戳)</span></code>與一個例外:該操作失敗如果輸入字符串不能被解析。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">鑄造(string_col</span><span class="pre">作為</span><span class="pre">日期)</span></code>與一個例外:該操作失敗如果輸入字符串不能被解析。</p></li> </ul> </div> <div class="section" id="useful-functions-for-ansi-mode"> <h2>ANSI模式的有用功能<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#useful-functions-for-ansi-mode" title=""></a></h2> <p>當ANSI模式,它為無效的操作就會拋出異常。您可以使用以下SQL函數抑製這樣的例外。</p> <ul class="simple"> <li><p><code class="docutils literal notranslate"><span class="pre">try_cast</span></code>:相同<code class="docutils literal notranslate"><span class="pre">投</span></code>,除了它的回報<code class="docutils literal notranslate"><span class="pre">零</span></code>在運行時錯誤結果而不是拋出異常。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">try_add</span></code>:添加操作符相同<code class="docutils literal notranslate"><span class="pre">+</span></code>,除了它的回報<code class="docutils literal notranslate"><span class="pre">零</span></code>結果,而不是拋出異常積分價值溢出。</p></li> <li><p><code class="docutils literal notranslate"><span class="pre">try_divide</span></code>:除法操作符相同<code class="docutils literal notranslate"><span class="pre">/</span></code>,除了它的回報<code class="docutils literal notranslate"><span class="pre">零</span></code>結果分0而不是拋出異常。</p></li> </ul> </div> <div class="section" id="sql-keywords"> <h2>SQL關鍵字<一個class="headerlink" href="//www.eheci.com/docs.gcp/sql/language-manual/#sql-keywords" title=""></a></h2> <p>當<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>是真的,火花SQL解析器將使用ANSI模式。在這種模式下,火花SQL關鍵字有兩種:</p> <ul class="simple"> <li><p>保留關鍵字:關鍵字保留,不能用作標識符表,視圖,列,函數,別名等。</p></li> <li><p>要預訂關鍵詞:關鍵詞有特殊意義的隻有在特定的情況下,可以使用在其他上下文作為標識符。例如,<code class="docutils literal notranslate"><span class="pre">解釋</span><span class="pre">選擇</span><span class="pre">…</span></code>是一個命令,但是解釋可以用作標識符在其他地方。</p></li> </ul> <p>當ANSI模式被禁用,火花SQL關鍵字有兩種:</p> <ul class="simple"> <li><p>一樣要預訂關鍵詞:定義一個當ANSI模式啟用。</p></li> <li><p>Strict-non-reserved關鍵詞:嚴格的版本要預訂關鍵詞,不能用作表別名。</p></li> </ul> <p>默認情況下<code class="docutils literal notranslate"><span class="pre">spark.sql.ansi.enabled</span></code>是假的。</p> <p>下麵是一個列表的所有關鍵詞在火花SQL。</p> <table class="docutils align-default"> <colgroup> <col style="width: 22%"> <col style="width: 29%"> <col style="width: 33%"> <col style="width: 16%"> </colgroup> <thead> <tr class="row-odd"> <th class="head"><p>關鍵字</p></th> <th class="head"><p>火花< br / > ANSI SQL模式</p></th> <th class="head"><p>火花SQL < br / >默認模式</p></th> <th class="head"><p>sql - 2016</p></th> </tr> </thead> <tbody> <tr class="row-even"> <td><p>添加</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>後</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>所有</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>改變</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>總是</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>分析</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>和</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>反</p></td> <td><p>要預訂</p></td> <td><p>strict-non-reserved</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>任何</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>存檔</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>數組</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>作為</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>ASC</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>在</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>授權</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>之間的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>這兩個</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>桶</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>桶</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>通過</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>緩存</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>級聯</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>情況下</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>投</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>改變</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>檢查</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>清晰的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>集群</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>集群</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>CODEGEN</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>核對</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>集合</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>列</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>列</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>評論</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>提交</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>緊湊的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>件</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>計算</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>連接</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>約束</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>成本</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>創建</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>交叉</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>多維數據集</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>當前的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>當前日期</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>當前時間</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>CURRENT_TIMESTAMP</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>CURRENT_USER</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>數據</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>數據庫</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>數據庫</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>一天</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>DBPROPERTIES</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>定義</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>刪除</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>分隔</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>DESC</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>描述</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>DFS</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>目錄</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>目錄</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>截然不同的</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>分發</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>DIV</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>不是一個字</p></td> </tr> <tr class="row-even"> <td><p>下降</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>其他的</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>結束</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>逃避</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>逃了出來</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>除了</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>交換</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>存在</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>解釋</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>出口</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>擴展</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>外部</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>提取</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>假</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>獲取</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>字段</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>過濾器</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>FILEFORMAT</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>第一個</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>FN</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>後</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>為</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>外國</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>格式</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>格式化</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>從</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>完整的</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>函數</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>功能</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>生成的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>全球</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>格蘭特</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>獎助金</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>集團</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>分組</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>有</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>小時</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>如果</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>不是一個字</p></td> </tr> <tr class="row-even"> <td><p>忽略</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>進口</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>在</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>指數</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>索引</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>內心的</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>INPATH</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>INPUTFORMAT</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>插入</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>相交</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>時間間隔</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>成</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>是</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>項目</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>加入</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>關鍵</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>鍵</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>去年</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>橫向</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>懶惰的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>領先的</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>左</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>就像</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>我喜歡</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>限製</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>行</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>列表</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>負載</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>當地的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>位置</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>鎖</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>鎖</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>邏輯</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>宏</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>地圖</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>匹配</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>合並</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>一分鍾</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>-</p></td> <td><p>要預訂</p></td> <td><p>strict-non-reserved</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>月</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>MSCK</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>名稱空間</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>名稱空間</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>自然</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>沒有</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>不</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>零</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>零位</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>在</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>隻有</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>選項</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>選項</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>或</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>訂單</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>出</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>外</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>OUTPUTFORMAT</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>在</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>重疊</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>覆蓋</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>覆蓋</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>分區</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>分區</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>分區</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>百分比</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>主</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>放置</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>位置</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>前</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>主</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>校長</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>屬性</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>清洗</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>有資格</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>查詢</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>範圍</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>收件人</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>收件人</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>RECORDREADER</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>RECORDWRITER</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>恢複</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>減少</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>引用</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>刷新</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>正則表達式</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>不是一個字</p></td> </tr> <tr class="row-even"> <td><p>刪除</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>重命名</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>修複</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>取代</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>重置</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>尊重</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>限製</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>撤銷</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>正確的</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>RLIKE</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>角色</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>角色</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>回滾</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>彙總</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>行</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>行</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>模式</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>模式</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>不是一個字</p></td> </tr> <tr class="row-even"> <td><p>第二個</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>選擇</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>半</p></td> <td><p>要預訂</p></td> <td><p>strict-non-reserved</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>分離</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>SERDE</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>SERDEPROPERTIES</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>為SESSION_USER</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>集</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>集</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>分享</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>股票</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>顯示</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>傾斜</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>一些</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>排序</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>排序</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>開始</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>統計數據</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>存儲</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>分層</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>結構體</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>字符串的子串</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>子字符串</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>同步</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>表</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>表</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>TABLESAMPLE</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>TBLPROPERTIES</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>臨時</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>不是一個字</p></td> </tr> <tr class="row-odd"> <td><p>臨時</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>終止</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>然後</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>時間</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>來</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>觸摸</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>落後於</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>事務</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>交易</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>變換</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>修剪</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>真正的</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>截斷</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>TRY_CAST</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>類型</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>UNARCHIVE</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>無限</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>UNCACHE</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>聯盟</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>獨特的</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>未知的</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>解鎖</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>設置</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>更新</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>使用</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>用戶</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>使用</p></td> <td><p>保留</p></td> <td><p>strict-non-reserved</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>值</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>視圖</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>的觀點</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-odd"> <td><p>當</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>在哪裏</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>窗口</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-even"> <td><p>與</p></td> <td><p>保留</p></td> <td><p>要預訂</p></td> <td><p>保留</p></td> </tr> <tr class="row-odd"> <td><p>一年</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> <tr class="row-even"> <td><p>區</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> <td><p>要預訂</p></td> </tr> </tbody> </table> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> <p></p> </div> </div> </div> </div> <div class="suapp-rating"> <div id="suPageRateApp"> <su-app></su-app> </div> </div> <hr> <footer> <div role="contentinfo"> <p class="copyright">©2023磚。保留所有權利。Apache, Apache火花,火花,火花標誌的商標<一個href="http://www.apache.org/">Apache軟件基金會</一個>。</p> <p><a id="feedbacklink" href="mailto:doc-feedback@www.eheci.com?subject=Documentation Feedback">給我們反饋</一個>|<一個href="//www.eheci.com/docs.gcp/privacy-policy">隱私政策</一個>|<一個href="//www.eheci.com/docs.gcp/terms-of-use">使用條款</一個></p> </div> </footer> </div> </div> </section> </main> </page>  <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet">  <div style="text-align:center;margin-bottom:5px;"><form action="http://www.baidu.com/baidu" target="_blank"><div bgcolor="#FFFFFF" style="text-align:center;"><input name="tn" type="hidden" value="baidu"><a href="http://www.baidu.com/"><img src="http://img.baidu.com/img/logo-80px.gif" width="80px" height="29px" alt="Baidu" align="bottom" border="0"></a><input type="text" name="word" size="30" placeholder="" value=""><input type="submit" value="baidu"></div></form></div><div id="so360" style="text-align:center;margin-bottom:5px;"><form action="https://www.so.com/" target="_blank" id="so360form"><img src="http://p1.qhimg.com/d/_onebox/search.png" width="100px" height="25px"> <input type="text" autocomplete="off" name="q" id="so360_keyword" placeholder="" value=""> <input type="submit" id="so360_submit" value="360"> <input type="hidden" name="ie" value="gbk"><input type="hidden" name="src" value="zz"> <input type="hidden" name="site" value="so.com"> <input type="hidden" name="rg" value="1"></form></div><div id="sogou" style="text-align:center;margin-bottom:5px;"><form action="https://www.sogou.com/" target="_blank" id="so360form"><img src="https://www.sogou.com/web/index/images/logo_440x140.v.4.png" width="100px" height="25px"> <input type="text" autocomplete="off" name="q" id="sogou.com_keyword" placeholder="" value=""> <input type="submit" id="sogou_submit" value="sougou"> <input type="hidden" name="ie" value="gbk"><input type="hidden" name="src" value="zz"> <input type="hidden" name="site" value="so.com"> <input type="hidden" name="rg" value="1"></form></div><div align="center"><a target="_blank" href="/sitemap.xml">map</a></div></body> </html>