Machine Learning Models as Tables
Guest post from Zoran Pandovski at MindsDB Editor’s Note. The MindsDB team has come up with a creative way to integrate machine learning models with ClickHouse. We’re delighted to share it on the Altinity Blog.[…]
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
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
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.
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.
Basil Hashem,
VP Product Development, Yotascale
Get a free consultation with an expert!
I want free consultationUsing 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.
Reducing Clickhouse Storage Cost with the LowCardinality Type – Lessons from an Instana Engineer
At Instana we are operating our Clickhouse clusters on m5.12xlarge AWS EC2 instances and similar sized custom build Google Cloud instances. The biggest cost driver however is not the size of the instance, but the EBS volumes / persistent SSDs that are attached to the instances. Every single one of our 12TB volumes costs $1320 per month in AWS and $2,040 per month in Google Cloud.
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!
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
