MapReduce服务 MRS-Json函数和运算符:JSON转其他类型

时间：2025-02-12 15:03:44

MapReduce服务 MRS

JSON转其他类型

SELECT CAST(JSON 'null' AS VARCHAR);-- NULL  SELECT CAST(JSON '1' AS INTEGER);-- 1  SELECT CAST(JSON '9223372036854775807' AS BIGINT);-- 9223372036854775807  SELECT CAST(JSON '"abc"' AS VARCHAR);-- abc  SELECT CAST(JSON 'true' AS BOOLEAN);-- true  SELECT CAST(JSON '1.234' AS DOUBLE);-- 1.234  SELECT CAST(JSON '[1,23,456]' AS ARRAY(INTEGER));-- [1, 23, 456]  SELECT CAST(JSON '[1,null,456]' AS ARRAY(INTEGER));-- [1, NULL, 456]  SELECT CAST(JSON '[[1,23],[456]]' AS ARRAY(ARRAY(INTEGER)));-- [[1, 23], [456]]  SELECT CAST(JSON '{"k1":1, "k2":23, "k3":456}' AS MAP(VARCHAR, INTEGER));-- {k1=1, k2=23, k3=456}  SELECT CAST(JSON '{"v1":123, "v2":"abc","v3":true}' AS ROW(v1 BIGINT, v2 VARCHAR, v3 BOOLEAN));-- {v1=123, v2=abc, v3=true}  SELECT CAST(JSON '[123, "abc",true]' AS ROW(v1 BIGINT, v2 VARCHAR, v3 BOOLEAN));-- {value1=123, value2=abc, value3=true}  SELECT CAST(JSON'[[1, 23], 456]'AS ARRAY(JSON));-- [JSON '[1,23]', JSON '456']  SELECT CAST(JSON'{"k1": [1, 23], "k2": 456}'AS MAP(VARCHAR,JSON));-- {k1 = JSON '[1,23]', k2 = JSON '456'}  SELECT CAST(JSON'[null]'AS ARRAY(JSON));-- [JSON 'null']

上一篇：MapReduce服务 MRS-Json函数和运算符:JSON函数

下一篇：MapReduce服务 MRS-数组函数和运算符:Concatenation Operator : ||