PinnedClickHouse is Apache 2.0: Altinity’s Commitment to Open Source LicensingOpen source licenses are in the news again. Elastic recently changed the licensing for ElasticSearch and Kibana from Apache 2.0 to a choice of Server Side Public License (SSPL) or the non-open source Elastic license. Like most open source licensing changes, this one prompted a lot of discussion. …Clickhouse5 min read
Published in Altinity·Jun 1Migrating Data from Snowflake to ClickHouse using S3 and ParquetSnowflake is now the most popular SQL data warehouse according to the influential DB Engines site. That said, ClickHouse is catching up rapidly and is now the leading open source competitor. ClickHouse offers consistent low latency response, freedom to run anywhere, and outstanding cost efficiency. …Clickhouse10 min read
Published in Altinity·Mar 14Fixing the Dreaded ClickHouse Crash Loop on KubernetesAs countless ClickHouse users have learned, Kubernetes is a great platform for data. It’s portable to almost every IT environment. Managed Kubernetes services like Amazon EKS simplify operation. And the Altinity Kubernetes Operator for ClickHouse lets you start complex ClickHouse clusters from a single resource file. But there’s still the…Clickhouse9 min read
Published in Altinity·Mar 14Loading 100B Rows in Minutes in Altinity.CloudA few weeks ago the SingleStore team published interesting research in their blog. They demonstrated how to load 100 billion rows in a database in 10 minutes. …Clickhouse10 min read
Published in Altinity·Mar 3ClickHouse Black Magic: Skipping IndicesWritten with Lead Support Engineer Mikhail Filimonov. And in such indices, although small pricks To their subsequent volumes, there is seen The baby figure of the giant mass Of things to come at large. -William Shakespeare ClickHouse indices are different from traditional relational database management systems (RDMS) in that: Primary…Clickhouse9 min read
Published in Altinity·Jan 21Altinity Introduces macOS Homebrew Tap for ClickHouseIf you are a technical person and use a Mac, it is virtually a given that the first thing you do on a fresh machine is install the Homebrew package manager. Nearly everything that is available through Homebrew can be installed manually by building from sources or just unpacking the…Clickhouse8 min read
Published in Altinity·Jan 14Database on Fire: Reflections on Embedding ClickHouse in FireboltThere’s no better place to learn about databases on the web than the awesome CMU Database Group YouTube channel maintained by Andy Pavlo. Fall 2021 was no exception with the Vaccination Database Talks, Second Dose series. …Clickhouse11 min read
Published in Altinity·Jan 7Connecting ClickHouse to External Data Sources using the JDBC BridgeLike a bridge over troubled water I will lay me down Paul Simon ClickHouse is a piece of art. It is very fast and efficient. In real applications, however, ClickHouse is never used as a standalone — it integrates with other data sources and exposes query results to applications. OLAP…Clickhouse7 min read
Published in Altinity·Dec 15, 2021Lessons on Building Analytic Applications with Altinity.Cloud2021 has been a great year for Altinity.Cloud. Cloud users have grown to almost a third of our total subscription base. During that time both we and our customers have absorbed lessons on using ClickHouse effectively in the cloud. So what have we learned? …Clickhouse4 min read
Published in Altinity·Dec 14, 2021Altinity.Cloud Extends Managed ClickHouse to ARMARM processors are hot. Amazon AWS and Apple have been building their own ARM processors for a few years already. They use them in servers and notebooks and get outstanding results. Ampere builds server-class ARM processors for everybody else. At Altinity we could not stand aside from this A-march. …Clickhouse5 min read