avogar

8 ms·

1. 1.▲
   by avogar 4y ago

   clickhouse-local is a really good tool for analyzing local data, as it supports a wide range of data formats and it's really fast. It can save you a lot of time, because there is no need to install a batch of packages to use it or setu
2. 2.▲
   by avogar 4y ago

   SPyQL looks very promising, great work! I can't help but mention clickhouse-local tool: https://clickhouse.com/docs/en/operations/utilities/clickhou... clickhouse-local is a single binary that enabl
3. 3.▲
   by avogar 4y ago

   Using ClickHouse you can also process local files in one line using clickhouse-local command tool. And it will look a lot easier: clickhouse local -q "SELECT passenger_count, COUNT(*), AVG(total_amount) FROM file(taxi.csv, 'CSVWit