Viewing profile — richraposa

...says the completely anonymous internet guy. I'm laughing as much as you are. I wasn't trying to imply anything negative about DuckDB with my post - was just sharing how ClickHou…

ClickHouse just reads the values from the one column being summed: https://www.markhneedham.com/blog/2023/11/15/clickhouse-summ...

Nice. I did the same thing on ClickHouse - took 11 seconds: SELECT sum(size) FROM url('https://huggingface.co/datasets/vivym/midjourney-messages/resolve/main/data/0000{01..55}.parq…

CGW = Can't Go Wrong...love it

ClickHouse 10 years before DuckDB existed: SELECT * FROM url(' https://example.com/*.csv ')

I suppose if you had data in a format that DuckDb doesn't work with, like Protobuf, Avro, ORC, Arrow, etc. ClickHouse reads and writes data in over 70 formats

ingestion of these events during peaks at 500k events per minute. You can't ingest them individually into Clickhouse or most other databases. Turn on async_insert or use a Buffer t…

Cloudflare famously uses ClickHouse for web analytics - inserting over 6M rows per second: https://blog.cloudflare.com/http-analytics-for-6m-requests-p...

It's definitely cool to be able to query data in place instead of inserting it into a table. You can use clickhouse-local to do the same thing with JSON files (and with dozens of o…

You should try it on ClickHouse Cloud - the pricing is not based on bytes, so the resulting cost would be near zero compared to $1M on BigQuery. And it would probably execute faste…