forked from docs/doc-exports
chenxiaoxiong
f9e2808b7c
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: chenxiaoxiong <chenxiaoxiong@huawei.com> Co-committed-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
210 lines
28 KiB
HTML
210 lines
28 KiB
HTML
<a name="dataartsstudio_01_0528"></a><a name="dataartsstudio_01_0528"></a>
|
|
|
|
<h1 class="topictitle1">MRS ClickHouse</h1>
|
|
<div id="body0000001257757473"><div class="section" id="dataartsstudio_01_0528__en-us_topic_0101095437_section44280035173841"><h4 class="sectiontitle">Functions</h4><p id="dataartsstudio_01_0528__p1350781093119">The MRS ClickHouse <span id="dataartsstudio_01_0528__text13380176175713">node</span> is used to execute the ClickHouse SQL script predefined in DataArts Factory.</p>
|
|
</div>
|
|
<div class="section" id="dataartsstudio_01_0528__en-us_topic_0101095437_section1791764173933"><h4 class="sectiontitle">Parameters</h4><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p49252448103256"><a href="#dataartsstudio_01_0528__en-us_topic_0101095437_table3764823994826">Table 1</a>, <a href="#dataartsstudio_01_0528__en-us_topic_0101095437_table58040457102411">Table 2</a>, and <a href="#dataartsstudio_01_0528__en-us_topic_0114569494_table987664914213">Table 3</a> describe the parameters of the MRS ClickHouse <span id="dataartsstudio_01_0528__en-us_topic_0101095437_text47744836161657">node</span>.</p>
|
|
|
|
<div class="tablenoborder"><a name="dataartsstudio_01_0528__en-us_topic_0101095437_table3764823994826"></a><a name="en-us_topic_0101095437_table3764823994826"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0528__en-us_topic_0101095437_table3764823994826" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Parameters of MRS ClickHouse nodes</caption><thead align="left"><tr id="dataartsstudio_01_0528__en-us_topic_0101095437_row3170822394826"><th align="left" class="cellrowborder" valign="top" width="21.740000000000002%" id="mcps1.3.2.3.2.4.1.1"><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p2984581994826">Parameter</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="10.16%" id="mcps1.3.2.3.2.4.1.2"><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p159227094826">Mandatory</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="68.10000000000001%" id="mcps1.3.2.3.2.4.1.3"><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p6186505494826">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dataartsstudio_01_0528__en-us_topic_0101095437_row1991457694826"><td class="cellrowborder" valign="top" width="21.740000000000002%" headers="mcps1.3.2.3.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p246794194826">Node Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="10.16%" headers="mcps1.3.2.3.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p6568554794826">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="68.10000000000001%" headers="mcps1.3.2.3.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p1892909794826">Name of a <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text44323307153939">node</span>. The name must contain 1 to 128 characters, including only letters, numbers, underscores (_), hyphens (-), slashes (/), less-than signs (<), and greater-than signs (>).</p>
|
|
<p id="dataartsstudio_01_0528__p1413675131714">By default, the node name is the same as that of the selected script. If you want the node name to be different from the script name, disable this function by referring to <a href="dataartsstudio_01_04501.html#dataartsstudio_01_04501__section67661828112219">Disabling Auto Node Name Change</a>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__row1031253894920"><td class="cellrowborder" valign="top" width="21.740000000000002%" headers="mcps1.3.2.3.2.4.1.1 "><p id="dataartsstudio_01_0528__p123121638174917">SQL Script</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="10.16%" headers="mcps1.3.2.3.2.4.1.2 "><p id="dataartsstudio_01_0528__p1231233816499">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="68.10000000000001%" headers="mcps1.3.2.3.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0101095440_p154146861116">Path of a script to be executed. If no script is available, create and develop a script by referring to <a href="dataartsstudio_01_0423.html">Creating a Script</a> and <a href="dataartsstudio_01_0424.html">Developing an SQL Script</a>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__row15891616161411"><td class="cellrowborder" valign="top" width="21.740000000000002%" headers="mcps1.3.2.3.2.4.1.1 "><p id="dataartsstudio_01_0528__p18589111691412">Script Parameter</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="10.16%" headers="mcps1.3.2.3.2.4.1.2 "><p id="dataartsstudio_01_0528__p9589141616144">No</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="68.10000000000001%" headers="mcps1.3.2.3.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0102588983_p43817359613">If the associated SQL script uses a parameter, the parameter name is displayed. Set the parameter value in the text box next to the parameter name. The parameter value can be an <a href="dataartsstudio_01_0494.html">EL expression</a>.</p>
|
|
<p id="dataartsstudio_01_0528__en-us_topic_0102588983_p12736811975">If the parameters of the associated SQL script are changed, click <span><img id="dataartsstudio_01_0528__en-us_topic_0102588983_image83361028443" src="en-us_image_0000002269119309.png"></span> to refresh the parameters.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__row114243579509"><td class="cellrowborder" valign="top" width="21.740000000000002%" headers="mcps1.3.2.3.2.4.1.1 "><p id="dataartsstudio_01_0528__p16424557165018">Data Connection</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="10.16%" headers="mcps1.3.2.3.2.4.1.2 "><p id="dataartsstudio_01_0528__p154241257105015">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="68.10000000000001%" headers="mcps1.3.2.3.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0101095440_p20781413102414">Data connection that is configured in the SQL script. The value can be changed.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__row128123514"><td class="cellrowborder" valign="top" width="21.740000000000002%" headers="mcps1.3.2.3.2.4.1.1 "><p id="dataartsstudio_01_0528__p928182155117">Database</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="10.16%" headers="mcps1.3.2.3.2.4.1.2 "><p id="dataartsstudio_01_0528__p32812155115">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="68.10000000000001%" headers="mcps1.3.2.3.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0101095440_p7610111714256">Database that is configured in the SQL script. The value can be changed.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0101095437_row838395916445"><td class="cellrowborder" valign="top" width="21.740000000000002%" headers="mcps1.3.2.3.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p14384185924410">Program Parameter</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="10.16%" headers="mcps1.3.2.3.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p2038416595446">No</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="68.10000000000001%" headers="mcps1.3.2.3.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p33849599443">Used to configure optimization parameters such as threads, memory, and vCPUs for the job to optimize resource usage and improve job execution performance.</p>
|
|
<div class="note" id="dataartsstudio_01_0528__en-us_topic_0101095437_note2073561518462"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="dataartsstudio_01_0528__en-us_topic_0101095437_p1226422124616">This parameter is mandatory if the cluster version is MRS 1.8.7 or later than MRS 2.0.1.</p>
|
|
</div></div>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
<div class="tablenoborder"><a name="dataartsstudio_01_0528__en-us_topic_0101095437_table58040457102411"></a><a name="en-us_topic_0101095437_table58040457102411"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0528__en-us_topic_0101095437_table58040457102411" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Advanced parameters</caption><thead align="left"><tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row27216578102411"><th align="left" class="cellrowborder" valign="top" width="28.07%" id="mcps1.3.2.4.2.4.1.1"><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p57059205102411">Parameter</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="15.659999999999998%" id="mcps1.3.2.4.2.4.1.2"><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p58392901102411">Mandatory</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="56.269999999999996%" id="mcps1.3.2.4.2.4.1.3"><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p32204521102411">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row51612113175"><td class="cellrowborder" valign="top" width="28.07%" headers="mcps1.3.2.4.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p416115112178">Node Status Polling Interval (s)</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.659999999999998%" headers="mcps1.3.2.4.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p101615110176">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.269999999999996%" headers="mcps1.3.2.4.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p4161191101716">How often the system check completeness of the <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text1526241235118">node</span>. The value ranges from 1 to 60 seconds.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row5101045193916"><td class="cellrowborder" valign="top" width="28.07%" headers="mcps1.3.2.4.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p147314419397">Max. Node Execution Duration</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.659999999999998%" headers="mcps1.3.2.4.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p610124511390">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.269999999999996%" headers="mcps1.3.2.4.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p11011456393">Execution timeout interval for the <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text6930195917115">node</span>. If retry is configured and the execution is not complete within the timeout interval, the <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text2930205914118">node</span> will be executed again.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row58429402102411"><td class="cellrowborder" valign="top" width="28.07%" headers="mcps1.3.2.4.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p5533912102858">Retry upon Failure</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.659999999999998%" headers="mcps1.3.2.4.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p45593742102858">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.269999999999996%" headers="mcps1.3.2.4.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p2105628102858">Whether to re-execute a <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text29185571161243">node</span> if it fails to be executed. Possible values:</p>
|
|
<ul id="dataartsstudio_01_0528__en-us_topic_0099822521_ul18950660102858"><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li36338219102858"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b67992121590">Yes</strong>: The <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text19139245161248">node</span> will be re-executed, and the following parameters must be configured:<ul id="dataartsstudio_01_0528__en-us_topic_0099822521_ul58608523102858"><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li17370115484319"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b18610151101714">Retry upon Timeout</strong></li><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li44375787102858"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b18404183512913">Maximum Retries</strong></li><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li63837764102858"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b1484216373917">Retry Interval (seconds)</strong></li></ul>
|
|
</li><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li37668971102858"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b0109154414913">No</strong>: The <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text1328324161254">node</span> will not be re-executed. This is the default setting.<div class="note" id="dataartsstudio_01_0528__en-us_topic_0099822521_note845010501289"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p194511050132816">If retry is configured for a job node and the timeout duration is configured, the system allows you to retry a node when the node execution times out.</p>
|
|
<p id="dataartsstudio_01_0528__en-us_topic_0099822521_p1313284812516">If a node is not re-executed when it fails upon timeout, you can go to the <strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b4476194112483">Default Configuration</strong> page to modify this policy.</p>
|
|
<p id="dataartsstudio_01_0528__en-us_topic_0099822521_p15946155074317"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b128994567172">Retry upon Timeout</strong> is displayed only when <strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b7899656131716">Retry upon Failure</strong> is set to <strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b1899155620179">Yes</strong>.</p>
|
|
</div></div>
|
|
</li></ul>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row29541959102411"><td class="cellrowborder" valign="top" width="28.07%" headers="mcps1.3.2.4.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p13154928102858">Policy for Handling Subsequent Nodes If the Current Node Fails</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.659999999999998%" headers="mcps1.3.2.4.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p58916261102858">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.269999999999996%" headers="mcps1.3.2.4.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p7487822102858">Operation that will be performed if the <span id="dataartsstudio_01_0528__en-us_topic_0099822521_text5371194616130">node</span> fails to be executed. Possible values:</p>
|
|
<ul id="dataartsstudio_01_0528__en-us_topic_0099822521_ul281538102858"><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li867222192212"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b63511334183">Suspend execution plans of the subsequent nodes</strong>: stops running subsequent nodes. The job instance status is <strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b635117371819">Failed</strong>.</li><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li2533844102858"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b31833716587">End the current job execution plan</strong>: stops running the current job. The job instance status is <strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b1521193765820">Failed</strong>.</li><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li22804597102858"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b72771223151916">Go to the next node</strong>: ignores the execution failure of the current node. The job instance status is <strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b1727710236199">Failure ignored</strong>.</li><li id="dataartsstudio_01_0528__en-us_topic_0099822521_li1657745411173"><strong id="dataartsstudio_01_0528__en-us_topic_0099822521_b99581526191817">Suspend the current job execution plan</strong>: If the current job instance is in abnormal state, the subsequent nodes of this node and the subsequent job instances that depend on the current job are in waiting state.</li></ul>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row230711409176"><td class="cellrowborder" valign="top" width="28.07%" headers="mcps1.3.2.4.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p143081740131711">Enable Dry Run</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.659999999999998%" headers="mcps1.3.2.4.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p030844011714">No</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.269999999999996%" headers="mcps1.3.2.4.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p19929151141017">If you select this option, the node will not be executed, and a success message will be returned.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0099822521_row116622012182617"><td class="cellrowborder" valign="top" width="28.07%" headers="mcps1.3.2.4.2.4.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p1336551322619">Task Groups</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.659999999999998%" headers="mcps1.3.2.4.2.4.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p7365181320261">No</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.269999999999996%" headers="mcps1.3.2.4.2.4.1.3 "><p id="dataartsstudio_01_0528__en-us_topic_0099822521_p236512139269">Select a task group. If you select a task group, you can control the maximum number of concurrent nodes in the task group in a fine-grained manner in scenarios where a job contains multiple nodes, a data patching task is ongoing, or a job is rerunning.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
<div class="tablenoborder"><a name="dataartsstudio_01_0528__en-us_topic_0114569494_table987664914213"></a><a name="en-us_topic_0114569494_table987664914213"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0528__en-us_topic_0114569494_table987664914213" frame="border" border="1" rules="all"><caption><b>Table 3 </b>Lineage</caption><thead align="left"><tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row645819861410"><th align="left" class="cellrowborder" valign="top" width="24.88%" id="mcps1.3.2.5.2.3.1.1"><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p10458988144">Parameter</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="75.12%" id="mcps1.3.2.5.2.3.1.2"><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p15458168131416">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row1845888161417"><td class="cellrowborder" colspan="2" valign="top" headers="mcps1.3.2.5.2.3.1.1 mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p18915103311157"><strong id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_b84235270610534">Input</strong></p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row3459178131420"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p187842189163">Add</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p18780151816168">Click <span class="uicontrol" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_uicontrol10540132714159"><b>Add</b></span>. In the <span class="parmname" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_parmname618004413147"><b>Type</b></span> drop-down list, select the type to be created. The value can be <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b1428175313178">DWS</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b16281153191719">OBS</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b8285537176">CSS</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b4291953171713">HIVE</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b152955318176">DLI</strong>, or <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b20291153191720">CUSTOM</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row199741336132219"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p1749815291215">OK</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p849611210129">Click <span class="uicontrol" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_uicontrol933415249182"><b>OK</b></span> to save the parameter settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row18429125472217"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p54958220127">Cancel</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p249314216120">Click <span class="uicontrol" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_uicontrol622928195712"><b>Cancel</b></span> to cancel the parameter settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row893175852218"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p7490112151211">Modify</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p5489152101216">Click <span><img id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_image17798910112517" src="en-us_image_0000002269198773.png"></span> to modify the parameter settings. After the modification, save the settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row193125810225"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p84888215126">Delete</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p9486721124">Click <span><img id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_image3622107287" src="en-us_image_0000002269198765.png"></span> to delete the parameter settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row4275174312218"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p19276543122219">View Details</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p132769436229">Click <span><img id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_image293616596236" src="en-us_image_0000002234079480.png"></span> to view details about the table created based on the input lineage.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row293114586229"><td class="cellrowborder" colspan="2" valign="top" headers="mcps1.3.2.5.2.3.1.1 mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p1538144016336"><strong id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_b842352706105213">Output</strong></p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row5430165412220"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p93819401331">Add</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p103824018333">Click <span class="uicontrol" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_uicontrol0610144565819"><b>Add</b></span>. In the <span class="parmname" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_parmname1261113455588"><b>Type</b></span> drop-down list, select the type to be created. The value can be <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b17565442161816">DWS</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b7565104221818">OBS</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b165661642161810">CSS</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b15676426181">HIVE</strong>, <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b1456734211820">DLI</strong>, or <strong id="dataartsstudio_01_0528__en-us_topic_0181380515_b14568342161813">CUSTOM</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row8430175416224"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p1401840133315">OK</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p84014033318">Click <span class="uicontrol" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_uicontrol1526514115119"><b>OK</b></span> to save the parameter settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row33901521246"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p74094020337">Cancel</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p1940184016333">Click <span class="uicontrol" id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_uicontrol1483816469110"><b>Cancel</b></span> to cancel the parameter settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row1919619151644"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p144013406339">Modify</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p11401040133312">Click <span><img id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_image1640124083311" src="en-us_image_0000002269118737.png"></span> to modify the parameter settings. After the modification, save the settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row1891511181842"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p9401340173318">Delete</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p17404746103416">Click <span><img id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_image14409406336" src="en-us_image_0000002269198821.png"></span> to delete the parameter settings.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_row166741601271"><td class="cellrowborder" valign="top" width="24.88%" headers="mcps1.3.2.5.2.3.1.1 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p176123142711">View Details</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="75.12%" headers="mcps1.3.2.5.2.3.1.2 "><p id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_p14771737274">Click <span><img id="dataartsstudio_01_0528__en-us_topic_0181380515_en-us_topic_0101095232_image197793102717" src="en-us_image_0000002269118733.png"></span> to view details about the table created based on the output lineage.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dataartsstudio_01_0441.html">Node Reference</a></div>
|
|
</div>
|
|
</div>
|
|
|