# New functions you might have missed in 2025

DevFeed: [New functions you might have missed in 2025](<https://devfeed.tech/articles/new-functions-you-might-have-missed-in-2025-5444.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/new-functions-2025>)

Author: Mark Needham

Published: 2025-12-23T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Code](<https://devfeed.tech/topics/code.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [data](<https://devfeed.tech/topics/data.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>)

Tags: [2025](<https://devfeed.tech/tags/2025.md>), [blog](<https://devfeed.tech/tags/blog.md>), [blog-post](<https://devfeed.tech/tags/blog-post.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [code](<https://devfeed.tech/tags/code.md>), [cryptographic](<https://devfeed.tech/tags/cryptographic.md>), [data](<https://devfeed.tech/tags/data.md>), [integrity](<https://devfeed.tech/tags/integrity.md>)

## AI overview

This article highlights selected ClickHouse functions introduced in 2025, including functions for pattern matching in map values, calculating geometry perimeters, and generating HMAC signatures. It also shows queries for counting and listing newly introduced functions.

## Source excerpt

Over 100 functions were added to ClickHouse in 2025. These were some of my favorites.