zX41ZdbW

18 ms·

271.
by zX41ZdbW 2y ago
I have a presentation on this topic. https://presentations.clickhouse.com/meetup107/app/ Starting from slide 19, "How is it possible," explains why we need such a parody.
272.
by zX41ZdbW 2y ago
This is a good article! In ClickHouse, interval arithmetic is applied to index analysis. A sparse index consists of granules, and each granule is an interval of tuples in lexicographic order. This interval is decomposed into a union of hype
273.
by zX41ZdbW 2y ago
Daily is too infrequently. I have this dataset being updated in ClickHouse in real time: https://play.clickhouse.com/play?user=play#U0VMRUNUIG1heCh0a... I also provide a way to export it or attach it to clickhouse-local and
274.
by zX41ZdbW 2y ago
Round rectangles can look not round enough on low-DPI displays, and the colors can also be wrong due to incorrect averaging in non-linear color space. Example: https://github.com/ClickHouse/ClickHouse/pull/334
275.
by zX41ZdbW 2y ago
I have tested Rockset for competitive analysis. Good parts: It has a slick and nice-looking UI. Good documentation. Many data loading options (including S3). SQL support is good (Calcite?). Types are inferred on data loading. But you have t
276.
by zX41ZdbW 2y ago
https://github.com/google/oss-fuzz-gen
277.
by zX41ZdbW 2y ago
Thank you, that's interesting. A small feedback about the website - it uses the "Space Mono" font for the installation snippet - it is a monospace font, but surprisingly, it collapses "fi" into a ligature, making th
278.
by zX41ZdbW 2y ago
It does not work. AggregatedDataVariants - no matches ClearableHashMap - no matches Volnitsky - didn't find usages in ClickHouse The search speed is not impressive - it takes a few seconds to answer a query.
279.
by zX41ZdbW 2y ago
I often do it with ClickHouse, which has HTTP API included in the database server. For example, https://play.clickhouse.com/ is an open public playground, and https://adsb.exposed/ is a full-featured applic
280.
by zX41ZdbW 2y ago
Thank you. I didn't hear about dblab before. Added a bug fix: https://github.com/danvergara/dblab/pull/206 and a feature request: https://github.com/danvergara/dblab/issues&#x2F
281.
by zX41ZdbW 2y ago
I did a similar project before, https://adsb.exposed/ . It does not need a GPU database, it analyzes 70 billion traces in real-time, and is trivial to implement.
282.
by zX41ZdbW 2y ago
This looks surprisingly similar to my project, https://github.com/ClickHouse/adsb.exposed/ , but more complex and less performant.
283.
by zX41ZdbW 2y ago
This looks similar to my project https://github.com/ClickHouse/adsb.exposed/ , which allows us to analyze this data in real-time and is much simpler and elegant.
284.
by zX41ZdbW 2y ago
Zooming with the mouse wheel does not work.
285.
by zX41ZdbW 2y ago
It's better because it minimizes the UI. You get the same experience as in the text editor, such as Notepad or Kate, with no fluff.
286.
by zX41ZdbW 2y ago
I did almost the same project, but better, two years ago: https://pastila.nl/ https://github.com/ClickHouse/pastila
287.
by zX41ZdbW 2y ago
You 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
288.
by zX41ZdbW 2y ago
Not only Snowflake: https://play.clickhouse.com/play?user=play#U0VMRUNUIAogIDEsC...
289.
by zX41ZdbW 2y ago
Fully agree. Comments are a must. But not like these: if (!n) { /* uh, oh, warn */ return UNDEF;
290.
by zX41ZdbW 2y ago
My point is near the opposite. Data formats should apply lightweight compression, such as lz4, by default because it could be beneficial even if the data is read from RAM. I have made a presentation about it: https://presentation
291.
by zX41ZdbW 2y ago
Asynchronous INSERTs are available in the open-source ClickHouse version and in ClickHouse Cloud. The feature is independent of the Cloud. To enable asynchronous INSERTs, set `async_insert` to true. Here is the documentation: https:/&
292.
by zX41ZdbW 2y ago
I've made a library named "glibc-compatibility": https://github.com/ClickHouse/ClickHouse/tree/master/base/gl... When linking with this library before glibc, the resulting binary will
293.
by zX41ZdbW 2y ago
Done, and now it works perfectly.
294.
by zX41ZdbW 2y ago
The reason is trivial - I disabled the new feature flag on the playground service long ago (when it was in development). I will enable it back and send an example.
295.
by zX41ZdbW 2y ago
I have a somewhat negative experience with Kona and its derivatives Kerf and Kerf2. For example, among Kerf and Kerf2: - there is no explanation about why two versions exist; - the code does not build; - it has memory leaks; - both are aban
296.
by zX41ZdbW 2y ago
This is unclear to me, I will ask the author.
297.
by zX41ZdbW 2y ago
It makes many requests in parallel, and that's why some of them could be retried. It logs every retry, e.g., "Failed at try 3/10". It will throw an error only if it fails all ten tries. The number of retries is defined i
298.
by zX41ZdbW 2y ago
Sorry for distracting you. My apologies. I will try to remember your login and not answer your comments in the future. At the same time, it is possible that I will occasionally answer your comments by mistake. Cheers, Alexey.
299.
by zX41ZdbW 2y ago
Is it possible to pull historical data out of Snowflake? If it is an option - you can place it in ClickHouse and use a materialized view to JOIN with the historical table during insertion into the real-time table.
300.
by zX41ZdbW 2y ago
Also, a proof that it is updated in real-time: https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT...

More ›