Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

JSON_GET_TYPE

Syntax

SQL

JSON_GET_TYPE(json)

Arguments

json: a valid JSON value.

Return Value

The type is returned as one of the following strings:

boolean
double
string
array
object
null
Or, SQL NULL if json is not a valid JSON object.

Examples

SQL

SELECT JSON_GET_TYPE('true');

+-----------------------+
| json_get_type('true') |
+-----------------------+
| boolean               |
+-----------------------+

SQL

SELECT JSON_GET_TYPE('12345');

+------------------------+
| JSON_GET_TYPE('12345') |
+------------------------+
| double                 |
+------------------------+

SQL

SELECT JSON_GET_TYPE('"alpha, beta, gamma"');

+---------------------------------------+
| JSON_GET_TYPE('"alpha, beta, gamma"') |
+---------------------------------------+
| string                                |
+---------------------------------------+

SQL

SELECT JSON_GET_TYPE('[1,2,3]');

+--------------------------+
| JSON_GET_TYPE('[1,2,3]') |
+--------------------------+
| array                    |
+--------------------------+

SQL

SELECT JSON_GET_TYPE('{"alpha”:1, "beta”:2}’);

+----------------------------------------+
| JSON_GET_TYPE('{"alpha":1, "beta":2}') |
+----------------------------------------+
| object                                 |
+----------------------------------------+

SQL

SELECT JSON_GET_TYPE('null');

+-----------------------+
| JSON_GET_TYPE('null') |
+-----------------------+
| null                  |
+-----------------------+

Note

A JSON or Javascript null value is distinct from SQL NULL.

JSON_GET_TYPE

On this page

Syntax

Arguments

Return Value

Examples

Was this article helpful?

On this page

Was this article helpful?