| <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> |