presto で JSON データを扱う

code:presto.sql

SELECT

CAST(JSON_EXTRACT_SCALAR(JSON_PARSE(data), '$.hoge') AS INT)