Feb 12, 2018
There are multiple ways how ClickHouse and MySQL can work together. External Dictionaries, ProxySQL support or [realtime streaming] of MySQL binary logs into ClickHouse. A few weeks ago ClickHouse team has released mysql() table function that allows to access MySQL data directly from ClickHouse. This opens up a number of interesting capabilities. Accidentally we have found [a blog article in Japanese] by Mikage Sawatari , that tests a new way of integration and translated it for our blog with some minor edits.
Feb 12, 2018
Jan 18, 2018
ClickHouse is very flexible and can be used for various use cases. One of the most interesting technology areas now is machine learning, and ClickHouse fits nicely there as very fast datasource. A few months ago ClickHouse team implemented the support for ML algorithms, that makes it much easier and faster to run ML over ClickHouse data. They started with open source Yandex CatBoost algorithm, but it can be extended with other algorithms in the future. In this article, we posted a tutorial on how ClickHouse can be used to run CatBoost models.
Dec 6, 2017
Christian Hotz-Behofsits, Teaching & Research Associate at Vienna University of Business and Economics, is one of the creators of RClickhouse package for R that we have recently introduced on our blog. In this article he describes data analysis challenges his group is facing and how ClickHouse helps in their research.
Nov 27, 2017
In this tutorial, our guest blogger Yegor Andreenko (@f1yegor) is talking about The ClickHouse Primary keys.
- How many columns could primary key have? And what is a layout of data on storage drive? Are there any theoretical/practical limits?
- Could columns with missing data at some rows be part of the primary key?
Oct 5, 2017
In this blog, I'll use ClickHouse and Tabix to look at a new very large dataset for research.
It is an interesting dataset I found recently that has been available since 2015. This is Reddit's comments and submissions dataset, made possible thanks to Reddit's generous API.Read More