JSON_TYPEOF function

The JSON_TYPEOF scalar function returns a VARCHAR with values boolean, number, string, object, array, or null, depending on the dynamic type of the SUPER value.

Syntax

JSON_TYPEOF(super_expression)

Arguments

super_expression

A SUPER expression or column.

Return type

VARCHAR

Examples

To check the type of JSON for the array [1,2] using the JSON_TYPEOF function, use the following example.

SELECT JSON_TYPEOF(ARRAY(1,2));

+-------------+
| json_typeof |
+-------------+
| array       |
+-------------+

To check the type of JSON for the object {"name":"Joe"} using the JSON_TYPEOF function, use the following example.

SELECT JSON_TYPEOF(JSON_PARSE('{"name":"Joe"}'));

+-------------+
| json_typeof |
+-------------+
| object      |
+-------------+