|
|
|
|
|
|
by linsomniac
1287 days ago
|
|
|
I recently used clickhouse-local to do some log analysis on a lot of elastic load balancer logs (~10s of GBs) and it was spectacular. In short, you can add clickhouse-local to a shell pipeline and then run SQL queries on the data. An example from the docs: $ ps aux | tail -n +2 | awk '{ printf("%s\t%s\n", $1, $4) }'
| clickhouse-local --structure "user String, mem Float64"
--query "SELECT user, round(sum(mem), 2) as memTotal
FROM table GROUP BY user ORDER BY memTotal DESC FORMAT Pretty" |
|
|