Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Wednesday, May 12 • 08:00 - 08:30
Projections in ClickHouse

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Projections are collections of table columns with different physical layout to speed up queries. They are the main constructs of Vertica. At kuaishou.com we have implemented PROJECTIONs support for ClickHouse. It boosts our OLAP analytic capabilities by an order of magnitude. This talk will highlight the design considerations, some implementation details, how it is integrated into ClickHouse design. Examples and demo of the feature will be shown

avatar for Amos Bird

Amos Bird

software engineer, kuaishou.com
Amos Bird (郑天祺) is a software engineer at KuaiShou Technologies in China. He graduated from the Institute of Computing Technology, Chinese Academy of Science, with a Doctor's degree in Database Systems. He is an active ClickHouse contributor for over more than three years, and... Read More →

Wednesday May 12, 2021 08:00 - 08:30 EDT
Room #7