Altinity powers evaluation, deployment, and operation of ClickHouse

24/7 Support | Feature Engineering | POCs and Training

Lightning-fast SQL analytics. Any application. Any platform.

ClickHouse: Real-time data warehouse, time series, and log analytics. All in a single fast, portable, open-source and cost-efficient database


Altinity Stable Releases
Alternative Text

Time-to-Market

Deploy in weeks, not years

Scale

10s of petabytes and 100s of users

Economics

Cut analytical costs by 80%

Speed

Reduce query response to milliseconds

Services

Your 24/7 ClickHouse Partner


Altinity helps companies build and maintain systems extracting insight from data at unmatched performance.

ClickHouse 24/7 Support

Deploy confidently with Altinity's support plans and access to highly-skilled ClickHouse experts. Quick response to system problems, bug fixes, answers to questions.
When there are problems, we have your back.
Learn more.

ClickHouse Feature Engineering

Something missing in ClickHouse? Our expert engineering team can implement everything from core ClickHouse features to Kubernetes operator behavior to client library improvements.
Learn more.

ClickHouse PoCs And Training

Move quickly from eval to high quality analytic apps with our ClickHouse proof-of-concept support plans and training packages. Altinity helps you leverage ClickHouse features that make your users happy and gain the edge over competitors.
Learn more.

What our customers say


We've been very impressed by the support from Altinity. It has saved us a number of times. We count on Altinity to help deliver fast, reliable analytics to our users.

Alternative Text
Peter Harper
CTO, AdScribe TV

We feel so fortunate to have found Altinity. We were faced with perplexing challenges with our Clickhouse clusters. The Altinity team helped us navigate through these issues and we now have a more stable, supportable environment. This was a great boost for our product and business as it gave us headroom to scale even further on an optimized configuration.

Alternative Text
Basil Hashem,
VP Product Development, Yotascale

Get a free consultation with an expert!

I want free consultation

Using Joins in ClickHouse Materialized Views

ClickHouse materialized views provide a powerful way to restructure data in ClickHouse. We have discussed their capabilities many times in webinars, blog articles, and conference talks. One of the most common follow-on questions we receive is whether materialized views can support joins.
The answer is emphatically yes. This blog article shows how. If you are looking for a quick answer, here it is: materialized views trigger off the left-most table of the join. The materialized view will pull values from right-side tables in the join but will not trigger if those tables change.

ClickHouse Birthday Altinity Stable Release 20.3.12.112

4 years ago, Alexey Milovidov published “Yandex Opens ClickHouse”, a historic blog post that opened up a new era in analytical databases. Since then we consider June 15 as the birthday of ClickHouse. ClickHouse is our beloved child that grows up and matures very rapidly. Like any normal kid, it has some bad habits and a lot of “character.” We teach it and are happy to see how it progresses. Birthdays are a time for presents. For ClickHouse’s 4th birthday we prepared …

ClickHouse Kafka Engine Tutorial

Our colleague Mikhail Filimonov just published an excellent ClickHouse Kafka Engine FAQ. It provides users with answers to common questions about using stable versions, configuration parameters, standard SQL definitions, and many other topics. Even experienced users are likely to learn something new.
But what if you are getting started and need help setting up Kafka and ClickHouse for the first time? Good news! This article is for you.

ClickHouse Dictionaries, Reloaded!

ClickHouse external dictionaries are a “ClickHouse way” to handle multi-dimensional schema. ClickHouse Dictionaries Explained was the very first article in the Altinity blog three years ago. ClickHouse has improved significantly since then, and dictionaries have achieved a new level of utility. In this article, I will explain two new cool ClickHouse features that completely change the way how dictionaries can be used. Change in a good sense, of course.

Subscribe to our newsletter to get newest updates about ClickHouse technology. Newest blog posts, presentations, software releases, webinars, and more are just one click away!

Subscribe Now

Events

KubeCon and CloudNativeCon – An Online Experience

Altinity is thrilled to be among the presenters and sponsors. Meet us in Amsterdam
The Cloud Native Computing Foundation’s flagship conference gathers adopters and technologists from leading open source and cloud native communities virtually from August 17 – 20, 2020.

August 17 @ 1:00 pm - August 20 @ 2:00 pm

View More…