3
points
zX41ZdbW
Joined 2,429 karma
https://github.com/alexey-milovidov
- zX41ZdbWClickHouse can do it. Examples:
- Let's add Spice to ClickBench: https://benchmark.clickhouse.com/
- I've implemented the same idea a few years ago: https://pastila.nl/
- This is typical for analytical databases, e.g., ClickHouse (which I'm the author of) uses immutable data parts, allowing table cloning: https://clickhouse.com/docs/sql-reference/statements/create/...
- > it breaks when your code goes to a newline. there's no way to keep context line to line...
This is a blocker for my applications.
- I use SQL for music: https://github.com/ClickHouse/NoiSQL
- ClickHouse is a tiny component - a single binary that runs on a laptop.
- 1 point
- 3 points
- 2 points
- Interesting how it compares with the ClickHouse implementation, which uses a lookup table: https://github.com/ClickHouse/ClickHouse/blob/master/src/Com...
So that a day number can be directly mapped to year, month, and day, and the calendar date can be mapped back with a year-month LUT.
- This reminds me of an old bug in simdjson - any usage of it breaks std::unordered_map in unrelated parts of the code due to an unintentional modification of FPU flags: https://github.com/simdjson/simdjson/issues/169
- 2 points
- I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.
- This will be great! One of the things ClickHouse has had since 2016.
- Most likely this one: https://iopscience.iop.org/article/10.1088/1538-3873/acb292/...
- I've edited my profile to provide a link to GitHub.