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