ClickHouse Window Functions — Current State of the Art

ClickHouse Window Functions — Current State of the Art

Window functions have long been a top feature request in ClickHouse. Thanks to excellent work by Alexander Kuzmenkov, ClickHouse now has experimental support, and users can begin to try them out.

Learn about this long-awaited feature and how it works, based on extensive QA work at Altinity.

Integrating ClickHouse with LDAP (Part Two)

Integrating ClickHouse with LDAP (Part Two)

This article continues to explore ClickHouse LDAP integration, focusing on how enterprises can unify their ClickHouse installations with the rest of their services that use LDAP.

Integrating ClickHouse with LDAP (Part One)

Integrating ClickHouse with LDAP (Part One)

ClickHouse has traditionally used XML configuration files to define server configuration including all database users. The users.xml configuration file or separate configuration files inside the /etc/clickhouse-server/users.d directory define users and properties associated with them such as profiles, network restrictions, quotas, and passwords. This approach works well for small organizations and installations but makes it hard[…]