3 ms·
Absolutely not. For example, there is literally nothing at all in common between a Postgres query and a Clickhouse query except some very basic surface-level sy
by otabdeveloper4 2y ago
Absolutely not.
For example, there is literally nothing at all in common between a Postgres query and a Clickhouse query except some very basic surface-level syntax.
(And even then lots of things are incompatible, e.g., count(*) vs count())
- zX41ZdbW 2y agoYou don't have to write `count()` in ClickHouse - `count(*)` is also ok. ... while `count()` makes more sense from the engineering perspective: it is an aggregate function that takes zero number of arguments. I personally prefer `count()`, but when my friends write `count(*)` or even `COUNT(*)`, they are still my friends.
- hodgesrm 2y agoThe count() invocation is a small but excellent feature in ClickHouse. There are many other great dialect extensions. -If combinators are another great example. [0] SQL would be a better language if there had been more innovation focused on code usability over its long history. [0] https://clickhouse.com/docs/en/sql-reference/aggregate-functions/combinators#-if https://clickhouse.com/docs/en/sql-reference/aggregate-funct...