clickhouse_ClickHouse：一年！

clickhouse

It’s been a year already since the Yandex team released ClickHouse as open source software. I’ve had an interest in this project from the very start, as I didn’t think there was an open source analytical database that could compete with industry leaders like Vertica (for example).

自Yandex团队将ClickHouse作为开源软件发布以来已经一年了。 我从一开始就对这个项目感兴趣，因为我认为没有一个开源的分析数据库可以与Vertica这样的行业领导者竞争。

This was an exciting year for ClickHouse early adopters. Let’s look at what it accomplished so far.

对于ClickHouse的早期采用者来说，这是令人兴奋的一年。 让我们看一下到目前为止所取得的成就。

ClickHouse initially generated interest due to the Yandex name – the most popular search engine in Russia. It wasn’t long before jaw-dropping responses popped up: guys, this thing is crazy fast! Many early adopters who tried ClickHouse were really impressed.

ClickHouse最初因Yandex名称-俄罗斯最受欢迎的搜索引擎而引起了人们的兴趣。 不久之后，令人叹为观止的React突然出现：伙计们，这件事太疯狂了！ 尝试ClickHouse的许多早期采用者确实印象深刻。

Fast doesn’t mean convenient though. That was the main community concern to ClickHouse over the past months. Developed as an internal project for an internal customer (Yandex.Metrica), ClickHouse had a lot of limitations for general community use. It took several months before Yandex could restructure the team and mindset, establish proper communication with the community and start addressing external needs. There are still a lot of things that need to be done. The public roadmap is not easily available, for example, but the wheels are pointed in the right direction. The ClickHouse team has added a lot of the features people were screaming for, and more are in ClickHouse’s future plans.

快速并不意味着方便。 在过去的几个月中，这是ClickHouse对社区的主要关注。 ClickHouse作为内部客户（Yandex.Metrica）的内部项目而开发，对于一般社区的使用有很多限制。 Yandex花了几个月的时间才能重组团队和思维定势，与社区建立适当的沟通并开始满足外部需求。 还有很多事情要做。 例如，公开路线图不容易获得，但是方向盘指向正确的方向。 ClickHouse团队增加了人们所渴望的许多功能，并且在ClickHouse的未来计划中还有更多功能。

The Yandex guys are actively attending international conferences, and they were:

Yandex团队正在积极参加国际会议，他们分别是：

• Welcomed speakers at Percona Live Amsterdam 2016 (https://www.percona.com/live/plam16/sites/default/files/slides/ClickHouse%20Percona%20Live%20v2.9.pdf)
  2016年阿姆斯特丹Percona Live上的演讲嘉宾（ https://www.percona.com/live/plam16/sites/default/files/slides/ClickHouse%20Percona%20Live%20v2.9.pdf ）
• At Percona Live 2017 (https://www.percona.com/live/17/sessions/clickhouse-high-performance-distributed-dbms-analytics, https://www.percona.com/live/17/sessions/clickhouse-time-series-storage-graphite),
  在现场的Percona 2017年（ https://www.percona.com/live/17/sessions/clickhouse-high-performance-distributed-dbms-analytics ， https://www.percona.com/live/17/sessions/clickhouse时间序列存储石墨 ），
• Recently at Date@Scale in Seatle (https://atscaleconference.com/videos/yandex-clickhouse-a-dbms-for-interactive-analytics-at-scale/).
  最近在Seatle的Date @ Scale（ https://atscaleconference.com/videos/yandex-clickhouse-a-dbms-for-interactive-analytics-at-scale/ ）。

They are speaking much more in Russia (no big surprise).

他们在俄罗斯的发言要多得多（不足为奇）。

We were very excited by Yandex’s ClickHouse performance claims at Percona, and could not resist making our own benchmarks:

Yandex在Percona上提出的ClickHouse性能要求令我们感到非常兴奋，并且无法抗拒制定自己的基准测试：

• ClickHouse: New Open Source Columnar Database
  ClickHouse：新的开源列式数据库
• Column Store Database Benchmarks: MariaDB ColumnStore vs. ClickHouse vs. Apache Spark
  列存储数据库基准测试：MariaDB列存储vs. ClickHouse与Apache Spark
• ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)
  常规分析工作量中的ClickHouse（基于星型模式基准）

ClickHouse did very well in these benchmarks. There are many other benchmarks by other groups as well, including a benchmark against Amazon RedShift by Altinity.

ClickHouse在这些基准测试中表现出色。 其他小组也有许多其他基准，包括针对Altinity的Amazon RedShift的基准 。

The first ClickHouse production deployments outside of Yandex started in October-November 2016. Today, Yandex reports that dozens of companies around the world are using ClickHouse in production, with the biggest installations operating with up to several petabytes of data. Hundreds of other enterprises are deploying pilot installations or actively evaluating the software.

Yandex之外的第一个ClickHouse生产部署于2016年10月至11月开始。今天，Yandex报道说，全球有数十家公司在生产中使用ClickHouse，最大的安装可处理多达PB的数据。 数以百计的其他企业正在部署试验性安装或积极评估软件。

There are also interesting reports from CloudFare (How Cloudflare analyzes 1M DNS queries per second) and from Carto (Geospatial processing with ClickHouse).

CloudFare（ Cloudflare如何每秒分析1M DNS查询 ）和Carto（ 使用ClickHouse进行地理空间处理 ）也提供了有趣的报告。

There are also various community projects around ClickHouse worth mentioning:

ClickHouse周围还有许多社区项目值得一提：

• Tabix, Web GUI for ClickHouse: https://github.com/smi2/tabix.ui
  Tabix，ClickHouse的Web GUI： https ： //github.com/smi2/tabix.ui
• SQLAlchemy integration from CloudFare: https://github.com/cloudflare/sqlalchemy-clickhouse
  来自CloudFareSQLAlchemy集成： https : //github.com/cloudflare/sqlalchemy-clickhouse
• Support for Superset, a data exploration platform, from AirBnB
  对AirBnB的数据浏览平台Superset的支持

Perconais also working to adapt ClickHouse to our projects. We are using ClickHouse to handle Query Analytics and as a long term metrics data for Metrics inside a new version (under development) of Percona Monitoring and Management.

Percona还在努力使ClickHouse适应我们的项目。 我们正在使用ClickHouse处理查询分析以及作为Percona Monitoring and Management新版本（开发中）中的指标的长期指标数据。

Vadim Tkachenko will also be speaking about ClickHouse at BIG DATA DAY LA 2017 on August 5th, 2017. You are welcome to attend if you are in Los Angeles this day!

瓦迪姆·特卡琴科（Vadim Tkachenko）还将在2017年8月5 日举行的BIG DATA DAY LA 2017上谈论ClickHouse。如果您今天在洛杉矶，欢迎您参加！

ClickHouse has the potential to become one of the leading open source analytical DBMSs – much like MySQL and PostreSQL are leaders for OLTP workloads. We will see in the next couple of years if it happens or not. Congratulations to the Yandex team on their one-year milestone!

ClickHouse有潜力成为领先的开源分析DBMS之一-就像MySQL和PostreSQL是OLTP工作负载的领导者一样。 我们将在未来几年中查看是否会发生。 祝贺Yandex团队一年的里程碑！

翻译自: https://www.experts-exchange.com/articles/30700/ClickHouse-One-Year.html

clickhouse