Webinar Slides: ClickHouse on Kubernetes!

Robert Hodges

Slides for the Webinar, presented on April 16, 2019 
For the webinar video visit https://altinity.com/webinarspage/2019/3/7/a-fast-intro-to-fast-query-with-clickhouse

Data services are the latest wave of applications to catch the Kubernetes bug. Altinity is pleased to introduce the ClickHouse operator, which makes it easy to run scalable data warehouses on your favorite Kubernetes distro. This webinar shows how to install the operator and bring up a new data warehouse in three simple steps. We also cover storage management, monitoring, making config changes, and other topics that will help you operate your data warehouse successfully on Kubernetes. There is time for demos and Q&A, so bring your questions. See you online!

Madrid ClickHouse Meetup Report

Madrid ClickHouse Meetup Report

Robert Hodges

The Madrid ClickHouse Meetup is over. Having attended in person I can report it was excellent: well-organized with great content. The meetup venue was the Google for Startups Campus, which has a comfortable auditorium capable of holding over 100 attendees. Between the venue and quality of the talks, it was more like a mini-conference than a meetup.

ClickHouse Networking, Part 2

ClickHouse Networking, Part 2

Robert Hodges

This post in two parts provides an overview of ClickHouse network configuration with lots of examples. In the first post we describe the overall connectivity design and configuration of listeners and ports. In the second post we describe how to enable encryption, solutions to common problems, and further reading.

ClickHouse Networking, Part 1

ClickHouse Networking, Part 1

Robert Hodges

This post in two parts provides an overview of ClickHouse network configuration with lots of examples. In the first post we describe the overall connectivity design and configuration of listeners and ports. In the second post we describe how to enable encryption, solutions to common problems, and further reading.

Webinar Slides: A Fast Intro to Fast Query with ClickHouse

Robert Hodges

Slides for the Webinar, presented on March 6, 2019 
For the webinar video click here

Extracting business insight from massive pools of machine-generated data is the central analytic problem of the digital era. ClickHouse data warehouse addresses it with sub-second SQL query response on petabyte-scale data sets. In this talk we’ll discuss the features that make ClickHouse increasingly popular, show you how to install it, and teach you enough about how ClickHouse works so you can try it out on real problems of your own. We’ll have cool demos (of course) and gladly answer your questions at the end. 

ClickHouse and Python: Jupyter Notebooks

ClickHouse and Python: Jupyter Notebooks

Robert Hodges

Jupyter Notebooks are an indispensable tool for sharing code between users in Python data science. For those unfamiliar with them, notebooks are documents that contain runnable code snippets mixed with documentation. They can invoke Python libraries for numerical processing, machine learning, and visualization. The code output includes not just text output but also graphs from powerful libraries like matplotlib and seaborn. Notebooks are so ubiquitous that it’s hard to think of manipulating data in Python without them.

ClickHouse support for Jupyter Notebooks is excellent. I have spent the last several weeks playing around with Jupyter Notebooks using two community drivers: clickhouse-driver and clickhouse-sqlalchemy. The results are now published on Github at https://github.com/Altinity/clickhouse-python-examples. The remainder of this blog contains tips to help you integrate ClickHouse data to your notebooks.

ClickHouse and Python: Getting to Know the Clickhouse-driver Client

ClickHouse and Python: Getting to Know the Clickhouse-driver Client

Robert Hodges

Python is a force in the world of analytics due to powerful libraries like numpy along with a host of machine learning frameworks. ClickHouse is an increasingly popular store of data. As a Python data scientist you may wonder how to connect them. This post contains a review of the clickhouse-driver client.  It’s a solidly engineered module that is easy to use and integrates easily with standard tools like Jupyter Notebooks and Anaconda.  Clickhouse-driver is a great way to jump into ClickHouse Python connectivity.