My favorite tool is clickhouse-local: https://clickhouse.com/blog/extracting-converting-querying-l...
It is the most powerful (works with any formats, with remote datasets, and supports all the ClickHouse SQL) and the most performant.
It is the most powerful (works with any formats, with remote datasets, and supports all the ClickHouse SQL) and the most performant.
Would be nice to add a seamless ability to call executable UDFs from clickhouse-local, last time I checked clickhouse-local required executables to be in a special directory (as in proper clickhouse). Instead it'd be nice to be able to reference any executable in an ad-hoc way.