Mark Needham Principal Product Marketing Manager, ClickHouse
In this video, we'll learn about dynamic column selection in SQL with ClickHouse, using the New York taxi dataset. We’ll learn how to use the COLUMNS clause to return columns by regex, before showing how to apply functions to aggregate data and format results. We'll also learn how to modify the values of columns, as well as excluding fields that we don't want.
ClickHouse, How to
Powering Feature Stores with ClickHouse
Mark Needham Principal Product Marketing Engineer, ClickHouse
How to
Querying archive files with ClickHouse
Mark Needham Principal Product Marketing Manager, ClickHouse
How to
Importing Numpy array files into ClickHouse
Mark Needham Principal Product Marketing Manager, ClickHouse
Follow us
Products
Comparisons
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.