Projections in ClickHouse

Amos Bird - kuaishou.com - Percona Live - Altinity Community Track

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

Video

Link: https://youtu.be/jJ5VuLr2k5k

Speakers

Amos Bird (郑天祺)

kuaishou.com, Software Engineer

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 have accomplished some major improvements such as PROJECTIONs, ClickHouse-ETL, Balanced JBOD with HA, StringHashMap, etc.

See all talks by Amos Bird (郑天祺) »

✎ Edit this page on GitHub