blob: 5456e11d90add3d4f211d1c029b01e414e99add0 [file] [log] [blame]
<table class="table">
<thead>
<tr>
<th style="width:25%">Function</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td>collations()</td>
<td>Get all of the Spark SQL string collations</td>
</tr>
<tr>
<td>explode(expr)</td>
<td>Separates the elements of array `expr` into multiple rows, or the elements of map `expr` into multiple rows and columns. Unless specified otherwise, uses the default column name `col` for elements of the array or `key` and `value` for the elements of the map.</td>
</tr>
<tr>
<td>explode_outer(expr)</td>
<td>Separates the elements of array `expr` into multiple rows, or the elements of map `expr` into multiple rows and columns. Unless specified otherwise, uses the default column name `col` for elements of the array or `key` and `value` for the elements of the map.</td>
</tr>
<tr>
<td>inline(expr)</td>
<td>Explodes an array of structs into a table. Uses column names col1, col2, etc. by default unless specified otherwise.</td>
</tr>
<tr>
<td>inline_outer(expr)</td>
<td>Explodes an array of structs into a table. Uses column names col1, col2, etc. by default unless specified otherwise.</td>
</tr>
<tr>
<td>posexplode(expr)</td>
<td>Separates the elements of array `expr` into multiple rows with positions, or the elements of map `expr` into multiple rows and columns with positions. Unless specified otherwise, uses the column name `pos` for position, `col` for elements of the array or `key` and `value` for elements of the map.</td>
</tr>
<tr>
<td>posexplode_outer(expr)</td>
<td>Separates the elements of array `expr` into multiple rows with positions, or the elements of map `expr` into multiple rows and columns with positions. Unless specified otherwise, uses the column name `pos` for position, `col` for elements of the array or `key` and `value` for elements of the map.</td>
</tr>
<tr>
<td>sql_keywords()</td>
<td>Get Spark SQL keywords</td>
</tr>
<tr>
<td>stack(n, expr1, ..., exprk)</td>
<td>Separates `expr1`, ..., `exprk` into `n` rows. Uses column names col0, col1, etc. by default unless specified otherwise.</td>
</tr>
</tbody>
</table>