Videos / How To

Querying archive files with ClickHouse

Mark Needham Principal Product Marketing Manager, ClickHouse

In this video, we’ll learn how to query archive files directly using ClickHouse. We’ll start by learning about the ‘One’ input format that returns a list of files that match a glob expression on a ZIP file. We then show how to describe and ingest different CSV files into ClickHouse, before joining the datasets together. And along the way we learn how to deal with inconsistencies in the CSV data.

Follow us
Twitter imageSlack imageGitHub image
Telegram imageMeetup imageRss image
© 2024 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.