v.18.12New Feature

Decimal Type Enhancements: Support for Mathematical Functions

Official CH changelog text
The Decimal type now supports mathematical functions (exp, sin and so on.) #3129
The Decimal data type in ClickHouse now supports various mathematical functions such as exp, sin, and others.

Why it matters

This feature enables users to perform precise mathematical calculations directly on Decimal type columns without needing to cast them to other data types, improving both accuracy and performance for numeric computations.

How to use it

Users can directly apply supported mathematical functions like exp(), sin(), etc., to Decimal columns in their SQL queries, for example:

SELECT exp(decimal_column), sin(decimal_column) FROM table

Related resources

PreviousNext