Steal This Knowledge Base

Steal This Knowledge Base

When we created the first version of the Altinity Knowledge Base, we created a site where we could share our ClickHouse knowledge with the ClickHouse community, whether they are an Altinity customer or not. We originally built the system using Gitbook, which let Altinity staff get in, make a change, and publish it.  But from the start we had a desire to share this knowledge base with everyone.  Keep reading to see how we will continue to expand the Knowledge Base across the ClickHouse community.

SigNoz and ClickHouse Zookeeper Replacement — August SF Bay Area Meetup

SigNoz and ClickHouse Zookeeper Replacement — August SF Bay Area Meetup

The August 2021 ClickHouse SF Bay Area meetup featured two excellent talks on our favorite database. SigNoz and Yandex explored observability and Zookeeper replacement followed by many questions. Eliminating Zookeeper is a long-awaited improvement, and the talk is the first time it has been publicly presented. Check out event replays and details here.

Announcing OSA Con: The Open Source Analytics Conference

Announcing OSA Con: The Open Source Analytics Conference

Altinity is excited to announce OSA Con, a new conference on open source analytics. We will bring together developers of open source analytic projects with developers who use open source in analytic applications. OSA Con will take place online on November 2nd, 2021. It’s free. Here are a few of the topics OSA Con will[…]

Delivering Insight on GraphQL APIs with ClickHouse at GraphCDN
·

Delivering Insight on GraphQL APIs with ClickHouse at GraphCDN

Scaling public API response is a major headache for SaaS application developers. GraphCDN has an innovative solution for GraphQL, a popular species of web service API. They offer a flexible content delivery network (CDN) that can deliver API responses to clients up to 200x faster while reducing load on backend services–all without code changes. It’s an innovative twist on scaling. 

A New Way to Restore ClickHouse After ZooKeeper Metadata Is Lost

A New Way to Restore ClickHouse After ZooKeeper Metadata Is Lost

Every ClickHouse user has experienced data loss due to user error or operational failure with Zookeeper at least once in their lifetime. If a failure resulted in metadata loss, ClickHouse tables can turn into pumpkins–you can query but you cannot insert more data. But as of ClickHouse version 21.7, this has changed with a new SQL Command. Keep reading to learn more.

Fun with ClickHouse Window Functions

Fun with ClickHouse Window Functions

Window functions have arrived in ClickHouse! Our webinar will start with an introduction to standard window function syntax and show how it is implemented in ClickHouse. We’ll next show you problems that you can now solve easily using window functions. Finally, we’ll compare window functions to arrays, another powerful ClickHouse feature.

Fun with ClickHouse Window Functions

Fun with ClickHouse Window Functions

Window functions have arrived in ClickHouse! Our webinar will start with an introduction to standard window function syntax and show how it is implemented in ClickHouse. We’ll next show you problems that you can now solve easily using window functions. Finally, we’ll compare window functions to arrays, another powerful ClickHouse feature.

Tableau Tricks with ClickHouse

Tableau Tricks with ClickHouse

With the announcement of the Altinity Tableau Connector for ClickHouse, we wanted to take the opportunity to show off some handy Tableau tips and tricks for making some very cool charts based off of ClickHouse data.

We know that setting up your own ClickHouse test server with sample data can take a little time and storage, so we’re saving you all of that by providing a free demo ClickHouse cluster hosted on Altinity.Cloud.

Tips for High-Performance ClickHouse Clusters with S3 Object Storage

Tips for High-Performance ClickHouse Clusters with S3 Object Storage

ClickHouse often runs in a cluster, and cluster operation poses some interesting questions regarding S3 usage. They include parallelizing data load across nodes, benefits of horizontal vs. vertical scaling, and avoiding unnecessary replication. In this article, we will discuss how ClickHouse clusters can be used with S3 efficiently thanks to two important new features: the ‘s3Cluster‘ table function and zero-copy replication.

ClickHouse at LifeStreet: Performance Marketing is as Strong as Your Data Platform
·

ClickHouse at LifeStreet: Performance Marketing is as Strong as Your Data Platform

We live in a rapidly changing world. The ability to discover and apply business-critical insights from petabyte datasets in real-time is now a key factor in many businesses. Digital marketing is no exception. In fact, digital marketing is now one of the major sources of Big Data. In this article, we will explain how ClickHouse is used by the digital marketing company LifeStreet.