Querying archive files with 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.