Tutorial Presto | 8.8

WITH data AS ( SELECT JSON_PARSE('"name": "Alice", "scores": [95, 87, 92]') AS doc ) SELECT json_extract_scalar(doc, '$.name') AS name, transform(cast(json_extract(doc, '$.scores') AS array(integer)), x -> x + 1) AS adjusted_scores FROM data;

SELECT * FROM system.metadata.table_statistics WHERE catalog_name = 'hive' AND schema_name = 'default' AND table_name = 'sales'; tutorial presto 8.8

Common errors and solutions: