v.20.12New Feature

Add New Math Functions to ClickHouse

Official CH changelog text
Add new math functions: acosh, asinh, atan2, atanh, cosh, hypot, log1p, sinh. #16636 (Konstantin Malanchev).
Added new mathematical functions acosh, asinh, atan2, atanh, cosh, hypot, log1p, and sinh to ClickHouse.

Why it matters

These functions extend ClickHouse's mathematical capabilities by providing commonly used hyperbolic and advanced math functions that were previously unavailable. This enables users to perform a wider range of mathematical computations directly within SQL queries, improving convenience and reducing the need for external processing.

How to use it

Users can utilize the new functions directly in their SQL queries by calling them with the appropriate syntax, for example:

SELECT acosh(column), atan2(y, x), log1p(value) FROM table

No additional configuration or setup is required to use these functions once the new version including this feature is installed.

Related resources

PreviousNext