| <table class="table"> |
| <thead> |
| <tr> |
| <th style="width:25%">Function</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td>from_json(jsonStr, schema[, options])</td> |
| <td>Returns a struct value with the given `jsonStr` and `schema`.</td> |
| </tr> |
| <tr> |
| <td>get_json_object(json_txt, path)</td> |
| <td>Extracts a json object from `path`.</td> |
| </tr> |
| <tr> |
| <td>json_tuple(jsonStr, p1, p2, ..., pn)</td> |
| <td>Returns a tuple like the function get_json_object, but it takes multiple names. All the input parameters and output column types are string.</td> |
| </tr> |
| <tr> |
| <td>schema_of_json(json[, options])</td> |
| <td>Returns schema in the DDL format of JSON string.</td> |
| </tr> |
| <tr> |
| <td>to_json(expr[, options])</td> |
| <td>Returns a JSON string with a given struct value</td> |
| </tr> |
| </tbody> |
| </table> |