Why DuckDB 2.0 is faster

Automated excerpt

The file is cut into 2268 row groups of about 122,000 rows. Thousands of levels, thousands of full reads of the same table. CREATE TABLE ev AS SELECT json AS payload FROM read_ndjson_objects('events. ndjson'); CREATE TABLE ev AS SELECT json::VARIANT AS payload FROM read_ndjson_objects('events. ndjson'); CREATE TABLE ev AS SELECT * FROM read_json('events. ndjson'); WHERE payload. type::VARCHAR = 'purchase' AND payload. user. country::VARCHAR = 'FR'; SELECT payload. user. country::VARCHAR AS country, sum(payload. props. amount::DOUBLE) AS amount FROM ev WHERE payload. type::VARCHAR = 'purchase' GROUP BY ALL ORDER BY 1; SELECT count(*) FROM ev WHERE list_contains(payload. tags::VARCHAR[], 'c'); JSON stringVARIANT (2.

Selected automatically from source text; not independently written or fact-checked. Read the original for full context.