forked from docs/doc-exports
Su, Xiaomeng
76a5b1ee83
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com> Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
84 lines
10 KiB
HTML
84 lines
10 KiB
HTML
<a name="dli_spark_concat"></a><a name="dli_spark_concat"></a>
|
|
|
|
<h1 class="topictitle1">concat</h1>
|
|
<div id="body8662426"><p id="dli_spark_concat__en-us_topic_0000001623027504_p18471163815215">This function is used to concatenate arrays or strings.</p>
|
|
<div class="section" id="dli_spark_concat__en-us_topic_0000001623027504_section45291954203217"><h4 class="sectiontitle">Syntax</h4><p id="dli_spark_concat__en-us_topic_0000001623027504_p1846431510163">If multiple arrays are used as the input, all elements in the arrays are connected to generate a new array.</p>
|
|
<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen19143055161520">concat(array<T> <a>, array<T> <b>[,...])</pre>
|
|
<p id="dli_spark_concat__en-us_topic_0000001623027504_p13156124911511">If multiple strings are used as the input, the strings are connected to generate a new string.</p>
|
|
<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen7178959111518">concat(string <str1>, string <str2>[,...])</pre>
|
|
</div>
|
|
<div class="section" id="dli_spark_concat__en-us_topic_0000001623027504_section992014913317"><h4 class="sectiontitle">Parameters</h4><ul id="dli_spark_concat__en-us_topic_0000001623027504_ul1371214211813"><li id="dli_spark_concat__en-us_topic_0000001623027504_li18712122101814">Using arrays as the input
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="dli_spark_concat__en-us_topic_0000001623027504_table1829154762513" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Parameters</caption><thead align="left"><tr id="dli_spark_concat__en-us_topic_0000001623027504_row8830104792517"><th align="left" class="cellrowborder" valign="top" width="19.220000000000002%" id="mcps1.3.3.2.1.1.2.5.1.1"><p id="dli_spark_concat__en-us_topic_0000001623027504_p983074711252">Parameter</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="13.44%" id="mcps1.3.3.2.1.1.2.5.1.2"><p id="dli_spark_concat__en-us_topic_0000001623027504_p6830124732517">Mandatory</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="15.57%" id="mcps1.3.3.2.1.1.2.5.1.3"><p id="dli_spark_concat__en-us_topic_0000001623027504_p13318164512614">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="51.77%" id="mcps1.3.3.2.1.1.2.5.1.4"><p id="dli_spark_concat__en-us_topic_0000001623027504_p08301547132513">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dli_spark_concat__en-us_topic_0000001623027504_row15830184792511"><td class="cellrowborder" valign="top" width="19.220000000000002%" headers="mcps1.3.3.2.1.1.2.5.1.1 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p683034714250">a, b</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="13.44%" headers="mcps1.3.3.2.1.1.2.5.1.2 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p12830184752518">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.57%" headers="mcps1.3.3.2.1.1.2.5.1.3 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p0318545102615">STRING</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="51.77%" headers="mcps1.3.3.2.1.1.2.5.1.4 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p34081717121714">Array</p>
|
|
<p id="dli_spark_concat__en-us_topic_0000001623027504_p118091624151711">In array<T>, <strong id="dli_spark_concat__en-us_topic_0000001623027504_b1075913542504">T</strong> indicates the data type of the elements in the array. The elements in the array can be of any type.</p>
|
|
<p id="dli_spark_concat__en-us_topic_0000001623027504_p1065919122304">The data types of elements in arrays a and b must be the same. If the values of the elements in an array are <strong id="dli_spark_concat__en-us_topic_0000001623027504_b96915191907">NULL</strong>, the elements are involved in the operation.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</li><li id="dli_spark_concat__en-us_topic_0000001623027504_li872620751810">Using strings as the input
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="dli_spark_concat__en-us_topic_0000001623027504_table14157858121717" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Parameters</caption><thead align="left"><tr id="dli_spark_concat__en-us_topic_0000001623027504_row19157145881719"><th align="left" class="cellrowborder" valign="top" width="19.220000000000002%" id="mcps1.3.3.2.2.1.2.5.1.1"><p id="dli_spark_concat__en-us_topic_0000001623027504_p19157758141712">Parameter</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="13.44%" id="mcps1.3.3.2.2.1.2.5.1.2"><p id="dli_spark_concat__en-us_topic_0000001623027504_p17157145814177">Mandatory</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="15.57%" id="mcps1.3.3.2.2.1.2.5.1.3"><p id="dli_spark_concat__en-us_topic_0000001623027504_p10157105818178">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="51.77%" id="mcps1.3.3.2.2.1.2.5.1.4"><p id="dli_spark_concat__en-us_topic_0000001623027504_p715725815176">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="dli_spark_concat__en-us_topic_0000001623027504_row16157858151713"><td class="cellrowborder" valign="top" width="19.220000000000002%" headers="mcps1.3.3.2.2.1.2.5.1.1 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p1157165881718">str1, str2</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="13.44%" headers="mcps1.3.3.2.2.1.2.5.1.2 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p4157145812179">Yes</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="15.57%" headers="mcps1.3.3.2.2.1.2.5.1.3 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p13157458181710">STRING</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="51.77%" headers="mcps1.3.3.2.2.1.2.5.1.4 "><p id="dli_spark_concat__en-us_topic_0000001623027504_p1732053691812">String</p>
|
|
<p id="dli_spark_concat__en-us_topic_0000001623027504_p1815785811179">If the value of the input parameter is of the BIGINT, DOUBLE, DECIMAL, or DATETIME type, the value is automatically converted to the STRING type for calculation. For other types of values, an error is reported.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</li></ul>
|
|
</div>
|
|
<div class="section" id="dli_spark_concat__en-us_topic_0000001623027504_section210162513312"><h4 class="sectiontitle">Return Values</h4><p id="dli_spark_concat__en-us_topic_0000001623027504_p184124317231">The return value is of the ARRAY or STRING type.</p>
|
|
<div class="note" id="dli_spark_concat__en-us_topic_0000001623027504_note61422099395"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><ul id="dli_spark_concat__en-us_topic_0000001623027504_ul134321002417"><li id="dli_spark_concat__en-us_topic_0000001623027504_li104321203249">If the return value is of the ARRAY type and any input array is <strong id="dli_spark_concat__en-us_topic_0000001623027504_b12982195616150">NULL</strong>, <strong id="dli_spark_concat__en-us_topic_0000001623027504_b78263919160">NULL</strong> is returned.</li><li id="dli_spark_concat__en-us_topic_0000001623027504_li202911413196">If the return value is of the STRING type and there is no parameter or any parameter is <strong id="dli_spark_concat__en-us_topic_0000001623027504_b8620102941910">NULL</strong>, <strong id="dli_spark_concat__en-us_topic_0000001623027504_b13620229111919">NULL</strong> is returned.</li></ul>
|
|
</div></div>
|
|
</div>
|
|
<div class="section" id="dli_spark_concat__en-us_topic_0000001623027504_section13277192233920"><h4 class="sectiontitle">Example Code</h4><ul id="dli_spark_concat__en-us_topic_0000001623027504_ul15897115012018"><li id="dli_spark_concat__en-us_topic_0000001623027504_li88971250162013">Connect the array (1, 2) and array (2, -2). An example command is as follows:<div class="p" id="dli_spark_concat__en-us_topic_0000001623027504_p16259182614562"><a name="dli_spark_concat__en-us_topic_0000001623027504_li88971250162013"></a><a name="en-us_topic_0000001623027504_li88971250162013"></a>The value <strong id="dli_spark_concat__en-us_topic_0000001623027504_b4572180172117">[1, 2, 2, -2]</strong> is returned.<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen19131131181316">select concat(array(1, 2), array(2, -2));</pre>
|
|
</div>
|
|
</li><li id="dli_spark_concat__en-us_topic_0000001623027504_li9873165515209">Any array is <strong id="dli_spark_concat__en-us_topic_0000001623027504_b13636181212214">NULL</strong>. An example command is as follows:<div class="p" id="dli_spark_concat__en-us_topic_0000001623027504_p03871534145619">The value <strong id="dli_spark_concat__en-us_topic_0000001623027504_b8527121817214">NULL</strong> is returned.<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen13756814161413">select concat(array(10, 20), null);</pre>
|
|
</div>
|
|
</li><li id="dli_spark_concat__en-us_topic_0000001623027504_li24281959192018">Connect strings ABC and DEF. An example command is as follows:<div class="p" id="dli_spark_concat__en-us_topic_0000001623027504_p64258446568"><a name="dli_spark_concat__en-us_topic_0000001623027504_li24281959192018"></a><a name="en-us_topic_0000001623027504_li24281959192018"></a>The value <strong id="dli_spark_concat__en-us_topic_0000001623027504_b121591716155815">ABCDEF</strong> is returned.<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen2877755122012">select concat('ABC','DEF');</pre>
|
|
</div>
|
|
</li><li id="dli_spark_concat__en-us_topic_0000001623027504_li18431359132015">The input is empty. An example command is as follows:<div class="p" id="dli_spark_concat__en-us_topic_0000001623027504_p428875135710"><a name="dli_spark_concat__en-us_topic_0000001623027504_li18431359132015"></a><a name="en-us_topic_0000001623027504_li18431359132015"></a>The value <strong id="dli_spark_concat__en-us_topic_0000001623027504_b144338127229">NULL</strong> is returned.<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen13431459182019">select concat();</pre>
|
|
</div>
|
|
</li><li id="dli_spark_concat__en-us_topic_0000001623027504_li1643165914200">The value of any string is <strong id="dli_spark_concat__en-us_topic_0000001623027504_b19897423132215">NULL</strong>. An example command is as follows:<div class="p" id="dli_spark_concat__en-us_topic_0000001623027504_p202531816185714">The value <strong id="dli_spark_concat__en-us_topic_0000001623027504_b193421536182218">NULL</strong> is returned.<pre class="screen" id="dli_spark_concat__en-us_topic_0000001623027504_screen18431105917206">select concat('abc', 'def', null);</pre>
|
|
</div>
|
|
</li></ul>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dli_08_0472.html">String Functions</a></div>
|
|
</div>
|
|
</div>
|
|
|