JSON

JSON_TYPE

DuckDB

Mengembalikan tipe dari nilai JSON (object, array, string, number, boolean, null).

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

JSON_TYPE(json [, path])

Parameter

jsonJSON/VARCHARwajib

Data JSON

pathVARCHARopsional

Opsional. Path ke nilai yang ingin dicek tipenya

Contoh Penggunaan

Cek Tipe JSON

SQL

1 SELECT
2   JSON_TYPE('{"name": "John"}') as obj_type,
3   JSON_TYPE('[1, 2, 3]') as array_type,
4   JSON_TYPE('"hello"') as string_type,
5   JSON_TYPE('123') as number_type;

Menentukan tipe dari berbagai JSON.

Hasil

obj_type	array_type	string_type	number_type
OBJECT	ARRAY	VARCHAR	BIGINT

Cek Tipe Nested Value

SQL

1 SELECT JSON_TYPE('{"data": [1,2,3]}', '$.data');

Cek tipe nilai pada path tertentu.

Hasil

ARRAY

Conditional Berdasarkan Tipe

SQL

1 SELECT
2   id,
3   CASE JSON_TYPE(value, '$.amount')
4     WHEN 'BIGINT' THEN 'integer'
5     WHEN 'DOUBLE' THEN 'decimal'
6     ELSE 'unknown'
7   END as amount_type
8 FROM transactions;

Menggunakan JSON_TYPE untuk conditional logic.

Fungsi Equivalen di Database Lain

JSON_TYPEOF

PostgreSQL

JSON_TYPE

MySQL

TYPEOF

Snowflake

JSON_TYPE

BigQuery

Fungsi Terkait

TYPEOFJSON_ARRAY_LENGTHJSON_KEYS

Kembali ke DuckDB Functions

1	SELECT
2	JSON_TYPE('{"name": "John"}') as obj_type,
3	JSON_TYPE('[1, 2, 3]') as array_type,
4	JSON_TYPE('"hello"') as string_type,
5	JSON_TYPE('123') as number_type;

1	SELECT
2	id,
3	CASE JSON_TYPE(value, '$.amount')
4	WHEN 'BIGINT' THEN 'integer'
5	WHEN 'DOUBLE' THEN 'decimal'
6	ELSE 'unknown'
7	END as amount_type
8	FROM transactions;