March 2022 Summaries

ClickHouse, Inc., the company behind the popular analytics database ClickHouse, strongly condemns Russia's invasion of Ukraine and stands united with all Ukrainians who have been affected by the war. The company, which has no operations or investors in Russia, was formed through a partnership with Yandex NV, a Dutch company with operations in Russia, and has since relocated its Russian engineering team to Amsterdam. ClickHouse's CEO Aaron Katz and other executives have spoken out against the invasion, with Katz describing it as "sensible and unprovoked" and Izrailevsky saying it defies belief. The company has also expressed support for humanitarian efforts in Ukraine, including contributions to UNICEF and Voices of the Children. ClickHouse's founders and leadership emphasize their commitment to building a global community and technology that is open to everyone, without borders or conflicts.

BENOCS uses ClickHouse to provide network traffic optimization and monitoring for telcos by leveraging fast indexing and fuzzy matching capabilities. The company's customers require fast access to specific time ranges while ignoring irrelevant data, which is achieved through ClickHouse's MergeTree table design and self-healing push architecture. Fuzzy matching, enabled by the _ASOF join feature in ClickHouse, simplifies queries by finding nearest matches instead of exact ones, allowing BENOCS to efficiently process vast amounts of data and build a stable analysis pipeline for its customers.

ClickHouse is celebrating International Women's Day by reflecting on this year's theme of #BreakTheBias, which emphasizes imagining a world free from bias, stereotypes, and discrimination. The company spoke to several employees about their experiences as women in technology, sharing memories, lessons learned, and hopes for the future. These women, representing various roles and backgrounds, discussed what inspired them to work in technology, who has contributed most to their careers, and tips for making teams more inclusive. They emphasized the importance of self-awareness, empathy, courage, and action in reducing bias and creating a culture of psychological safety. ClickHouse is proud to support women in technology and encourages everyone to get involved in promoting inclusivity and equity.

ClickHouse is celebrating International Women's Day by reflecting on the theme of #BreakTheBias, which aims to imagine a world free from bias, stereotypes, and discrimination. Two women, Maria Zhang and Caryn Marooney, shared their past experiences with bias, how trends are changing, and offered practical tips for companies and teams to form cultures of inclusion and belonging. They emphasized the importance of recognizing and challenging microaggressions, rotating responsibilities, and asking uncomfortable questions to ensure equal opportunities. Maria also highlighted the need for unconscious bias training and tracking mechanisms to drive visibility and awareness around inclusion. The conversation touched on the benefits of skills-based hiring, the impact of traditional caretaking roles carried by women, and the power of embracing one's true self to become a better leader.

ClickHouse v22.2 has been released, bringing several exciting features including production-ready projections, custom deduplication, and flexible memory limits. Projections allow users to store part of a table in a subdirectory with a different sorting key or aggregating the original data. Custom deduplication on insert allows for more control over deduplication, while default table engines can now be set, making it easier to create tables without specifying an engine. Ephemeral columns can be used at insert time to calculate other columns, and text classification functions have been added for detecting language, character set, tonality, and programming language. Implicit casting in dictGet* functions simplifies queries. Meetups and webinars have taken place, including a virtual meetup with Contentsquare and a webinar on the new features released in v22.02. Upcoming webinars include the ClickHouse v22.3 release webinar. The Query of the Month highlights the power of window functions, showcasing examples such as comparing cohort averages, finding previous records, and sorting with window functions. Reading Corner features articles on scaling out ClickHouse clusters, analyzing financial data with ClickHouse, and the latest ClickHouse release blog post. New adopters include Gigasheet.