3 ms·
ClickHouse will be faster for processing large JSON data files. The example from the gist will look like follows: ch -q "WITH arrayJoin(features) AS f SELE
by zX41ZdbW 2y ago
ClickHouse will be faster for processing large JSON data files. The example from the gist will look like follows:
ch -q "WITH arrayJoin(features) AS f SELECT f.properties.SitusCity WHERE f.properties.TotalNetValue < 193000 FROM 'data.json'"
Reference: https://jsonbench.com/ https://jsonbench.com/
- jeffbee 2y agoI'm willing to believe that will execute in less than 2 seconds, but it doesn't work as given.
- rustc 2y agoCan you post a link to the JSON file? Try this (the placement of FROM was incorrect): ch "WITH arrayJoin(features) AS f SELECT f.properties.SitusCity FROM 'a.json' WHERE f.properties.TotalNetValue < 193000"
- jeffbee 2y agoIt's a public data file accessible at https://data.acgov.org/datasets/2b026350b5dd40b18ed7a321fdcdba81_0/explore https://data.acgov.org/datasets/2b026350b5dd40b18ed7a321fdcd...