Skip to content

SLS

Main Navigation

SQL Analysis Case

Metricstore query cases

Data access cases

Data transformation cases

Open source compatibility

CloudLen cases

Demos for intelligent O&M cases

Synchronizes index configurations

Synchronizes a scheduled SQL task

Updates multiple scheduled SQL tasks

Playground

Console

Others

English

English

Appearance

Sidebar Navigation

Overview of SQL Functions

Function Overview

SQL syntax

group by

order by

case when and if

having

join

nested subquery

unnest

Functions

General comparison functions

General aggregate functions

Date and time functions

String functions

JSON functions

Array functions

Map functions

Regular expression functions

URL functions

Mathematical calculation functions

Approximate functions

Interval-valued comparison functions and periodicity-valued comparison functions

Window functions

Bitwise functions

Geospatial functions

IP geolocation functions

Security check functions

Mobile number functions

Time series clustering functions

Smooth functions

On this page

Table of Contents for current page

Convert a string to the JSON format

SQL

* |
select
  json_parse('[1, 2, 3]')

Edit this page on GitHub

Last Modified:

Next pageFunction Overview

Convert a string to the JSON format ​

Convert a string to the JSON format