yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
main
doc-exports/docs/dataartsstudio/umn/dataartsstudio_01_0416.html
chenxiaoxiong f9e2808b7c DataArts UMN 20250810 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
Co-committed-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
2025-09-02 10:44:13 +00:00

481 lines
62 KiB
HTML
Raw Permalink Blame History

<a name="dataartsstudio_01_0416"></a><a name="dataartsstudio_01_0416"></a>
<h1 class="topictitle1">Creating a Table</h1>
<div id="body8662426"><p id="dataartsstudio_01_0416__en-us_topic_0125929047_p4612146105417">You can create a table on the DataArts Factory console, in DDL mode, or using a SQL script.</p>
<ul id="dataartsstudio_01_0416__ul152869413145"><li id="dataartsstudio_01_0416__li192862041181410">(Recommended) Console: You can directly create a table on the <span id="dataartsstudio_01_0416__text1611514535285">DataArts Studio</span> DataArts Factory console with no code.</li><li id="dataartsstudio_01_0416__li135692049191913">(Recommended) DDL mode: You can select the DDL mode in <span id="dataartsstudio_01_0416__text1562164145612">DataArts Studio</span>'s DataArts Factory module to create a table using a SQL script.</li><li id="dataartsstudio_01_0416__li1457411432148">SQL script: You can also develop and execute a SQL script for creating a table in the SQL editor of <span id="dataartsstudio_01_0416__text821523151915">DataArts Studio</span>'s DataArts Factory module or a data lake product, and then use the script to create a table.</li></ul>
<p id="dataartsstudio_01_0416__p1279934420179">This section describes how to create a table on the DataArts Factory console and in DDL mode.</p>
<div class="section" id="dataartsstudio_01_0416__en-us_topic_0125513554_section1927335128"><h4 class="sectiontitle">Prerequisites</h4><ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul149184084516"><li id="dataartsstudio_01_0416__li142702491419">You have created a database and a DWS database schema. For details, see <a href="dataartsstudio_01_0405.html">Creating a Database</a> and <a href="dataartsstudio_01_0412.html">(Optional) Creating a Database Schema</a>.</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li164944064512">A data connection that matches the table type has been created in <span id="dataartsstudio_01_0416__text191911556202112">DataArts Factory</span>. For details, see <a href="dataartsstudio_01_0404.html">Creating a Data Connection</a>.</li></ul>
</div>
<div class="section" id="dataartsstudio_01_0416__en-us_topic_0125513554_section51047422516"><h4 class="sectiontitle">Creating a Table (GUI Mode)</h4><ol id="dataartsstudio_01_0416__ol7993205014283"><li id="dataartsstudio_01_0416__li2848154165110">Log in to the <span id="dataartsstudio_01_0416__en-us_topic_0000001987511677_en-us_topic_0000001127311125_text5574448155719">DataArts Studio</span> console by following the instructions in <a href="dataartsstudio_01_0001.html">Accessing the DataArts Studio Instance Console</a>.</li><li id="dataartsstudio_01_0416__li1816416301479">On the <span id="dataartsstudio_01_0416__en-us_topic_0181092879_text185611381448">DataArts Studio</span> console, locate a workspace and click <strong id="dataartsstudio_01_0416__en-us_topic_0181092879_b65382814249">DataArts Factory</strong>.</li><li id="dataartsstudio_01_0416__li6576131765420">In the left navigation pane of DataArts Factory, choose <span class="menucascade" id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_menucascade1889024114211"><b><span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_uicontrol88905411627"><span id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_text6890114118213">Data Development</span></span></b> &gt; <b><span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_uicontrol1189017411422"><span id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_text18901411529">Develop Script</span></span></b></span>.</li><li id="dataartsstudio_01_0416__li1427910182810">In the script development menu, click <span><img id="dataartsstudio_01_0416__image639418144713" src="en-us_image_0000002234080764.png"></span>, expand the data connection to <span class="parmname" id="dataartsstudio_01_0416__parmname18840937438"><b>tables</b></span>, and right-click <span class="uicontrol" id="dataartsstudio_01_0416__uicontrol158411832434"><b>Create Table</b></span> or click <span><img id="dataartsstudio_01_0416__image168424318439" src="en-us_image_0000002234240616.png"></span> to create a table.</li><li id="dataartsstudio_01_0416__li1499310508281">In the displayed dialog box, configure parameters based on <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table168445103311">Table 1</a> on the<strong id="dataartsstudio_01_0416__b68941550153816"> Basic property configuration</strong> tab page.
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513554_table168445103311"></a><a name="en-us_topic_0125513554_table168445103311"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513554_table168445103311" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Basic property parameters</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row38441710153116"><th align="left" class="cellrowborder" valign="top" width="38%" id="mcps1.3.5.2.5.3.2.3.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p8844181019314">Data Connection Type</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="62%" id="mcps1.3.5.2.5.3.2.3.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1484491053115">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row3844181014312"><td class="cellrowborder" valign="top" width="38%" headers="mcps1.3.5.2.5.3.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p884421093119"><span id="dataartsstudio_01_0416__en-us_topic_0125513554_text1593718290810">DLI</span></p>
</td>
<td class="cellrowborder" valign="top" width="62%" headers="mcps1.3.5.2.5.3.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1384451023118">For details, see the <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname1904575137"><b>Basic Property</b></span> part in <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table50275875142857">Table 5</a>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1384491011313"><td class="cellrowborder" valign="top" width="38%" headers="mcps1.3.5.2.5.3.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p2844171013114">GaussDB(DWS)</p>
</td>
<td class="cellrowborder" valign="top" width="62%" headers="mcps1.3.5.2.5.3.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p19844131023111">For details, see the <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname5889252122916"><b>Basic Property</b></span> part in <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table1834312173120">Table 6</a>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row18441110193115"><td class="cellrowborder" valign="top" width="38%" headers="mcps1.3.5.2.5.3.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p7844191013119">MRS Hive</p>
</td>
<td class="cellrowborder" valign="top" width="62%" headers="mcps1.3.5.2.5.3.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p88441110113117">For details, see the <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname1719278113012"><b>Basic Property</b></span> part in <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table122615115615">Table 7</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li id="dataartsstudio_01_0416__li19993105015287">Click <span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0125513554_uicontrol1227572536143551"><b>Next</b></span>. On the <span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0125513554_uicontrol75182782714363"><b>Configure Table Structure</b></span> page, configure tbe table structure parameters based on <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table198753321147">Table 2</a>.
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513554_table198753321147"></a><a name="en-us_topic_0125513554_table198753321147"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513554_table198753321147" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Table structure</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row8891183219149"><th align="left" class="cellrowborder" valign="top" width="38%" id="mcps1.3.5.2.6.4.2.3.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1906143219145">Data Connection Type</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="62%" id="mcps1.3.5.2.6.4.2.3.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p8906732201416">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row119061132181420"><td class="cellrowborder" valign="top" width="38%" headers="mcps1.3.5.2.6.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p790623221413"><span id="dataartsstudio_01_0416__en-us_topic_0125513554_text12906123251417">DLI</span></p>
</td>
<td class="cellrowborder" valign="top" width="62%" headers="mcps1.3.5.2.6.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p69221032171410">For details, see the <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname17645434333"><b>Table Structure</b></span> part in <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table50275875142857">Table 5</a>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row0922123211411"><td class="cellrowborder" valign="top" width="38%" headers="mcps1.3.5.2.6.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p89221832171413">GaussDB(DWS)</p>
</td>
<td class="cellrowborder" valign="top" width="62%" headers="mcps1.3.5.2.6.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p11937103218144">For details, see the <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname8198117123318"><b>Table Structure</b></span> part in <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table1834312173120">Table 6</a>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row793773271412"><td class="cellrowborder" valign="top" width="38%" headers="mcps1.3.5.2.6.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1093783220148">MRS Hive</p>
</td>
<td class="cellrowborder" valign="top" width="62%" headers="mcps1.3.5.2.6.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p10937143213141">For details, see the <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname8117735123320"><b>Table Structure</b></span> part in <a href="#dataartsstudio_01_0416__en-us_topic_0125513554_table122615115615">Table 7</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li id="dataartsstudio_01_0416__li19993650102812">Click <span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0125513554_uicontrol12682717345"><b>OK</b></span>.</li></ol>
</div>
<div class="section" id="dataartsstudio_01_0416__en-us_topic_0125513555_section1598220213195"><h4 class="sectiontitle">Creating a Table (DDL Mode)</h4><ol id="dataartsstudio_01_0416__ol34681843122911"><li id="dataartsstudio_01_0416__li10826124154815">Log in to the <span id="dataartsstudio_01_0416__en-us_topic_0000001987511677_en-us_topic_0000001127311125_text5574448155719_1">DataArts Studio</span> console by following the instructions in <a href="dataartsstudio_01_0001.html">Accessing the DataArts Studio Instance Console</a>.</li><li id="dataartsstudio_01_0416__li17281138437">On the <span id="dataartsstudio_01_0416__en-us_topic_0181092879_text185611381448_1">DataArts Studio</span> console, locate a workspace and click <strong id="dataartsstudio_01_0416__en-us_topic_0181092879_b65382814249_1">DataArts Factory</strong>.</li><li id="dataartsstudio_01_0416__li14728438230">In the left navigation pane of DataArts Factory, choose <span class="menucascade" id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_menucascade1889024114211_1"><b><span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_uicontrol88905411627_1"><span id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_text6890114118213_1">Data Development</span></span></b> &gt; <b><span class="uicontrol" id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_uicontrol1189017411422_1"><span id="dataartsstudio_01_0416__en-us_topic_0181092879_en-us_topic_0104967364_text18901411529_1">Develop Script</span></span></b></span>.</li><li id="dataartsstudio_01_0416__li172951313719">In the script development menu, click <span><img id="dataartsstudio_01_0416__image571729194616" src="en-us_image_0000002269119985.png"></span>, expand the data connection to <span class="parmname" id="dataartsstudio_01_0416__parmname179151217174314"><b>tables</b></span>, and right-click <span class="uicontrol" id="dataartsstudio_01_0416__uicontrol89169171439"><b>Create Table</b></span> or click <span><img id="dataartsstudio_01_0416__image1391721713433" src="en-us_image_0000002269200033.png"></span> to create a table.</li><li id="dataartsstudio_01_0416__li16468134318294">Click <span class="uicontrol" id="dataartsstudio_01_0416__uicontrol118472052124210"><b>DDL-based Table Creation</b></span> and enter SQL statements in the displayed editor. (Default values are set for the parameters listed in <a href="#dataartsstudio_01_0416__en-us_topic_0125513555_table1129115213117">Table 3</a>.) The following is an example:<pre class="screen" id="dataartsstudio_01_0416__screen106346501940">CREATE TABLE userinfo ( id INT, name STRING);</pre>
<div class="note" id="dataartsstudio_01_0416__note856720424618"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="dataartsstudio_01_0416__p4569164213618">The SQL syntax varies depending on the data source. Before developing an SQL statement, learn about the syntax of the data source from its documentation.</p>
</div></div>
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513555_table1129115213117"></a><a name="en-us_topic_0125513555_table1129115213117"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513555_table1129115213117" frame="border" border="1" rules="all"><caption><b>Table 3 </b>Data table parameters</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513555_row22911229112"><th align="left" class="cellrowborder" valign="top" width="33%" id="mcps1.3.6.2.5.5.2.3.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p629112141115">Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="67%" id="mcps1.3.6.2.5.5.2.3.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p629110261118">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513555_row1629111210113"><td class="cellrowborder" valign="top" width="33%" headers="mcps1.3.6.2.5.5.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p1469124513239">Data Connection Type</p>
</td>
<td class="cellrowborder" valign="top" width="67%" headers="mcps1.3.6.2.5.5.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p329152131118">Type of data connection to which the table belongs</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513555_row5291621114"><td class="cellrowborder" valign="top" width="33%" headers="mcps1.3.6.2.5.5.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p12550184854213">Data Connection</p>
</td>
<td class="cellrowborder" valign="top" width="67%" headers="mcps1.3.6.2.5.5.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p1231407154314">Data connection to which the table belongs</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513555_row1229112214118"><td class="cellrowborder" valign="top" width="33%" headers="mcps1.3.6.2.5.5.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p172911025112">Database</p>
</td>
<td class="cellrowborder" valign="top" width="67%" headers="mcps1.3.6.2.5.5.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513555_p1973642216431">Database where the data table is located</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li id="dataartsstudio_01_0416__li0468124314292">Click <span class="uicontrol" id="dataartsstudio_01_0416__uicontrol775913394518"><b>Save</b></span>.</li></ol>
</div>
<div class="section" id="dataartsstudio_01_0416__en-us_topic_0000001629752664_section11218546133410"><h4 class="sectiontitle">Related Operations</h4><ul id="dataartsstudio_01_0416__en-us_topic_0000001629752664_ul4546171163518"><li id="dataartsstudio_01_0416__en-us_topic_0000001629752664_li85469173513">View table details: In the script development menu, click <span><img id="dataartsstudio_01_0416__image1620312618497" src="en-us_image_0000002269119953.png"></span>. Expand the data connection to the data table level, right-click a table name, and select <span class="uicontrol" id="dataartsstudio_01_0416__uicontrol3865027124313"><b>View Details</b></span> from the shortcut menu to view the table details shown in <a href="#dataartsstudio_01_0416__en-us_topic_0125513556_table2952161015324">Table 4</a>.
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513556_table2952161015324"></a><a name="en-us_topic_0125513556_table2952161015324"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513556_table2952161015324" frame="border" border="1" rules="all"><caption><b>Table 4 </b>Table details</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513556_row13952410173219"><th align="left" class="cellrowborder" valign="top" width="30%" id="mcps1.3.7.2.1.4.2.3.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p1795213101325">Tab Name</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="70%" id="mcps1.3.7.2.1.4.2.3.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p1895271016324">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513556_row895213101326"><td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.7.2.1.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p495291019321">Table Information</p>
</td>
<td class="cellrowborder" valign="top" width="70%" headers="mcps1.3.7.2.1.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p59521410193210">Displays the basic information and storage information about the table.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513556_row395221017325"><td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.7.2.1.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p2952210173211">Field Information</p>
</td>
<td class="cellrowborder" valign="top" width="70%" headers="mcps1.3.7.2.1.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p1795251093215">Displays the field information about the table.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513556_row295201063220"><td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.7.2.1.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p4952121063215">Data Preview</p>
</td>
<td class="cellrowborder" valign="top" width="70%" headers="mcps1.3.7.2.1.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p495216103328">Displays 10 records in the table.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513556_row14952131015324"><td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.7.2.1.4.2.3.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p13952110143211">DDL</p>
</td>
<td class="cellrowborder" valign="top" width="70%" headers="mcps1.3.7.2.1.4.2.3.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513556_p395211108320">Displays the DDL of the <span id="dataartsstudio_01_0416__text142911937125615">DLI</span>, DWS or MRS Hive data table.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li id="dataartsstudio_01_0416__li1918511418522">Delete a table: In the script development menu, click <span><img id="dataartsstudio_01_0416__image3294144765518" src="en-us_image_0000002234080788.png"></span>. Expand a data connection, right-click a table name, select <span class="uicontrol" id="dataartsstudio_01_0416__uicontrol16989325161510"><b>Delete</b></span>, and click <strong id="dataartsstudio_01_0416__b198917252155">OK</strong> in the displayed dialog box.<div class="note" id="dataartsstudio_01_0416__note87872058104617"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="dataartsstudio_01_0416__p179063350598">Deleted tables cannot be recovered. Exercise caution when performing this operation.</p>
</div></div>
</li></ul>
</div>
<div class="section" id="dataartsstudio_01_0416__en-us_topic_0125513554_section769327113715"><h4 class="sectiontitle">Parameter Description</h4>
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513554_table50275875142857"></a><a name="en-us_topic_0125513554_table50275875142857"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513554_table50275875142857" frame="border" border="1" rules="all"><caption><b>Table 5 </b><span id="dataartsstudio_01_0416__en-us_topic_0125513554_text1634317427117">DLI</span> data table</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row51954652142857"><th align="left" class="cellrowborder" valign="top" width="31.080000000000002%" id="mcps1.3.8.2.2.4.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p47577266142857">Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="15.1%" id="mcps1.3.8.2.2.4.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p28553374142857">Mandatory</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="53.82%" id="mcps1.3.8.2.2.4.1.3"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p31121925142857">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row362115163814"><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.8.2.2.4.1.1 mcps1.3.8.2.2.4.1.2 mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1462114113820"><strong id="dataartsstudio_01_0416__en-us_topic_0099822521_b13935197152512">Basic Property</strong></p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row37848017142857"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p45790570142857">Table Name</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p18048695142857">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p84903473524">Name of a table. It can contain only letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_) or a digit.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row28010514142922"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p38950004142927">Alias</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p833731142927">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p423375142927">Alias of the data table. It can contain only letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_).</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__row7696814464"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__p06971514469">Data Connection Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__p1969720141468">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__p2697111411615">Type of the data connection to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row40616930144458"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p4670076014458">Data Connection</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p2466522814458">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p5172641514458">Data connection to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row4257550314452"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p6048452714458">Database</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p29963514458">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p2427046814458">Database where the data table is located. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row6147654144546"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p27107743144623">Data Location</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p48243571144623">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p15415208144623">Location to save data. Possible values:</p>
<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul4519150144623"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li40672358144623">OBS</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li30506903144623"><span id="dataartsstudio_01_0416__en-us_topic_0125513554_text5588592019262">DLI</span></li></ul>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row5390678144549"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p26498714144623">Data Format</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p66021089144623">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p46107984144623">Format of data. This parameter is available only when <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname430815605015"><b>Data Location</b></span> is set to <span class="parmvalue" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmvalue1730817615015"><b>OBS</b></span>. Possible values:</p>
<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul12318679144623"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li43759248144623"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b1444518243493">parquet</strong>: DataArts Factory can read non-compressed parquet data and parquet data compressed using Snappy or gzip.</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li58288918144623"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b152701329104919">csv</strong>: DataArts Factory can read non-compressed CSV data and CSV data compressed using gzip.</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li54838217144623"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b2080184015498">orc</strong>: DataArts Factory can read non-compressed ORC data and ORC data compressed using Snappy.</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li23781906144623"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b1970711374496">json</strong>: DataArts Factory can read non-compressed JSON data and JSON data compressed using gzip.</li></ul>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row20661809144552"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p441599144623">Path</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p35769597144623">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p11656255144623">OBS path where the data is stored. This parameter is available only when <span class="parmname" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmname196839139502"><b>Data Location</b></span> is set to <span class="parmvalue" id="dataartsstudio_01_0416__en-us_topic_0125513554_parmvalue1568314133508"><b>OBS</b></span>.</p>
<p id="dataartsstudio_01_0416__p2044604812920">If no OBS path or OBS bucket is available, the system automatically creates an OBS directory.</p>
<div class="note" id="dataartsstudio_01_0416__note1813314111217"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="dataartsstudio_01_0416__p1952919251127">If the number of OBS buckets has reached the upper limit, the system automatically displays the following message: "Failed to create the OBS directory. Error cause: [Create OBS Bucket failed:TooManyBuckets:You have attempted to create more buckets than allowed]".</p>
</div></div>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row7828269144557"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p61429297144623">Table Description</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p9717141144623">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p48890950144623">Descriptive information about the table.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row3308025193815"><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.8.2.2.4.1.1 mcps1.3.8.2.2.4.1.2 mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1764912781011"><strong id="dataartsstudio_01_0416__en-us_topic_0099822521_b97311149204714">Table Structure</strong></p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1199534183810"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p136111159183810">Column Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p18611115917385">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1261195983817">Type of the column. Available options include <strong id="dataartsstudio_01_0416__b117212236413">Partition Column</strong> and <strong id="dataartsstudio_01_0416__b24531026134115">Common Column</strong>. The default value is <strong id="dataartsstudio_01_0416__b1949745594119">Common Column</strong>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__row17113781211"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__p143301426143218">Column Name</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__p8410131491218">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__p1341031471210">Name of the column. The name must be unique.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row131831432123812"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p10627175943819">Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p662715916387">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p66423595388">Type of data.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row19651229163818"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p365845953818">Column Description</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p10658175923813">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1765895910385">Descriptive information about the column.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row371532714384"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.2.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1495719461287">Operation</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.2.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p14673105912385">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.2.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1870718238812">To add a column, click <span><img id="dataartsstudio_01_0416__en-us_topic_0099822521_image11337113784814" src="en-us_image_0000002234240612.png"></span>.</p>
<p id="dataartsstudio_01_0416__p192266611329">To delete a column, click <span><img id="dataartsstudio_01_0416__image125761238133414" src="en-us_image_0000002234240632.png"></span>.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513554_table1834312173120"></a><a name="en-us_topic_0125513554_table1834312173120"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513554_table1834312173120" frame="border" border="1" rules="all"><caption><b>Table 6 </b>DWS data table</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row17359191715120"><th align="left" class="cellrowborder" valign="top" width="31.080000000000002%" id="mcps1.3.8.3.2.4.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p2035917171910">Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="15.1%" id="mcps1.3.8.3.2.4.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p2359117414">Mandatory</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="53.82%" id="mcps1.3.8.3.2.4.1.3"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p19359917610">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1548212148540"><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.8.3.2.4.1.1 mcps1.3.8.3.2.4.1.2 mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p63975161492"><strong id="dataartsstudio_01_0416__en-us_topic_0099822521_b13935197152512_1">Basic Property</strong></p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row16375171717111"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p130132145320">Table Name</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p237511171913">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__p105258815420">Name of a table. It can contain only letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_) or a digit.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row103901517011"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p13985118175616">Alias</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p153901171110">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__p115254814417">Alias of the data table. It can contain only letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_).</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__row19735154919713"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__p174763539716">Data Connection Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__p12476053277">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__p20476853977">Type of the data connection to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row23901174112"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p134503095715">Data Connection</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p339019176119">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p101197242587">Data connection to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1240620171512"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p33991707599">Database</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p440641716111">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1434918414596">Database where the data table is located. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row3878324611"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1140631716120">Schema</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p64065171613">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p540619176116">Schema of the database.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1145317171013"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p29720371401">Table Description</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p945341718118">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p15206481318">Descriptive information about the table.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row8453171713119"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p34531174113">Advanced Settings</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1945320171613">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p6468191716111">The following advanced options are available:</p>
<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul0468161718118"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li10468131713113">Storage method of a table. Possible values:<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul1646817171519"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li1246814171615"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b11124217135020">Row store</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li8468171715118"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b189497196505">Column store</strong></li></ul>
</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li164681117513">Compression level of a table<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul54683175113"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li14681717815">Available values when the storage method is row store: <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b55181720134411">YES</strong> or <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b195207202447">NO</strong>.</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li1346851715112">Available values when the storage method is column store: <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b517720417441">YES</strong>, <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b01776413448">NO</strong>, <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b117954104417">LOW</strong>, <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b0179184117444">MIDDLE</strong>, or <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b5179741134419">HIGH</strong>. For the same compression level in column store mode, you can configure compression grades from 0 to 3. Within any compression level, the higher the grade, the greater the compression ratio.</li></ul>
</li></ul>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row3165436135417"><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.8.3.2.4.1.1 mcps1.3.8.3.2.4.1.2 mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p12977172191012"><strong id="dataartsstudio_01_0416__en-us_topic_0099822521_b97311149204714_1">Table Structure</strong></p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1540193865411"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1968052316517">Column Name</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p891511455515">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p839815497515">Name of the column. The name must be unique.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row4727194019549"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p493118485519">Data Classification</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p993115445511">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p9931114145520">Classification of data. Possible values:</p>
<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul793113475511"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li193119412553"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b0664446114317">Value</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li09451645550"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b1357624834317">Currency</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li794524125511"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b1255295016437">Boolean</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li894534175518"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b4301952194316">Binary</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li494517425515"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b479515314316">Character</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li5961104105515"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b617916553436">Time</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li39619455512"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b9472155617439">Geometric</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li1896124135512"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b5565155810431">Network address</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li17961742559"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b177119111447">Bit string</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li129784412554"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b5209832445">Text search</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li12978194185513"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b429913814413">UUID</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li14978124155510"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b8196273449">JSON</strong></li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li0978745557"><strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b79421496442">OID</strong></li></ul>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1324143419545"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p199374105520">Data Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1499310410559">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p199315418553">Type of data.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row76801831105417"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p135971151763">Column Description</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1231557555">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1172532015714">Descriptive information about the column.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row7843174619484"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p191231273499">Create ES Index</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1684454624820">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p517517440019">If you click the check box, an ES index needs to be created. When creating the ES index, select the created CSS cluster from the <strong id="dataartsstudio_01_0416__en-us_topic_0125513554_b724620476413">CloudSearch Cluster Name</strong> drop-down list. For details about how to create a CSS cluster, see <i><cite id="dataartsstudio_01_0416__cite83f4b3a96dbb4bdf966f093f25bb3fcc160351">Cloud Search Service User Guide</cite></i>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row18596191812494"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p20293133204910">Index Data Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p105971218174910">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p6962433163712">Data type of the ES index. The options are as follows:</p>
<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul79621633143716"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li29629331375">text</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li1296215330373">keyword</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li161541644175015">date</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li89501947145017">long</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li18752155125016">integer</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li196821358185012">short</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li159621025111">byte</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li436815419514">double</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li18119486515">boolean</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li9585183025119">binary</li></ul>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1916472910545"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.3.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p261311408815">Operation</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.3.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p4401954551">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.3.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p9629111612817">To add a column, click <span><img id="dataartsstudio_01_0416__en-us_topic_0099822521_image11337113784814_1" src="en-us_image_0000002234240612.png"></span>.</p>
<p id="dataartsstudio_01_0416__p195515415345">To delete a column, click <span><img id="dataartsstudio_01_0416__image938695416349" src="en-us_image_0000002234080752.png"></span>.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><a name="dataartsstudio_01_0416__en-us_topic_0125513554_table122615115615"></a><a name="en-us_topic_0125513554_table122615115615"></a><table cellpadding="4" cellspacing="0" summary="" id="dataartsstudio_01_0416__en-us_topic_0125513554_table122615115615" frame="border" border="1" rules="all"><caption><b>Table 7 </b>MRS Hive data table</caption><thead align="left"><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row20242511561"><th align="left" class="cellrowborder" valign="top" width="31.080000000000002%" id="mcps1.3.8.4.2.4.1.1"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p17242317620">Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="15.1%" id="mcps1.3.8.4.2.4.1.2"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1924271965">Mandatory</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="53.82%" id="mcps1.3.8.4.2.4.1.3"><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1524213110611">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row1242011663"><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.8.4.2.4.1.1 mcps1.3.8.4.2.4.1.2 mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p17710121191"><strong id="dataartsstudio_01_0416__en-us_topic_0099822521_b13935197152512_2">Basic Property</strong></p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row925811265"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p729563825318">Table Name</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1125812116611">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__p125421641052">Name of a table. It can contain only letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_) or a digit.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row162581912610"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1850011425611">Alias</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1125811967">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__p125421041953">Alias of the data table. It can contain only letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_).</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__row7909291888"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__p161689311988">Data Connection Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__p1416893110818">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__p1216813115811">Type of the data connection to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row2274211763"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p175491235105710">Data Connection</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p17274111760">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p267992316588">Data connection to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row22741217610"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1392925205911">Database</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p327420114616">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p6553104885910">Database to which the table belongs. The default value is used and cannot be changed.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row112881511364"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1392518434018">Table Description</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p10288101569">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p16631718716">Descriptive information about the table.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row20826123115458"><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.8.4.2.4.1.1 mcps1.3.8.4.2.4.1.2 mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p118615819910"><strong id="dataartsstudio_01_0416__en-us_topic_0099822521_b97311149204714_2">Table Structure</strong></p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row622543114613"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1699311281516">Column Name</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p36636228466">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1082155510514">Name of the column. The name must be unique.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row3694144144513"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p06785227469">Data Classification</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1867812222469">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1469442219463">Classification of data. Possible values:</p>
<ul id="dataartsstudio_01_0416__en-us_topic_0125513554_ul8694722174619"><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li15694202224619">Original type</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li196941722134613">ARRAY</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li106942223462">MAP</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li070862216469">STRUCT</li><li id="dataartsstudio_01_0416__en-us_topic_0125513554_li870822216469">UNION</li></ul>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row78191946164518"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p16708202274611">Data Type</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1372513227462">Yes</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p6725422134616">Type of data. See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-PartitionedTables" target="_blank" rel="noopener noreferrer">LanguageManual DDL</a>.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row156771044114512"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1439485612615">Column Description</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p274022213465">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p4287112611717">Descriptive information about the column.</p>
</td>
</tr>
<tr id="dataartsstudio_01_0416__en-us_topic_0125513554_row723363917455"><td class="cellrowborder" valign="top" width="31.080000000000002%" headers="mcps1.3.8.4.2.4.1.1 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1369110356811">Operation</p>
</td>
<td class="cellrowborder" valign="top" width="15.1%" headers="mcps1.3.8.4.2.4.1.2 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p1755112224614">No</p>
</td>
<td class="cellrowborder" valign="top" width="53.82%" headers="mcps1.3.8.4.2.4.1.3 "><p id="dataartsstudio_01_0416__en-us_topic_0125513554_p16591211982">To add a column, click <span><img id="dataartsstudio_01_0416__en-us_topic_0099822521_image11337113784814_2" src="en-us_image_0000002234240612.png"></span>.</p>
<p id="dataartsstudio_01_0416__p919685963419">To delete a column, click <span><img id="dataartsstudio_01_0416__image4781205963415" src="en-us_image_0000002269119961.png"></span>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dataartsstudio_01_0403.html">Data Management</a></div>
</div>
</div>
View Git Blame Copy Permalink