json_type

json_type

description

It is used to determine the type of the field specified by json_path in JSON data. If the field does not exist, return NULL. If it exists, return one of the following types

• object
• array
• null
• bool
• int
• bigint
• largeint
• double
• string

Syntax

STRING json_type(JSON j, VARCHAR json_path)

example

Refer to json tutorial

keywords

json_type