GET_JSON_INT
Extracts an integer value from a JSON object by a specified path.
Analyze Syntax
func.get_json_int(get_column(table, 'data'), '$.age')
Analyze Examples
func.get_json_int(get_column(table, 'data'), '$.age')
┌────┐
│ 30 │
└────┘
SQL Syntax
GET_JSON_INT(<data>, '$.age')
SQL Examples
SELECT GET_JSON_INT('{"age": 30}', '$.age');
┌────┐
│ 30 │
└────┘