Semi-Structured Functions
This section provides reference information for the semi-structured data functions in Databend.
JSON Parsing, Conversion & Type Checking:
- CHECK_JSON
- JSON_PRETTY
- JSON_TYPEOF
- PARSE_JSON
- FLATTEN
- IS_ARRAY
- IS_BOOLEAN
- IS_FLOAT
- IS_INTEGER
- IS_NULL_VALUE
- IS_OBJECT
- IS_STRING
JSON Query and Extraction:
- JSON_ARRAY_ELEMENTS
- JSON_EACH
- JSON_EXTRACT_PATH_TEXT
- JSON_PATH_EXISTS
- JSON_PATH_MATCH
- JSON_PATH_QUERY
- JSON_PATH_QUERY_ARRAY
- JSON_PATH_QUERY_FIRST
- JQ
JSON Data Manipulation:
- JSON_ARRAY
- JSON_STRIP_NULLS
- JSON_OBJECT
- JSON_OBJECT_KEEP_NULL
- JSON_OBJECT_INSERT
- JSON_ARRAY_DISTINCT
- JSON_ARRAY_EXCEPT
- JSON_ARRAY_INSERT
- JSON_ARRAY_INTERSECTION
- JSON_ARRAY_OVERLAP
- JSON_ARRAY_TRANSFORM
- JSON_ARRAY_APPLY
- JSON_ARRAY_MAP
- JSON_ARRAY_FILTER
- JSON_ARRAY_REDUCE
- JSON_MAP_FILTER
- JSON_MAP_TRANSFORM_KEYS
- JSON_MAP_TRANSFORM_VALUES