2 ms·
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
by rustc 2y ago
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"
- jeffbee 2y agoIt's a public data file accessible at https://data.acgov.org/datasets/2b026350b5dd40b18ed7a321fdcdba81_0/explore https://data.acgov.org/datasets/2b026350b5dd40b18ed7a321fdcd...