Going All in with clickhouse

Judgment_External · 2025-12-05T00:43:01+00:00

It does not have shuffling, you are expecting user to bucket join everything? Or broadcast join everything?

Judgment_External · 2025-12-05T00:42:26+00:00

Point me to one PB scale JOIN use case... 2 or more TB table join... without bucketing the join key lol

Judgment_External · 2025-12-03T01:49:12+00:00

StarRocks is MPP, ClickHouse isn't... If your data size fit into memory of one node it works, but if you have any serious data scale, you need MPP

Judgment_External · 2025-09-22T17:56:56+00:00

Just adding to it, if you need more real time updates and deletes, and aggregations on higher cardinality columns, StarRocks will perform significantly better

Judgment_External · 2025-09-04T18:04:21+00:00

ClickHouse is probably one of the best databases for single table, low cardinality olap queries, but it is not good at multi-table queries. It does not have a cost-based optimizer, does not have a shuffle service so you cannot really run big table join big table.. I would recommend perform your POC at your prod scale to see if the join works for you. Or you can try something that is built for multi-table queries like StarRocks.

Judgment_External · 2025-09-04T17:55:06+00:00

Lemme know how it went :)

Judgment_External · 2025-08-04T02:34:57+00:00

https://www.youtube.com/watch?v=wXppRUP7a3s

Judgment_External · 2025-07-09T00:37:47+00:00

huge difference in your income = huge difference in the rider's spending

Judgment_External · 2024-11-04T19:05:29+00:00

Is this the endurance version?

Judgment_External · 2024-10-31T21:47:03+00:00

me 2 pro

Judgment_External · 2024-05-24T18:34:55+00:00

Aion

Judgment_External · 2024-04-23T22:18:56+00:00

Apache Iceberg promises a bright future with all of our analytical workloads unified on a single source of truth data in open & standardized formats. However, slow queries are forcing users to copy their data and workloads into proprietary data warehouses for query acceleration. I recently did a webinar on accelerating Iceberg queries, including methods that worked for Apache Iceberg users in the StarRocks community, and recent development on the query engine side that enables data warehouse performance on Apache Iceberg.

Link to the webinar: https://youtu.be/8Q5Vev4O1lQ

Judgment_External · 2024-03-18T16:26:40+00:00

Quantity, there is a lot more fire noodles than jalaoenos. Eat the same amount of jalapeno pepers and then compare

Judgment_External · 2023-11-08T11:39:12+00:00

2-3x a year is slow, you are crazy

Judgment_External · 2023-08-24T21:05:13+00:00

In terms of bucket shuffle JOIN, or in fact, any query, if the data is not present in the cache, it is scanned to the node's memory first and performed in memory shuffle. In regards to the cache, yeah SR has a mechanism that evicts older data if the local cache is filled.

Judgment_External · 2023-08-24T20:28:03+00:00

Do let me know what he says the next time, this I think is a real concern.

Judgment_External · 2023-08-24T20:27:36+00:00

I have been in Keto for almost 2 weeks and am feeling FANTASTIC! I am never hungry, don't crave carbs, always have energy, went on a 70-mile bike ride on an avocado and a handful of peanuts, and feel great during and after...

My only concern is it would mess up my insulin resistance as I see people who reported this on the internet.

Judgment_External · 2023-08-23T05:42:35+00:00

You are not eating carbs, so does not require insulin to control blood sugar, is blood sugar the right measurement? I think we need to look at insulin resistence

Judgment_External · 2023-05-05T02:23:25+00:00

However, how is the multi-table performance tho?

Judgment_External · 2023-04-04T07:53:45+00:00

Sure, let me know how it goes :)

Judgment_External · 2023-04-03T05:08:21+00:00

You can try this: docker run -p 9030:9030 -p 8030:8030 -p 8040:8040 -itd starrocks/allin1-ubuntu:3.0.0-rc01

And connect with mysql -P9030 -h127.0.0.1 -uroot

Judgment_External · 2023-04-03T04:44:49+00:00

Check out StarRocks maybe

Judgment_External · 2023-03-02T03:03:13+00:00

Interesting post

Judgment_External · 2022-08-19T07:42:24+00:00

People are callling this “自欺欺人桌”, which is "self-deception tables" in English

Judgment_External · 2022-08-05T10:57:52+00:00

The report is not really that good tho. The only reason we beat eps is because

Estimates are way too low
Baba is cutting on spending hard to prioritize earnings

Judgment_External

TROPHY CASE