zX41ZdbW

52 ms·

781.
by zX41ZdbW 4y ago
ClickHouse can export data directly into compressed files, just write SELECT * FROM tutorial.kttm INTO OUTFILE 'data.json.gz' FORMAT JSONEachRow; gz, bz2, xz, zstd, lz4 - all supported.
782.
by zX41ZdbW 5y ago
ClickHouse has support for both of them.
783.
by zX41ZdbW 5y ago
ClickHouse has no longer any ties to Russia.
784.
by zX41ZdbW 5y ago
That's great, but you don't have to finish your PhD. The task is already solved in ClickHouse: https://colab.research.google.com/drive/1pGmfpNdGyzE1KEXDnSS...
785.
by zX41ZdbW 5y ago
It is appeared that clickhouse-local is faster than all of the rest, with a huge margin: https://colab.research.google.com/drive/1pGmfpNdGyzE1KEXDnSS...
786.
ClickHouse 22.3 LTS Released(clickhouse.com)
4 points by zX41ZdbW 5y ago|0 comments
787.
Building a Paste Service with ClickHouse(clickhouse.com)
5 points by zX41ZdbW 5y ago|0 comments
788.
by zX41ZdbW 5y ago
ClickHouse can also run as a query engine for local data, see clickhouse-local.
789.
by zX41ZdbW 5y ago
ClickHouse can do this since maybe a year already: https://clickhouse.com/docs/en/engines/database-engines/sqli...
790.
by zX41ZdbW 5y ago
ClickHouse is not a Russian software. The company is incorporated in the US and have subsidiary in the Netherlands. The development team is distributed, most of the core team is located in the NL and there are employees in Germany, Spain, F
791.
ClickHouse 22.2 Released(clickhouse.com)
11 points by zX41ZdbW 5y ago|0 comments
792.
What's New in ClickHouse 22.1(clickhouse.com)
2 points by zX41ZdbW 5y ago|0 comments
793.
What's New in ClickHouse 22.1(clickhouse.com)
3 points by zX41ZdbW 5y ago|0 comments
794.
What's New in ClickHouse 22.1(clickhouse.com)
3 points by zX41ZdbW 5y ago|0 comments
795.
by zX41ZdbW 5y ago
PS. The task of random dataset generation is surprisingly deep and interesting, I welcome more tools in this area. Already digging into your repository...
796.
by zX41ZdbW 5y ago
Yes, that's true. Although there is an option to run it in a loop over a smaller dataset as a seed.
797.
by zX41ZdbW 5y ago
ClickHouse already has embedded tool for data obfuscation and generation: https://clickhouse.com/docs/en/operations/utilities/clickhou... And here is an article about possible methods to solve this task
798.
by zX41ZdbW 5y ago
Not yet. I will add it to the short list.
799.
by zX41ZdbW 5y ago
> 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.
800.
by zX41ZdbW 5y ago
Here is my favorite: https://github.com/ClickHouse/ClickHouse/blob/master/utils/c... "Too many exclamation marks"
801.
by zX41ZdbW 5y ago
I would consider ClickHouse. It is perfect for interactive analytical queries on large datasets. > the product competes in a geo-spatial market and loads GPS data from a large number of vehicles that are updating every 5-10 seconds There
802.
Decorating a Christmas Tree with the Help of Flaky Tests(clickhouse.com)
2 points by zX41ZdbW 5y ago|0 comments
803.
by zX41ZdbW 5y ago
Example: https://github.com/ClickHouse-Extras/sysroot
804.
by zX41ZdbW 5y ago
They did not actually perform benchmark for ClickHouse, just copy-pasted the results from some old article: https://altinity.com/blog/clickhouse-nails-cost-efficiency-c...
805.
by zX41ZdbW 5y ago
And we have groupArray aggregate function with limit. > I'm not actually aware of any other DBMS that supports `ARRAY_AGG` with `LIMIT`. So, put ClickHouse in you list :)
806.
by zX41ZdbW 5y ago
In ClickHouse we have argMin/argMax aggregate functions. And also LIMIT BY. It looks like this: ... ORDER BY date DESC LIMIT 1 BY user_id
807.
by zX41ZdbW 5y ago
My shameless plug: https://alexey-milovidov.github.io/font-selector/ I've created this small comparison web page for myself and my team.
808.
by zX41ZdbW 5y ago
> The question is: what kind of problems are people needing that want 400GB/s bandwidth on a CPU? Well, probably none frankly. It is needed for analytic databases, e.g. ClickHouse: https://presentations.clickhouse.com&#x2
809.
by zX41ZdbW 5y ago
This is not a concern for ClickHouse. You can load data into MergeTree table that support streaming data ingestion or into Memory table (that is read/write as well). Also you can run queries on the data without any preprocessing (with
810.
by zX41ZdbW 5y ago
We don't require Yandex CLA: > As an alternative, you can provide DCO instead of CLA. You can find the text of DCO here: https://developercertificate.org/ It is enough to read and copy it verbatim to your pull reque

More ›