News for hackers. Stuff that matters.
Re:AWS is not a dumb pipe by glogla on Saturday January 22, 2022 @02:41PM (#30040104)
Oh wow, I missed that. I guess I heard about the CTE somewhere and understood dbt-clickhouse not having ephemeral materialization as CH still not supporting it.

I am still somewhat salty about not being able to do GROUP BY 1, 2, 3 :)

> You are right that ClickHouse requires attention and skills to get the best performance. However, that includes fixed, low-latency use cases like real-time marketing that Snowflake simply does not handle. ClickHouse and Snowflake aren't interchangeable for these use cases.

Yup, that was my point.

Re:AWS is not a dumb pipe by zX41ZdbW on Saturday January 22, 2022 @04:21PM (#30040942)
> GROUP BY 1, 2, 3

It is not ANSI SQL.

Nevertheless, it is already available in ClickHouse as well under `enable_positional_arguments` setting and we are considering making it enabled by default.

Re:AWS is not a dumb pipe by glogla on Sunday January 23, 2022 @05:04AM (#30044992)
Ooooh.

Is there a way to turn unquoted column and table names case insensitive too? Thats like the second biggest annoyance.

Re:AWS is not a dumb pipe by zX41ZdbW on Sunday January 23, 2022 @11:32PM (#30053778)
Not yet. I will add it to the short list.