How does it compare with duckdb, which I usualy resort to?
What I like with duckdb is that it's a single binary, no server needed, and it's been happy so far with all the CSV file I've thrown at it.
clickhouse local
ClickHouse local version 25.4.1.1143 (official build).
:)
clickhouse local --query "SELECT count() FROM file('top-1m-2018-01-10.csv.zip :: *.csv')"
1000000
Debian package is of poor quality: not even sure if clickhouse local is included in there, I believe so but there is no manpage, no doc at all, and no `clickhouse-server -h`.
Went to the official page looking for a tarball to download, found only the `curl|sh` joke.
Went to github looking for tagged tarballs, couldn't find any. Looked for INSTALL.md, couldn't find any.
Will try harder later, have to weep my tears for now.
Can you elaborate more please? I would love if you can say what all can be improved to make debian package up to standards.
My comment was really about the state of documentation ("there is no manpage, no doc at all, and no `clickhouse-server -h`"). More specifically:
% dpkg -S clickhouse-server | grep bin
clickhouse-server: /usr/sbin/clickhouse-server
% man clickhouse-server
No manual entry for clickhouse-server
% man clickhouse
No manual entry for clickhouse
% /usr/sbin/clickhouse-server --help
Unknown option specified: help
% /usr/sbin/clickhouse-server -h
Unknown option specified: h
% ls -l /usr/share/doc/clickhouse-server
total 60
-rw-r--r-- 1 root root 235 Dec 5 2022 changelog.Debian.amd64.gz
-rw-r--r-- 1 root root 1437 Dec 5 2022 changelog.Debian.gz
-rw-r--r-- 1 root root 33174 Dec 20 2018 changelog.gz
-rw-r--r-- 1 root root 15057 Oct 29 2022 copyrightThis binary is packaged inside .deb, .rpm, and .tgz, and it is also available for direct download. The curl|sh script selects the platform (x86_64, aarch64 x Linux, Mac, FreeBSD) and downloads the appropriate binary.