4 ms·
clickhouse-local[1] saved me countless hours. I'm using it for format conversion, data processing, querying external data, as a calculator, etc... clickhous
by zX41ZdbW 4y ago
clickhouse-local[1] saved me countless hours.
I'm using it for format conversion, data processing, querying external data, as a calculator, etc...
clickhouse-local --input-format Parquet --output-format JSONEachRow --query "SELECT * FROM table" < data.parquet > data.jsonl
cat books.ndjson | clickhouse-local --query "SELECT author, avg(rating) FROM table GROUP BY author"
clickhouse-local --query "SELECT * FROM url('https://datasets.clickhouse.com/hackernews.native.zst') LIMIT 10"
$ clickhouse-local
ClickHouse local version 22.13.1.1.
milovidov-desktop :) SELECT extractTextFromHTML(*) FROM url('https://news.ycombinator.com/', RawBLOB)
[1]: https://clickhouse.com/docs/en/operations/utilities/clickhouse-local/ https://clickhouse.com/docs/en/operations/utilities/clickhou...