Hacker News Reader

Comment by jeffbee | Hacker News Reader

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"