Angaben zum Datum
Datum aus der Quelle.
Erstmals gesehen am .
Developer Platform von Cloudflare
R2 SQL: JSON-Funktionen, EXPLAIN FORMAT JSON und unpartitionierte Tabellen
R2 SQL unterstützt jetzt JSON-Funktionen für Iceberg-Tabellen, die Ausgabe von Abfrageplänen per EXPLAIN FORMAT JSON sowie Abfragen auf Tabellen ohne Partitionsschlüssel.
R2 SQL is Cloudflare's serverless, distributed, analytics query engine for querying Apache Iceberg ↗︎ tables stored in R2 Data Catalog.
R2 SQL now supports functions for querying JSON data stored in Apache Iceberg tables, an easier way to parse query plans with EXPLAIN FORMAT JSON, and querying tables without partition keys stored in R2 Data Catalog.
JSON functions extract and manipulate JSON values directly in SQL without client-side processing:
SELECT
json_get_str(doc, 'name') AS name,
json_get_int(doc, 'user', 'profile', 'level') AS level,
json_get_bool(doc, 'active') AS is_active
FROM my_namespace.sales_data
WHERE json_contains(doc, 'email')
For a full list of available functions, refer to JSON functions.
EXPLAIN FORMAT JSON returns query execution plans as structured JSON for programmatic analysis and observability integrations:
npx wrangler r2 sql query "${WAREHOUSE}" "EXPLAIN FORMAT JSON SELECT * FROM logpush.requests LIMIT 10;"
┌──────────────────────────────────────┐
│ plan │
├──────────────────────────────────────┤
│ { │
│ "name": "CoalescePartitionsExec", │ …