Hacker News Reader

Comment by zX41ZdbW | Hacker News Reader

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'"

I'm willing to believe that will execute in less than 2 seconds, but it doesn't work as given.

Can 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"