yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
sgode-patch-2
doc-exports/docs/dws/dev/dws_06_0366.html
luhuayi 177cd61a57 DWS DEVG 910.211 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: luhuayi <luhuayi@huawei.com>
Co-committed-by: luhuayi <luhuayi@huawei.com>
2025-05-05 07:44:03 +00:00

56 lines
9.3 KiB
HTML
Raw Permalink Blame History

<a name="EN-US_TOPIC_0000001811515457"></a><a name="EN-US_TOPIC_0000001811515457"></a>
<h1 class="topictitle1">ALTER EXTERNAL SCHEMA</h1>
<div id="body0000001675049857"><div class="section" id="EN-US_TOPIC_0000001811515457__s628a72e4ad6147cf9cc089febf125678"><h4 class="sectiontitle">Function</h4><p id="EN-US_TOPIC_0000001811515457__en-us_topic_0059777945_p549110246542">Modifies EXTERNAL SCHEMA. This syntax is supported only in 8.3.0 and later versions.</p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811515457__s6d289579f18149c1a17ec06712dde98a"><h4 class="sectiontitle">Syntax</h4><ul id="EN-US_TOPIC_0000001811515457__ueb686891603d403480637aa0cf189f2c"><li id="EN-US_TOPIC_0000001811515457__la0976fa1070d4c8b9088a4ed573350f2">Modifies an external schema based on the specified name.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811515457__sa863f654e9d44d4f9bbc808b7ee28222"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span>
<span class="normal">6</span>
<span class="normal">7</span>
<span class="normal">8</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">ALTER</span><span class="w"> </span><span class="k">EXTERNAL</span><span class="w"> </span><span class="k">SCHEMA</span><span class="w"> </span><span class="k">schema_name</span><span class="w"> </span>
<span class="w"> </span><span class="k">WITH</span><span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="k">SOURCE</span><span class="w"> </span><span class="n">source_name</span><span class="w"> </span><span class="p">]</span>
<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="k">DATABASE</span><span class="w"> </span><span class="s1">'database_name'</span><span class="w"> </span><span class="p">]</span>
<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="n">SERVER</span><span class="w"> </span><span class="k">server_name</span><span class="w"> </span><span class="p">]</span>
<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="k">CATALOG</span><span class="w"> </span><span class="s1">'catalog_name'</span><span class="w"> </span><span class="p">]</span>
<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="k">OPTIONS</span><span class="w"> </span><span class="p">(</span><span class="w"> </span><span class="err">{</span><span class="w"> </span><span class="n">option_name</span><span class="w"> </span><span class="s1">' value '</span><span class="w"> </span><span class="err">}</span><span class="w"> </span><span class="p">[,</span><span class="w"> </span><span class="p">...]</span><span class="w"> </span><span class="p">)</span><span class="w"> </span><span class="p">]</span>
<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="n">METAADDRESS</span><span class="w"> </span><span class="s1">'address'</span><span class="p">]</span>
<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="n">CONFIGURATION</span><span class="w"> </span><span class="s1">'confpath'</span><span class="p">];</span>
</pre></div></td></tr></table></div>
</div>
</li></ul>
</div>
<div class="section" id="EN-US_TOPIC_0000001811515457__s137c7d80e527499da3008e35aa5115aa"><h4 class="sectiontitle">Parameter Description</h4><ul id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_ub308d7ce1ea94a509a9fa185772ce356"><li id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_lf6df67d8504e48428af0f53cf4ced03f"><strong id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_af0784a43101c4e78b5083c98d58a40c0">schema_name</strong><p id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_a2115acd4630e42e78f9032aef52c2541">Name of the external schema to be modified.</p>
</li><li id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_l4676a2dbfd484819858b12ad8e546b30"><strong id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_b163911791511">SOURCE</strong><p id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_a724c2de5a7b34ea384d2b497c9ad0bd7">Type of the external metadata storage engine. Currently, <strong id="EN-US_TOPIC_0000001811515457__b1155875014213">source_type</strong> can only be <strong id="EN-US_TOPIC_0000001811515457__b1955885018211">dli</strong>, <strong id="EN-US_TOPIC_0000001811515457__b65587507216">lakeformation</strong>, or <strong id="EN-US_TOPIC_0000001811515457__b195585509210">hive</strong>.</p>
</li><li id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_li1566194263915"><strong id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_b16156192815214">DATABASE</strong><p id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_p36612424397">Database corresponding to the external schema.</p>
</li><li id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_lc1d779f3255e4b9cb81d8d0f7b549d7a"><strong id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_b164835227572">SERVER</strong><p id="EN-US_TOPIC_0000001811515457__a31a7e8559d684565ad276e5c3ef84714">Value range: an existing foreign server whose type is <strong id="EN-US_TOPIC_0000001811515457__b471510210720">lf</strong>, <strong id="EN-US_TOPIC_0000001811515457__b37153211375">dli</strong>, <strong id="EN-US_TOPIC_0000001811515457__b1571532110718">obs</strong>, or <strong id="EN-US_TOPIC_0000001811515457__b10715172118713">hdfs</strong>.</p>
<p id="EN-US_TOPIC_0000001811515457__p1062844012312">You can associate an external schema with a foreign server to access external data.</p>
</li><li id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_li3810949135815"><strong id="EN-US_TOPIC_0000001811515457__b131481511184515">CATALOG</strong><p id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_p184236126595">Catalog to be accessed in LakeFormation.</p>
</li><li id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_li112525405595"><strong id="EN-US_TOPIC_0000001811515457__b1170693616217">OPTIONS</strong><p id="EN-US_TOPIC_0000001811515457__a9a2e0b7ef7ee45d2b5b0ca470b8bdc5c">Foreign table parameters. This function is supported only by 8.3.0 and later versions.</p>
<p id="EN-US_TOPIC_0000001811515457__p5210417113614"><strong id="EN-US_TOPIC_0000001811515457__b1554291514499">dli_project_id</strong></p>
<p id="EN-US_TOPIC_0000001811515457__p117611527133510">Specifies the project ID corresponding to DLI. You can obtain the project ID from the management console. This parameter is available only when the server type is DLI.</p>
</li><li id="EN-US_TOPIC_0000001811515457__li4389121884519"><strong id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_b574336593">METAADDRESS</strong><p id="EN-US_TOPIC_0000001811515457__p1433330134512">Hivemetastore communication interface. This parameter is supported only by 9.1.0 and later versions.</p>
</li><li id="EN-US_TOPIC_0000001811515457__li13993193918454"><strong id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_b12905656115913">CONFIGURATION</strong><p id="EN-US_TOPIC_0000001811515457__p19573842114514">Path for storing <strong id="EN-US_TOPIC_0000001811515457__b4467162861014">hivemetastore</strong> configuration files. This parameter is supported only by 9.1.0 and later versions.</p>
</li></ul>
<div class="note" id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_n9a9767ebd2724611b35932b1d8cf3ef5"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000001811515457__en-us_topic_0000001469947666_af946322ebcb441e8a11af77cc9fd97ee">If objects in the schema on the current search path are with the same name, specify the schemas different objects are in. You can run the <strong id="EN-US_TOPIC_0000001811515457__b149647787103842">SHOW SEARCH_PATH</strong> command to check the schemas on the current search path.</p>
</div></div>
</div>
<div class="section" id="EN-US_TOPIC_0000001811515457__s5bf3a4d02e2d4bea92404b3442f9ffb8"><h4 class="sectiontitle">Examples</h4><p id="EN-US_TOPIC_0000001811515457__p11557194441316">Modify the database and FOREIGN SERVER corresponding to ex1.</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811515457__screen10557114414133"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">ALTER</span><span class="w"> </span><span class="k">EXTERNAL</span><span class="w"> </span><span class="k">SCHEMA</span><span class="w"> </span><span class="n">ex1</span>
<span class="w"> </span><span class="k">WITH</span><span class="w"> </span><span class="k">DATABASE</span><span class="w"> </span><span class="s1">'demo'</span>
<span class="w"> </span><span class="n">SERVER</span><span class="w"> </span><span class="n">my_server</span><span class="p">;</span>
</pre></div></td></tr></table></div>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_06_0118.html">DDL Syntax</a></div>
</div>
</div>
View Git Blame Copy Permalink