- "The world’s fastest tool for querying JSON files" https://clickhouse.com/blog/worlds-fastest-json-querying-too...
- "Show HN: ClickHouse-local – a small tool for serverless data analytics" https://news.ycombinator.com/item?id=34265206
clickhouse local -q "SELECT foo, sum(bar) FROM file('foobar.csv', CSV) GROUP BY foo FORMAT Pretty"
Here's a list of the different input and output formats that it supports.
select * from `foobar.csv`
select * from `monthly-report-*.csv` $ function _select_aux () { clickhouse local -q "SELECT $* FORMAT Pretty" }
$ alias SELECT='noglob _select_aux'
$ SELECT COUNT(*) as count FROM file('repos.json', JSON)
┏━━━━━━━┓
┃ count ┃
┡━━━━━━━┩
│ 30 │
└───────┘